Any set of one or more attributes that collectively allow us to uniquely identify tuples in a relation is termed as a what? MCQ with Answer and Explanation

Any set of one or more attributes that collectively allow us to uniquely identify tuples in a relation is termed as a what?
A. Secondary Key
B. Super Key
C. Local Key
D. Foreign Key
Answer: Option B
Solution (By JKExamLibrary)
A Super Key is any set of attributes within a table that can uniquely identify a row. A candidate key is a minimal super key.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error
Which of the following is a DML statement?
A. UPDATE
B. DROP
C. CREATE
D. ALTER

Correct Answer: Option A


Explanation:
UPDATE is a Data Manipulation Language (DML) command used to modify existing records in a table. CREATE, ALTER, DROP are DDL.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
Which of the following ensures data integrity in RDBMS?
A. User input without checks
B. No validation rules
C. Constraints like primary key, foreign key
D. Random data entry

Correct Answer: Option C


Explanation:
Integrity constraints such as keys enforce rules for valid data.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
Which SQL keyword is used to remove a table from the database?
A. TRUNCATE
B. DROP
C. REMOVE
D. DELETE

Correct Answer: Option B


Explanation:
DROP TABLE is a DDL command that deletes the table and its structure from the database.

This question belongs to: Computer Database Management System (DBMS)