Question : Which key uniquely identifies each row in a table?
Solution :
Correct Answer : Primary Key
Description -
Question : A foreign key is mainly used to:
Solution :
Correct Answer : Create relationship between tables
Description -
Question : Which key cannot contain NULL values?
Solution :
Correct Answer : Primary Key
Description -
Question : Which key can be made using multiple columns?
Solution :
Correct Answer : Composite Key
Description -
Question : Which statement is true for Unique Key?
Solution :
Correct Answer : Ensures uniqueness
Description -
Question : A candidate key not selected as primary key is called:
Solution :
Correct Answer : Alternate Key
Description -
Question : Which key maintains referential integrity?
Solution :
Correct Answer : Foreign Key
Description -
Question : How many primary keys can a table have?
Solution :
Correct Answer : One
Description -
Question : Which key may contain NULL values?
Solution :
Correct Answer : Unique Key
Description -
Question : Which SQL command creates a primary key?
Solution :
Correct Answer : PRIMARY KEY
Description -
Question : What is the main purpose of a primary key?
Solution :
Correct Answer : Identify records uniquely
Description -
Question : Which key references a primary key in another table?
Solution :
Correct Answer : Foreign Key
Description -
Question : Which key is formed by combining two or more columns?
Solution :
Correct Answer : Composite Key
Description -
Question : Which of the following can be an alternate key?
Solution :
Correct Answer : A candidate key not chosen as primary key
Description -
Question : Which SQL constraint prevents duplicate values?
Solution :
Correct Answer : UNIQUE
Description -
Question : Which key helps establish parent-child relationship?
Solution :
Correct Answer : Foreign Key
Description -
Question : Which key is automatically indexed in most DBMS?
Solution :
Correct Answer : Primary Key
Description -
Question : Which of the following is true about composite key?
Solution :
Correct Answer : Uses multiple columns
Description -
Question : Which constraint is used to define foreign key?
Solution :
Correct Answer : FOREIGN KEY
Description -
Question : Which key ensures entity integrity?
Solution :
Correct Answer : Primary Key
Description -