question What does T SQL stand for in the context of SQL Server

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

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

Which SQL Server statement is used to create a stored procedure?

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

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

In Oracle, what is the purpose of the JOIN clause?

A. Combine rows from two or more tables
B. Retrieve all rows from the left table
C. Retrieve rows that have no matching rows in the right table
D. Exclude specified rows

What is the purpose of the SQL Server QUOTENAME() function?

A. Concatenate multiple strings
B. Quote an identifier to make it a valid SQL Server delimited identifier
C. Calculate the average value
D. Round numeric values

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

In SQL Server, what is the purpose of the CONTAINSTABLE function?

A. Perform full-text search
B. Concatenate multiple columns
C. Validate XML structure
D. Generate a sequence of numbers

In Oracle, what is the purpose of the ROLLBACK statement?

A. Save changes to the database
B. Undo changes made during the current transaction
C. Commit changes to the database
D. Delete records from the database

Which SQL Server statement is used to remove a user's privileges?

A. REMOVE PRIVILEGES
B. DELETE PRIVILEGES
C. DROP PRIVILEGES
D. REVOKE

In SQL Server, what is the purpose of the PI constant?

A. Mathematical constant representing the ratio of a circle's circumference to its diameter
B. Numeric constant representing the speed of light
C. Constant representing the number of days in a year
D. Constant representing the number of seconds in a minute

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise