What type of join produces a Cartesian product, matching every single row of the first table with every single row of the second 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 difference between DELETE and TRUNCATE commands?
Correct Answer: Option A
Explanation:
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is a database lock?
Correct Answer: Option D
Explanation:
Locking is a concurrency control mechanism that ensures data integrity during simultaneous transactions.
Locking is a concurrency control mechanism that ensures data integrity during simultaneous transactions.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which type of JOIN returns all matching rows from both tables, plus all unmatched rows from the left table with NULL values filled in for the right table columns?
Correct Answer: Option C
Explanation:
A Left Outer Join preserves all records from the left table, matching them with right table records when possible, or inserting NULL values if no match is found.
A Left Outer Join preserves all records from the left table, matching them with right table records when possible, or inserting NULL values if no match is found.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!