Which of the following is an example of DML command? 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 purpose of the SQL 'JOIN' clause?
Correct Answer: Option A
Explanation:
JOIN is used to combine rows from different tables based on a common column, allowing querying across related tables.
JOIN is used to combine rows from different tables based on a common column, allowing querying across related tables.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which type of JOIN combines all rows from the left table and all rows from the right table, filling in NULLs wherever a match is missing on either side?
Correct Answer: Option A
Explanation:
A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.
A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the default sorting order when using the ORDER BY clause in an SQL statement?
Correct Answer: Option B
Explanation:
By default, the ORDER BY clause sorts the query results in ascending order unless specified otherwise using the DESC keyword.
By default, the ORDER BY clause sorts the query results in ascending order unless specified otherwise using the DESC keyword.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!