Q. _______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

View solution

Q. Which of the following is not a state in transaction ?

View solution

Q. _______________ joins are SQL server default

View solution

Q. The ________________ is essentially used to search for patterns in target string.

View solution

Q. Which of the following is/are the Database server functions?
i) Data management ii) Transaction management

iii) Compile queries iv) Query optimization

View solution

Q. To delete a database ___________ command is used

View solution

Q. ____________ is a combination of two of more attributes used as a primary key

View solution

Q. Which of the following is not the function of client?

View solution

Q. ____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.

View solution

Q. ______________ requires that data should be made available to only authorized users.

View solution

Q. Some of the utilities of DBMS are _____________

i) Loading ii) Backup iii) File organization iv) Process Organization

View solution

Q. ____________ allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.

View solution

Q. Which is essential a business problem not a data problem:

View solution

Q. Which is primarily the result of a thorough understanding of information about an enterprise:

View solution

Q. McFadden has defined normalization in his which book___________

View solution

Q. The database design prevents some data from being represented due to _______

View solution

Q. How many types of insertion anomalies:

View solution

Q. Who developed the normalization process:

View solution

Q. E.F.Codd developed the normalization process in the which early:

View solution

Q. Which is the process of breaking a relation into multiple relations:

View solution