Which of the following is a benefit of DBMS? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What is the purpose of a Foreign Key?
Correct Answer: Option C
Explanation:
A foreign key establishes a relationship between tables and maintains referential integrity.
A foreign key establishes a relationship between tables and maintains referential integrity.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is a primary key in a database table?
Correct Answer: Option C
Explanation:
A primary key is a column or set of columns that uniquely identifies each row in a table, ensuring entity integrity.
A primary key is a column or set of columns that uniquely identifies each row in a table, ensuring entity integrity.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which type of database storage anomaly occurs when adding new data to a table is blocked because other unrelated data is missing?
Correct Answer: Option A
Explanation:
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!