question In MySQL what is the purpose of the IFNULL function

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

What is the purpose of the SQL Server SET NOCOUNT ON statement?

A. Count the number of rows affected by a query
B. Suppress the count of the number of rows affected by a query
C. Count the total number of rows in a table
D. Disable the use of COUNT function

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

In Oracle, 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 statement is used to change the value of an existing record in a table?

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

In Oracle, 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

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

A. Concatenate multiple columns
B. Parse a string into a specified data type
C. Calculate the average value
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

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

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

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise