Which of the following is true about a surrogate key? MCQ with Answer and Explanation

Question
Which of the following is true about a surrogate key?
A. It is a composite key
B. It is a foreign key
C. It is a natural key derived from the data
D. It is an artificial key, usually an auto-increment integer, with no business meaning
Answer: Option D
Solution (By JKSSB Mock Tests)
A surrogate key is a system-generated unique identifier, typically numeric, that has no business significance.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What happens when a database transaction triggers a 'COMMIT' statement?
A. The database structure is dropped.
B. The transaction is aborted and wiped.
C. All changes made by the transaction are made permanent on disk storage.
D. The transaction pauses temporarily.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Executing a COMMIT statement instructs the database engine to save all data updates performed during the transaction permanently into physical storage.
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following commands is a Data Manipulation Language (DML) statement?
A. COMMENT
B. RENAME
C. UPDATE
D. TRUNCATE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.
This question belongs to: Computer Database Management System (DBMS)
Question #3
In SQL, what does the 'IS NULL' operator check?
A. Whether a value is empty string
B. Whether a value is zero
C. Whether a value is missing (null)
D. Whether a value equals NULL
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
IS NULL is used to test for NULL values, because NULL is not equal to anything.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Operating Systems 510 Memory and Storage Devices 438 CPU (Central Processing Unit) 327 Computer Software 347 Computer Fundamentals 326
Explore Subjects
Science 4430 Maths 5575 History GK 3374 Computer 5279 English 15164
Practice Mix
Which soil is generally found along the foothills of the Himalayas?
The Coromandel Coast receives most of its rainfall from:
Which of these is a famous folk dance of Tripura?
The 'BCCI' stands for:
What does the term 'cache hit' refer to?