Answer-What is the purpose of the SQL 'UNION' operator?

The UNION operator is used to combine the results of two or more SELECT queries into a single result set, removing duplicates.

Question

What is the purpose of the SQL "UNION" operator?

A To combine two or more tables into one table Correct Incorrect

B To combine the results of two or more SELECT queries into a single result set Correct Incorrect

C To retrieve data from multiple tables using a single query Correct Incorrect

D To create a temporary table in the database Correct Incorrect

E None of these Correct Incorrect

The "UNION" operator is used to combine the results of two or more SELECT queries into a single result set, removing duplicates.

Which normal form deals with the issue of transitive dependencies?
What does the term "referential integrity" mean in a database context?
Which of the following concurrency control techniques allows multiple transactions to read data simultaneously but ensures that only one transaction can wr...
What is the purpose of the SQL "HAVING" clause?
In a relational database, a foreign key is used to:
In database management, which SQL command is used to remove a table and all its data from a database?
Which of the following memories has the shortest access times?
Which of the following joins returns all rows from both tables, filling in NULL values for non-matching rows?
Which tier uses application server
Which type of database backup only includes the data that has changed since the last full backup?

Please enter email id The email must be a valid email address.

Please enter Mobile Number Please enter valid Mobile Number

Please enter your Doubt

Thank You for posting your query. Please check your email for further guidance.