question In Oracle what is the purpose of the BITAND function

Database

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

'BITAND()' is used to perform a bitwise AND operation on two numbers in Oracle.

Which SQL statement is used to change the value of an existing record in a table?

A. MODIFY
B. CHANGE
C. UPDATE
D. SET

Which MySQL statement is used to delete a database?

A. DELETE DATABASE
B. DROP DATABASE
C. REMOVE DATABASE
D. DESTROY DATABASE

What does the SQL NOT NULL constraint do?

A. Allows NULL values
B. Prevents NULL values
C. Sorts values in descending order
D. Groups 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

What is the purpose of the SQL Server DISTINCT keyword?

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

Which SQL Server statement is used to create a new table in a database?

A. CREATE TABLE
B. NEW TABLE
C. ADD TABLE
D. INSERT TABLE

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

A. MyISAM
B. InnoDB
C. MEMORY
D. ARCHIVE

What is the purpose of the SQL HAVING clause?

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

What is the purpose of the SQL Server AVG() function?

A. Find the average value
B. Find the total number of rows
C. Find the highest value
D. Find the lowest value

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

A. MAX()
B. HIGH()
C. TOP()
D. HIGHEST()