Current Affair Quiz Questions

Q1- The stored procedure in database which automatically invoked whenever a special event in the database occurs known as ____________.
A) PreprocedureB) Views
C) TriggerD) Schema
Ans:-  Trigger
Q2- An artificial key which aims to uniquely identify each record is called.
A) Surrogate keyB) Normal key
C) Composite keyD) Alternate key
Ans:-  Surrogate key
Q3- Which entity set that does not contain sufficient attributes to form its primary key?
A) Strong entity setB) Weak entity set
C) Both a and bD) None of these
Ans:-  Weak entity set
Q4- Periodically adding, changing and deleting file records is called file.
A) UpdatingB) Formatting
C) RestructuringD) Renewing
Ans:-  Updating
Q5- Which of the following is not a logical data-base structure?
A) treeB) relational
C) networkD) chain
Ans:-  chain
Q6- In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
C) COMMITD) None of these
Q7- Which type of database has key concept of the system is edge or relationship?
A) Distributed DatabaseB) NoSQL Database
C) Graph DatabaseD) Cloud Database
Ans:-  Graph Database
Q8- Which SQL condition used to dispaly Names that starts with "a" and ends with "o"?
A) LIKE 'a%o'B) LIKE 'o%a_'
C) LIKE 'ao%'D) LIKE 'a_o%'
Ans:-  LIKE 'a%o'
Q9- Which command used to copy one table into a new table in SQL ?
C) SELECT *INTOD) None of these
Q10- Which database software doesn't support comments?
A) Microsoft AccessB) Microsoft's SQL Server
C) OracleD) All of them
Ans:-  Microsoft Access