Which software utility serves as an interface between an application program and the physical database files? 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 a candidate key in a relation?
Correct Answer: Option A
Explanation:
A candidate key is a minimal super key, meaning no subset of it can uniquely identify a row.
A candidate key is a minimal super key, meaning no subset of it can uniquely identify a row.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which normal form requires that every determinant is a candidate key?
Correct Answer: Option C
Explanation:
Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF where every determinant must be a candidate key.
Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF where every determinant must be a candidate key.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is a foreign key in a database table?
Correct Answer: Option D
Explanation:
A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between tables.
A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between tables.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!