What geometric symbol is used in an Entity-Relationship (ER) diagram to represent a relationship between entities? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
In the context of databases, what is a 'tuple'?
Correct Answer: Option D
Explanation:
In relational databases, a tuple is a single row or record of a table.
In relational databases, a tuple is a single row or record of a table.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which SQL command is used to permanently remove an entire table structure along with all its data from the database?
Correct Answer: Option C
Explanation:
The DROP command is a DDL statement that completely removes a table's structure, definition, and all its associated data from the database.
The DROP command is a DDL statement that completely removes a table's structure, definition, and all its associated data from the database.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the default behavior of a foreign key when a referenced row is deleted?
Correct Answer: Option A
Explanation:
The behavior is defined by the ON DELETE rule (CASCADE, SET NULL, RESTRICT, NO ACTION) specified in the foreign key constraint.
The behavior is defined by the ON DELETE rule (CASCADE, SET NULL, RESTRICT, NO ACTION) specified in the foreign key constraint.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!