Unit-1-Keys-2-Q&A

All the keys which are not primary key are called an ___________________.

• Unique key

• Candidate key

• Alternate Key.

• Foreign Key

The Primary key should be selected from the ___________keys.

• candidate

• foreign

• alternate

• super

________________ is a column that creates a relationship between two tables.

• PRIMARY KEY

• CANDIDATE KEY

• SUPER KEY

• FOREIGN KEY

Which Keys maintain data integrity ?

• Primary key

• Foreign key

• Candidate key

• None of the above

Is 'Foreign' a key word to declare foreign key

• True

• False

____________acts as a cross-reference between two tables as it references the primary key of another table

• Candidate keys

• Foreign keys

• Primary Keys

• All of the mentioned

_________________ is a combination of two or more columns that uniquely identify rows in a table.

• Compound Key

• Composite Key

• Candidate Key

• All the mentioned

An artificial key which aims to uniquely identify each record is called a __________________.

• Surrogate Key

• Composite Key

• Candidate Key

• Super Key

A DBMS key is an attribute or set of an attribute which helps to identify a ________ in a relation(table)

• field(table)

• column(tuple)

• row(tuple)

• None of the mentioned

Creating relationships between tables also known as ____________________________.

• Domain Integrity

• Entity Integrity

• User-Defined Integrity

• Referential Integrity