question What is the purpose of the Oracle UNION operator

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

Which SQL Server statement is used to update values in a table based on a condition?

A. UPDATE VALUES
B. MODIFY VALUES
C. SET VALUES
D. UPDATE SET

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

In SQL Server, what does the term "ACID" stand for in the context of transactions?

A. Atomicity, Consistency, Isolation, Durability
B. Association, Consistency, Isolation, Dependency
C. Atomicity, Consistency, Integration, Durability
D. Association, Commitment, Isolation, Dependency

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

What is the purpose of the SQL LEFT JOIN clause?

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

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

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

In SQL Server, what is the purpose of the SQL Server FLOAT data type?

A. Stores binary data
B. Stores integer values
C. Stores floating-point numbers
D. Stores a list of values

Which SQL Server statement is used to create a new table in a database?

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

Which MySQL statement is used to change the structure of an existing table?

A. MODIFY TABLE
B. CHANGE TABLE
C. ALTER TABLE
D. UPDATE TABLE

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise