A key that consists of more than one attribute to uniquely identify rows in a table is called a what? MCQ with Answer and Explanation

A key that consists of more than one attribute to uniquely identify rows in a table is called a what?
A. Primary Key
B. Secondary Key
C. Composite Key
D. Foreign Key
Answer: Option C
Solution (By JKSSB Mock Tests)
When a primary key or unique key comprises two or more columns (attributes) combined together, it is known as a Composite Key.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which type of lock prevents other concurrent transactions from obtaining any form of lock on the same row, securing exclusive read and write access?
A. Implicit Lock
B. Exclusive Lock
C. Shared Lock
D. Static Lock

Correct Answer: Option B


Explanation:
An Exclusive Lock (X-lock) blocks all other locks, ensuring that only the transaction holding the lock can modify or read the protected resource.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following represents raw, unorganized, and unprocessed facts that lack contextual meaning?
A. Metadata
B. Knowledge
C. Data
D. Information

Correct Answer: Option C


Explanation:
Data refers to raw, unorganized, and unprocessed facts, figures, or symbols that do not convey a specific meaning on their own. When data is processed and organized, it becomes information.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What does the letter 'D' stand for in the widely accepted ACID properties of database transactions?
A. Data
B. Durability
C. Dependency
D. Definition

Correct Answer: Option B


Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability. Durability ensures that once a transaction commits, its changes survive system failures.

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