question Which Oracle statement is used to grant specific privileges to a user

Database

Which Oracle statement is used to grant specific privileges to a user?

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

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

Which Oracle statement is used to create a sequence?

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

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 Oracle TRUNCATE TABLE statement?

A. Remove specific records
B. Remove all records and reset auto-increment
C. Remove duplicate records
D. Remove NULL 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

What is the purpose of the Oracle NVL() function?

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

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

What is the purpose of the Oracle DUAL table?

A. Store binary data
B. Store XML data
C. Provide a one-row, one-column table for selecting expressions
D. Store numeric values

What does T-SQL stand for in the context of SQL Server?

A. Table Structured Query Language
B. Transactional SQL
C. Transact-SQL
D. Table SQL

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

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