Which SQL keyword is placed immediately inside a SELECT statement or an aggregate function to eliminate duplicate rows from the output? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What happens when a database transaction triggers a 'COMMIT' statement?
Correct Answer: Option C
Explanation:
Executing a COMMIT statement instructs the database engine to save all data updates performed during the transaction permanently into physical storage.
Executing a COMMIT statement instructs the database engine to save all data updates performed during the transaction permanently into physical storage.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
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 A
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)
Question #3
Report Error
What is a subquery in database terminology?
Correct Answer: Option D
Explanation:
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!