Which of the following is a true statement about indexes? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which normal form is stricter than 3NF and is often described as a configuration where every determinant must be a candidate key?
Correct Answer: Option C
Explanation:
Boyce-Codd Normal Form (BCNF) is a stronger version of 3NF. A relation is in BCNF if, for every non-trivial functional dependency X -> Y, X is a candidate key.
Boyce-Codd Normal Form (BCNF) is a stronger version of 3NF. A relation is in BCNF if, for every non-trivial functional dependency X -> Y, X is a candidate key.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is the purpose of a database index?
Correct Answer: Option B
Explanation:
Indexes are primarily used to improve the speed of data retrieval, particularly for search queries.
Indexes are primarily used to improve the speed of data retrieval, particularly for search queries.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which of the following is an example of a DBMS?
Correct Answer: Option B
Explanation:
MySQL is a popular relational database management system (RDBMS). Excel is a spreadsheet, not a DBMS.
MySQL is a popular relational database management system (RDBMS). Excel is a spreadsheet, not a DBMS.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!