Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
Also checkout these categories
Thermo Electricity MCQ Airport Engineering MCQ Urothelial tumors of the upper & lower urinary tracts MCQ Machine Design MCQ Probability MCQ Radiologic Examination MCQ Basics of Economics MCQ Selenium automation MCQ Fill in the blanks MCQ Microsoft PowerPoint MCQ Excretory System MCQ Steam Boilers, Engines, Nozzles & Turbines MCQ
- Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
- The full form of GUI is _________
- The rule that a value of a foreign key must appear as a value of some specific table is called a
- _____ command can be used to modify a column in a table
- The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
- A top-to-bottom relationship among the items in a database is established by a
- The normal form that is not necessarily dependency preserving is
- A _____ is used to define overall design of the database
- DBMS helps achieve
- ______contains information that defines valid values that are stored in a column or data type.
- The graphical representation of a query is .
- Relational Algebra is
- Which of the following statement on the view concept in SQL is invalid?
- The common column is eliminated in
- For correct behaviour during recovery, undo and redo operation must be
- The transactions like adding an employee, enrolling a student in a course are examples of _______
- A transaction is in state after the final statement has been executed.
- A _____ is a logical unit of database processing that includes one or more data access operations that…
- As per equivalence rules for query transformation, selection operation distributes over
- The drawback of shadow paging technique are
- Which of the following is not a consequence of concurrent operations?
- A data type or format is specified for each _________
- A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
- DFD stands for
- ______is a special type of integrity constraint that relates two relations & maintains consistency across…
- Which two files are used during operation of the DBMS?
- In SQL the word natural can be used with
- Key to represent relationship between tables is called
- In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
- Which of the following is not a characteristic of a relational database model?