What is the correct answer?


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. Foreign Key

Related Questions

The ______ key of a relation is the attribute (column) or collection of… Precedence graphs help to find a _______ product was acquired by Informix, integrated into its RDBMS and… Which of the following ensures the atomicity of the transaction? The clause in SQL that specifies that the query result should be sorted… Isolation of the transactions is ensured by The concept of mapping of ______ entity types is the concept in which… In SQL the statement select * from R, S is equivalent to In SQL the word natural can be used with Wait-for graph is used for ………………… approach reduces time… Protection of data from unauthorized Disclosure results in loss of _______ If the closure of an attribute set is the entire relation then the attribute… Data items grouped together for storage purposes are called a The statement that is executed automatically by the system as a side effect… The middleware databases in which the business rules act are applicable… In SQL, testing whether a subquery is empty is done using By ______ an area on disk in certain ways, one can make it represent a… _____ command can be used to modify a column in a table ______ keyword is used to find the number of values in a column. The ______ indexes are forced to store only record IDs in the data structure… A ______ module is typically designed so that it will run on a user workstation… Which of the following is a reason to model data? A DBMS is a ____ user if at most one user can use the system and is mostly… If a transaction T has obtained an exclusive lock on item Q, then T can If two relations R and S are joined, then the non matching tuples of both… The data models defined by ANSI/SPARC architecture are The normal form that is not necessarily dependency preserving is In an E-R, Y is the dominant entity and X is a subordinate entity. Then… DFD stands for