question What is the purpose of the SQL LIKE operator

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

A. DIFFDATEDAYS()
B. DATEDIFF()
C. DIFFDATE()
D. DATE_DIFF()

In SQL Server, what does the term "ACID" stand for in the context of transactions?

A. Atomicity, Consistency, Isolation, Durability
B. Association, Consistency, Isolation, Dependency
C. Atomicity, Consistency, Integration, Durability
D. Association, Commitment, Isolation, Dependency

What is the purpose of the SQL Server TRY...CATCH block?

A. Execute a set of statements in a loop
B. Handle exceptions and errors in a controlled manner
C. Define a cursor for record processing
D. Create a temporary table

In SQL Server, what is the purpose of the GROUP BY clause?

A. Filter rows
B. Sort the result set
C. Combine rows into groups
D. Join multiple tables

In SQL Server, what is the purpose of the HAVING clause?

A. Filter rows
B. Sort the result set
C. Filter groups
D. Combine rows into groups

In Oracle, what is the purpose of the BITAND() function?

A. Concatenate multiple values
B. Perform bitwise AND operation on two numbers
C. Calculate the average value
D. Round numeric values

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

A. GRANT ALL PRIVILEGES
B. GRANT FULL ACCESS
C. GRANT SUPERUSER
D. GRANT ALL RIGHTS

Which SQL function is used to find the current user in MySQL?

A. GETUSER()
B. CURRENT_USER()
C. USER()
D. GET_CURRENT_USER()

What is the purpose of the Oracle UTL_FILE package?

A. Perform data manipulation tasks
B. Read and write files on the server's file system
C. Calculate the average value
D. Create triggers

In SQL Server, what is the purpose of the CROSS JOIN clause?

A. Combines rows from two or more tables
B. Retrieves all rows from a table
C. Retrieves rows that have no matching rows in the other table
D. Generates the Cartesian product of two tables

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise