DBMS -TRANSACTIONS MCQs

Database

Title
Which of the following is not a state in transaction
_______________ joins are SQL server default
The ________________ is essentially used to search for patterns in target string
Which of the following is/are the Database server functions
To delete a database ___________ command is used
____________ is a combination of two of more attributes used as a primary key
Which of the following is not the function of client
____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified
______________ requires that data should be made available to only authorized users
Some of the utilities of DBMS are _____________
____________ allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement
Which is essential a business problem not a data problem
Which is primarily the result of a thorough understanding of information about an enterprise:
McFadden has defined normalization in his which book___________
The database design prevents some data from being represented due to _______
How many types of insertion anomalies:
Who developed the normalization process:
E.F.Codd developed the normalization process in the which early:
Which is the process of breaking a relation into multiple relations:
Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas:

Questions

Views

Best Answers

Points