NEW
Font size
WorksheetsUnit-1-Keys-2-Q&A
Total questions: 10
Worksheet time: 3mins
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
