Which normal form eliminates all transitive dependencies? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What type of join returns all rows from the right table, paired with matching records from the left table, or filling in NULL values if no match is found?
Correct Answer: Option B
Explanation:
A Right Outer Join retains all rows from the right table, pairing them with matching left table entries or supplying NULL values if matches do not exist.
A Right Outer Join retains all rows from the right table, pairing them with matching left table entries or supplying NULL values if matches do not exist.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
How many fundamental rules did E.F. Codd define to determine whether a database system qualifies as a true relational database management system?
Correct Answer: Option B
Explanation:
E.F. Codd formulated 12 rules (numbered 0 to 11, often called Codd's 12 Rules) to evaluate relational database management systems.
E.F. Codd formulated 12 rules (numbered 0 to 11, often called Codd's 12 Rules) to evaluate relational database management systems.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which SQL command is used to create a new table?
Correct Answer: Option B
Explanation:
The CREATE TABLE command in DDL is used to define a new table structure in SQL.
The CREATE TABLE command in DDL is used to define a new table structure in SQL.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!