question Which Oracle function is used to find the current user

Database

Which Oracle function is used to find the current user?

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

'USER()' is used to find the current user in Oracle.

What is the purpose of the Oracle TRUNCATE TABLE statement?

A. Remove specific records
B. Remove all records and reset auto-increment
C. Remove duplicate records
D. Remove NULL values

Which Oracle 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

In Oracle, what is the purpose of the XMLType data type?

A. Stores XML data
B. Stores binary data
C. Stores integer values
D. Stores a list of values

In Oracle, what is the purpose of the MERGE statement?

A. Combine rows from two or more tables
B. Update, insert, or delete data based on a condition
C. Sort the result set
D. Join multiple tables

In Oracle, what is the purpose of the HAVING clause?

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

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

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

In Oracle, 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

Which MySQL statement is used to delete a database?

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

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

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

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

A. VARCHAR
B. TEXT
C. CLOB
D. CHAR