question What is the purpose of the SQL Server SYSTEM USER function

Database

What is the purpose of the SQL Server SYSTEM_USER function?

A. Find the length of a string
B. Find the current user
C. Calculate the average value
D. Concatenate multiple rows

'SYSTEM_USER' is used to find the current user in SQL Server.

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

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 statement is used to delete records from a table in SQL Server?

A. DELETE FROM table;
B. REMOVE * FROM table;
C. TRUNCATE TABLE table;
D. DROP TABLE table;

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

What is the purpose of the SQL LIKE operator?

A. Filter rows based on a condition
B. Sort the result set
C. Combine rows into groups
D. Search for a specified pattern in a column

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 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 MySQL, what is the purpose of the IFNULL() function?

A. Calculate the average value
B. Replace NULL values with a specified value
C. Concatenate multiple rows
D. Round numeric values

What is the purpose of the SQL Server SELECT TOP clause?

A. Filter rows
B. Sort the result set
C. Limit the number of rows returned
D. Join multiple tables

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

A. STRLEN()
B. LEN()
C. LENGTH()
D. STRINGLENGTH()