Login / Signup

Question

Which of the following statements about the UNION operator in SQL is correct?

A It combines results of two queries and includes duplicate rows

B It combines results of two queries and removes duplicate rows

C It can combine queries with different number of columns

D It works only with numeric data

E It sorts the result automatically in descending order

Practice Next

More IT Operating System Questions

Non-Final state in DFA is represented by :
What is the worst-case time complexity for searching an element in a general (unbalanced) binary tree?
Entities having primary key are called :
Which of these is an open-source container orchestration platform?
Which of the following statements accurately describes the use of the SQL CREATE statement?
When implementing Huffman Coding, a common issue arises if the generated codes are not unique prefixes (i.e., one code is a prefix of another, leading to a...
In object-oriented programming, when defining an interface method, which of the following statements is true regarding method parameters?
Which SQL command is primarily used to retrieve records from a database table?
The first step in the greedy Activity Selection problem is to sort the activities. Which criterion is used for sorting to ensure the greedy choice property...
Which access specifier makes members accessible only within the class itself?

Relevant for Exams:

Central Bank of India SO

Hey! Ask a query

ask-question