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

Database

Which SQL Server statement is used to grant execute permissions on a stored procedure?

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

'GRANT EXECUTE' is used to grant execute permissions on a stored procedure in SQL Server.

What is the default storage engine in MySQL?

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

What is the purpose of the SQL WHERE clause?

A. Specify the columns to be selected
B. Filter rows based on a condition
C. Sort the result set
D. Join multiple tables

In MySQL, what is the purpose of the DESC keyword in an ORDER BY clause?

A. Sort in descending order
B. Specify a description
C. Sort in ascending order
D. Display columns

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 Oracle RANK() function?

A. Calculate the average value
B. Assign a rank to each row within a result set
C. Concatenate multiple rows
D. Find the length of a string

In MySQL, what is the purpose of the COUNT() function with DISTINCT?

A. Count all rows
B. Count only distinct rows
C. Count rows based on a condition
D. Count rows in a specific column

What is the purpose of the SQL ORDER BY clause?

A. Filter rows
B. Group rows
C. Sort the result set
D. Combine tables

Which SQL statement is used to insert new data into a table?

A. INSERT INTO
B. ADD DATA
C. UPDATE DATA
D. ADD INTO

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

A. Generate a random globally unique identifier
B. Concatenate multiple columns
C. Calculate the average value
D. Round numeric values

Which SQL statement is used to remove a table from a database?

A. DELETE TABLE
B. REMOVE TABLE
C. DROP TABLE
D. DELETE FROM TABLE