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

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  2. The full form of GUI is _________
  3. The rule that a value of a foreign key must appear as a value of some specific table is called a
  4. _____ command can be used to modify a column in a table
  5. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  6. A top-to-bottom relationship among the items in a database is established by a
  7. The normal form that is not necessarily dependency preserving is
  8. A _____ is used to define overall design of the database
  9. DBMS helps achieve
  10. ______contains information that defines valid values that are stored in a column or data type.
  11. The graphical representation of a query is .
  12. Relational Algebra is
  13. Which of the following statement on the view concept in SQL is invalid?
  14. The common column is eliminated in
  15. For correct behaviour during recovery, undo and redo operation must be
  16. The transactions like adding an employee, enrolling a student in a course are examples of _______
  17. A transaction is in state after the final statement has been executed.
  18. A _____ is a logical unit of database processing that includes one or more data access operations that…
  19. As per equivalence rules for query transformation, selection operation distributes over
  20. The drawback of shadow paging technique are
  21. Which of the following is not a consequence of concurrent operations?
  22. A data type or format is specified for each _________
  23. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  24. DFD stands for
  25. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  26. Which two files are used during operation of the DBMS?
  27. In SQL the word natural can be used with
  28. Key to represent relationship between tables is called
  29. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  30. Which of the following is not a characteristic of a relational database model?