question In SQL Server what is the purpose of the HAVING clause

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

Which MySQL statement is used to create a unique constraint on a column?

A. UNIQUE
B. ADD UNIQUE
C. CONSTRAINT UNIQUE
D. CREATE CONSTRAINT

Which statement is used to remove all records from a table in MySQL?

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

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 does the SQL INNER JOIN clause do?

A. Combines rows from two or more tables
B. Retrieves all rows from a table
C. Retrieves rows that have no matching rows in the other table
D. Excludes specified rows

In MySQL, what is the purpose of the FOREIGN KEY constraint?

A. Ensures unique values in a column
B. Establishes a link between two tables
C. Limits the number of rows returned
D. Sets a default value for a column

In SQL Server, what is the purpose of the TRY_CONVERT() function?

A. Concatenate multiple values
B. Convert a value to a different data type and handle errors gracefully
C. Find the average value
D. Validate XML structure

What is the purpose of the SQL COALESCE() function?

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

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 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

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise