On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 26

Q1 | Which of the following is an atomic sequence of database actions?
Q2 | If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
Q3 |                means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
Q4 | Which of the following is not a state in transaction?
Q5 |                                joins are SQL server default
Q6 | The                                  is essentially used to search for patterns in target string.
Q7 |                          is a combination of two of more attributes used as a primary key
Q8 | Which of the following is not the function of client?
Q9 |                          is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.
Q10 |                              requires that data should be made available to only authorized users.
Q11 |                          allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.
Q12 | Which s essential a business problem not a data problem:
Q13 | McFadden has defined normalization in his which book                       
Q14 | The database design prevents some data from being represented due to                
Q15 | How many types of insertion anomalies:
Q16 | Who developed the normalization process:
Q17 | E.F.Codd developed the normalization process in the which early:
Q18 | Which is the process of breaking a relation into multiple relations:
Q19 | Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
Q20 | Which is a duplicate copy of a file program that is stored on a different storage media than the original location:
Q21 | Which is the duplication of computer operations and routine backups to combat any unforeseen problems:
Q22 | Optimization basically related to the Rewrite module is termed as               
Q23 | Database security helps organizations to protect data from            
Q24 | Copying files to secondary or specific devices is known as              
Q25 | Which are types of recovery control techniques: