question In SQL Server what is the purpose of the LIKE operator

In SQL Server, what is the purpose of the HAVING clause?

A. Filter rows
B. Sort the result set
C. Filter groups
D. Combine rows into groups

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

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

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

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

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

What is the purpose of the SQL Server DISTINCT keyword?

A. Sort the result set
B. Filter rows
C. Eliminate duplicate values
D. Combine rows into groups

What is the purpose of the SQL Server CROSS APPLY operator?

A. Combine rows from two or more tables
B. Rotate rows into columns based on values in a specified column
C. Execute a table-valued function for each row
D. Sort the result set

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 CROSS JOIN clause?

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. Generates the Cartesian product of two tables

What is the purpose of the SQL Server SYSTEM_USER function?

A. Find the length of a string
B. Find the current user
C. Calculate the average value
D. Concatenate multiple rows

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