question Which SQL Server statement is used to create an index on a table

Database

Which SQL Server statement is used to create an index on a table?

A. ADD INDEX
B. CREATE INDEX
C. INDEX TABLE
D. ALTER INDEX

'CREATE INDEX' is used to create an index on a table in SQL Server.

What is the purpose of the SQL Server SELECT TOP clause?

A. Filter rows
B. Sort the result set
C. Limit the number of rows returned
D. Join multiple tables

What is the maximum length of the VARCHAR data type in MySQL?

A. 255
B. 512
C. 1024
D. It varies based on the version

What is the purpose of the SQL HAVING clause?

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

What is the purpose of the SQL 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 does T-SQL stand for in the context of SQL Server?

A. Table Structured Query Language
B. Transactional SQL
C. Transact-SQL
D. Table SQL

In MySQL, which storage engine supports transactions and ACID properties?

A. MyISAM
B. InnoDB
C. MEMORY
D. ARCHIVE

In MySQL, what is the purpose of the IFNULL() function?

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

Which SQL Server function is used to find the length of a string?

A. STRLEN()
B. LEN()
C. LENGTH()
D. STRINGLENGTH()

What is the purpose of the SQL DISTINCT keyword?

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

Which SQL function is used to find the current user in MySQL?

A. GETUSER()
B. CURRENT_USER()
C. USER()
D. GET_CURRENT_USER()