Which SQL set operator combines the output of two queries but preserves all duplicate rows without filtering them? 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 a clustered index and a non-clustered index?
Correct Answer: Option C
Explanation:
A clustered index sorts and stores the data rows in the table based on key values, while a non-clustered index is a separate structure that points to the data rows.
A clustered index sorts and stores the data rows in the table based on key values, while a non-clustered index is a separate structure that points to the data rows.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which clause is used to assign a temporary alias name to a column or table in an SQL statement for better readability?
Correct Answer: Option A
Explanation:
The AS keyword is used to assign a temporary alias name to an expression, column, or table within an SQL statement query execution context.
The AS keyword is used to assign a temporary alias name to an expression, column, or table within an SQL statement query execution context.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
The total number of tuples (rows) contained within a relational database table is called its what?
Correct Answer: Option A
Explanation:
The number of tuples or rows in a relation is defined as the cardinality of that relation.
The number of tuples or rows in a relation is defined as the cardinality of that relation.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!