Which key establishes a logical relationship between two tables by referencing the primary key of another table? 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 role of the 'WHERE' clause in an UPDATE statement?
Correct Answer: Option C
Explanation:
The WHERE clause in UPDATE identifies the rows that will be updated. Without it, all rows would be updated.
The WHERE clause in UPDATE identifies the rows that will be updated. Without it, all rows would be updated.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is a property of a well-designed database?
Correct Answer: Option C
Explanation:
Good database design aims to minimize redundancy, simplify maintenance, and provide efficient access.
Good database design aims to minimize redundancy, simplify maintenance, and provide efficient access.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which of the following is a way to avoid redundancy in a database?
Correct Answer: Option A
Explanation:
Normalization reduces redundancy by organizing data into tables with minimal duplication.
Normalization reduces redundancy by organizing data into tables with minimal duplication.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!