question Which Oracle statement is used to grant execute permissions on a stored procedure

Which SQL function is used to find the current user in MySQL?

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

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

In Oracle, what is the purpose of the BETWEEN operator?

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

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

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

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

What is the purpose of the Oracle SYS_CONTEXT function?

A. Concatenate multiple values
B. Find the length of a string
C. Retrieve the value of a parameter in the database context
D. Validate XML structure

What is the purpose of the SQL Server SET NOCOUNT ON statement?

A. Count the number of rows affected by a query
B. Suppress the count of the number of rows affected by a query
C. Count the total number of rows in a table
D. Disable the use of COUNT function

In SQL Server, what is the purpose of the IDENTITY property?

A. Establish a link between two tables
B. Automatically increments the value of a column
C. Enforce a unique constraint
D. Limit the number of rows returned

In SQL Server, what is the purpose of the SEQUENCE object?

A. Generate a sequence of numbers
B. Execute a set of statements in a loop
C. Define a cursor for record processing
D. Create a temporary table

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise