What is the default sorting order when using ORDER BY without specifying ASC or DESC? 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 normalization in database design?
Correct Answer: Option A
Explanation:
Normalization is the process of structuring a relational database to reduce data redundancy and dependency, typically by dividing large tables into smaller, related tables.
Normalization is the process of structuring a relational database to reduce data redundancy and dependency, typically by dividing large tables into smaller, related tables.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is a valid SQL statement to update a record?
Correct Answer: Option A
Explanation:
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which operator is used to combine the distinct result sets of two or more SELECT queries into a single output, automatically filtering out duplicate rows?
Correct Answer: Option D
Explanation:
The UNION operator merges the result sets of two queries, removing any duplicate records. UNION ALL performs a similar merge but retains duplicates.
The UNION operator merges the result sets of two queries, removing any duplicate records. UNION ALL performs a similar merge but retains duplicates.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!