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

Question

Share Report Error

Which of the following is true about a surrogate key?

A. It is a natural key derived from the data

B. It is an artificial key, usually an auto-increment integer, with no business meaning

C. It is a composite key

D. It is a foreign key

Answer: Option B

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

In SQL, what does the wildcard '%' match when used with LIKE?

A. A specific character

B. Any single character

C. Only digits

D. Any string of zero or more characters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
'%' matches any sequence of zero or more characters, while '_' matches a single character.

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

Question #2

Which of the following is an example of a NoSQL database?

A. Oracle

B. MySQL

C. PostgreSQL

D. MongoDB

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MongoDB is a document-oriented NoSQL database. PostgreSQL, MySQL, and Oracle are RDBMS.

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

Question #3

Who proposed the relational database model based on mathematical relation theory in 1970?

A. Charles Bachman

B. James Gosling

C. E.F. Codd

D. Dennis Ritchie

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Dr. Edgar Frank Codd (E.F. Codd) invented the relational model for database management while working for IBM in 1970.

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

Explore All Database Management System (DBMS) MCQs