question In SQL Server what is the purpose of the CASE statement

Database

In SQL Server, what is the purpose of the CASE statement?

A. Filter rows based on a condition
B. Sort the result set
C. Combine rows into groups
D. Perform conditional logic in a query

The CASE statement is used to perform conditional logic in a query in SQL Server.

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

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

Which statement is used to delete records from a table in SQL Server?

A. DELETE FROM table;
B. REMOVE * FROM table;
C. TRUNCATE TABLE table;
D. DROP TABLE table;

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

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

Which SQL Server statement is used to remove an index from a table?

A. DELETE INDEX
B. REMOVE INDEX
C. DROP INDEX
D. ERASE INDEX

What is the default sorting order of the ORDER BY clause in SQL?

A. Ascending
B. Descending
C. Random
D. Alphabetical

In SQL Server, what is the purpose of the GROUP BY clause?

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

Which command is used to select all columns from a table named "employees"?

A. SELECT * FROM employees;
B. SELECT ALL FROM employees;
C. SHOW COLUMNS FROM employees;
D. DISPLAY employees;

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

Which SQL Server data type is used to store a date and time combination?

A. DATETIME
B. DATE
C. TIMESTAMP
D. TIME

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

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