What is the correct answer?


Key to represent relationship between tables is called

A. primary key

B. secondary key

C. foreign key

D. none of the above

Correct Answer :

C. foreign key

Related Questions

The statement that is executed automatically by the system as a side effect… DROP is a statement in SQL. Precedence graphs help to find a The fact that information in the data warehouse changes far less often… A transaction is in state after the final statement has been executed. Isolation of the transactions is ensured by The transactions like adding an employee, enrolling a student in a course… Which of the following is not a consequence of non-normalized database? The data models defined by ANSI/SPARC architecture are Drop Table cannot be used to drop a table referenced by a ______ constraint. In a relational schema, each tuple is divided into fields called Use of UNIQUE while defining an attribute of a table in SQL means that… Which of the following addressing modes permits relocation without any… A ____ key specifies a uniqueness constraint that no two distinct tuples… A ______ module is typically designed so that it will run on a user workstation… Which of the following aggregate functions does not ignore nulls in its… If both the functional dependencies : X�Y and Y�X hold for two attributes… An outstanding functionality of SQL is its support for automatic_____… Dependency preservation is not guaranteed in The rule that a value of a foreign key must appear as a value of some… Change Staff table by removing default of Assistant for position column The concept of mapping of ______ entity types is the concept in which… If an entity can belong to only one lower level entity then the constraint… The one guideline to be followed while designing the database is The collection of information stored in a database at a particular moment… In an E-R, Y is the dominant entity and X is a subordinate entity. Then… A relational database developer refers to a record as Union operator is a : operator is used to compare a value to a list of literals values that… A weak entity has an ______ dependency on its owner entity, which can…