Home

Drop Table cannot be used to drop a table referenced by a ______ constraint.

A. Primary Key

B. Local Key

C. Foreign Key

D. Composite Key

You can do it
  1. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  2. The data in the database at a particular moment of time is called the _______
  3. Which normal form is considered adequate for normal relational database design?
  4. Which is the best file organization when data is frequently added or deleted from a file?
  5. Which of the following statement on the view concept in SQL is invalid?
  6. Which of the following is not a consequence of concurrent operations?
  7. The normalization was first proposed by .
  8. In b-tree the number of keys in each node is than the number of its children.
  9. A table can have only one
  10. For correct behaviour during recovery, undo and redo operation must be
  11. ____specifies a search condition for a group or an aggregate.
  12. If the closure of an attribute set is the entire relation then the attribute set is a
  13. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  14. Which of the following is not a characteristic of a relational database model?
  15. Which of the following is true for network structure?
  16. The common column is eliminated in
  17. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  18. If a transaction T has obtained an exclusive lock on item Q, then T can
  19. In SQL the word natural can be used with
  20. Grant and revoke are _____ statements.
  21. In SQL, testing whether a subquery is empty is done using
  22. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  23. ………………… approach reduces time and effort required for design…
  24. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  25. DBMS helps achieve
  26. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  27. Which of the following is not comparison operator?
  28. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  29. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  30. In multiple granularity of locks SIX lock is compatible with