Database MCQS - QUESTION DETAILS
In Oracle, what is the purpose of the INTERSECT operator?
A. Combine rows from two or more tables
B. Rotate rows into columns based on values in a specified column
C. Find the common rows between two SELECT statements
D. Join multiple tables

The 'INTERSECT' operator is used to find the common rows between two SELECT statements in Oracle.

Similar Questions

Which MySQL data type is used to store large text values?





Which SQL function is used to find the highest value in a column?





Which MySQL statement is used to change the structure of an existing table?





Which MySQL statement is used to create a unique constraint on a column?





What is the purpose of the SQL DISTINCT keyword?





Which SQL function is used to find the lowest value in a column?





What is the purpose of the SQL Server CROSS APPLY operator?





Which SQL statement is used to add a new column to an existing table?





Which MySQL command is used to retrieve the definition of a table?





Which SQL function is used to find the length of a string?