Database MCQS - QUESTION DETAILS

In Oracle, what is the purpose of the BETWEEN operator?
A. Filter rows based on a range of values
B. Sort the result set
C. Combine rows into groups
D. Search for a specified pattern in a column

'BETWEEN' is used to filter rows based on a range of values in Oracle.

Similar Questions

In MySQL, what is the purpose of the FOREIGN KEY constraint?






In SQL Server, what is the purpose of the TRIGGER?






Which SQL Server function is used to find the difference between two dates?






Which SQL Server statement is used to add a new row to a table?






What is the purpose of the SQL COALESCE() function?






In MySQL, which storage engine supports transactions and ACID properties?






Which SQL Server statement is used to grant specific privileges to a user?






What is the purpose of the SQL DISTINCT keyword?






Which SQL Server statement is used to remove all records from a table and reset identity seed?






In SQL Server, what is the purpose of the SQL Server XML data type method value()?