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

Q. 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:

View solution