question Which SQL statement is used to grant specific privileges to a user in MySQL

Database

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

A. ALLOW PRIVILEGES
B. GRANT PRIVILEGES
C. GRANT
D. ALLOW ACCESS

'GRANT' is used to grant specific privileges to a user in MySQL.

In SQL Server, what is the purpose of the XML 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 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

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

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 Oracle statement is used to grant execute permissions on a stored procedure?

A. GRANT EXECUTE
B. GRANT EXECUTION
C. ALLOW EXECUTE
D. ALLOW EXECUTION

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 grant specific privileges to a user?

A. ALLOW PRIVILEGES
B. GRANT PRIVILEGES
C. GRANT
D. ALLOW ACCESS

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 SQL Server VARBINARY data type?

A. Stores binary data
B. Stores integer values
C. Stores floating-point numbers
D. Stores a list of values

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