What is a data dictionary in a DBMS? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Who proposed the relational database model based on mathematical relation theory in 1970?
Correct Answer: Option D
Explanation:
Dr. Edgar Frank Codd (E.F. Codd) invented the relational model for database management while working for IBM in 1970.
Dr. Edgar Frank Codd (E.F. Codd) invented the relational model for database management while working for IBM in 1970.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which SQL operator returns only the rows that are common and present in the outputs of both executing SELECT queries?
Correct Answer: Option D
Explanation:
The INTERSECT operator returns only the distinct rows that appear in the result sets of both SELECT statements.
The INTERSECT operator returns only the distinct rows that appear in the result sets of both SELECT statements.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which of the following is a valid way to join three tables in SQL?
Correct Answer: Option D
Explanation:
Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.
Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!