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

Correct Answer : C.


Download Objective type questions of DBMS PDF

Get all objective type questions of DBMS MCQ

Also checkout these categories

Chemical Engineering Plant Economics MCQ Alphabetical Series MCQ Alkyl and Aryl Halides MCQ Hydrogen- Water and Hydrogen Peroxide MCQ Pteridophyta MCQ Metallurgical Operations MCQ Syllogism MCQ Rearrangement Set 3 MCQ Theory of Machines MCQ Botany and Human Welfare MCQ Chemical Equilibrium MCQ Area MCQ

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

Submit
Load More..
You can do it
  1. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  2. Wait-for graph is used for
  3. In an ER model,_____ is described in the database by storing its data.
  4. The data models defined by ANSI/SPARC architecture are
  5. Which of the following is not a logical database structure?
  6. Checkpoints are a part of
  7. Which normal form is considered adequate for normal relational database design?
  8. When an E-R diagram is mapped to tables, the representation is redundant for
  9. Dependency preservation is not guaranteed in
  10. Which of the following is not a characteristic of a relational database model?
  11. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  12. ______contains information that defines valid values that are stored in a column or data type.
  13. DBMS helps achieve
  14. Grant and revoke are _____ statements.
  15. Which of the following concurrency control schemes is not based on the serializability property?
  16. The transactions like adding an employee, enrolling a student in a course are examples of _______
  17. SQL server stores index information in the _____system table
  18. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  19. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  20. Precedence graphs help to find a
  21. The drawback of shadow paging technique are
  22. In multiple granularity of locks SIX lock is compatible with
  23. Maximum height of a B+ tree of order m with n key values is
  24. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  25. An advantage of the database management approach is
  26. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  27. The clause alter table in SQL can be used to
  28. Tree structures are used to store data in
  29. The full form of GUI is _________
  30. In 2NF