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

Which SQL Server statement is used to rename a table?

A. RENAME TABLE
B. ALTER TABLE RENAME
C. ALTER TABLE RENAME TO
D. ALTER TABLE RENAME AS

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

What is the purpose of the SQL UNION operator?

A. Combine rows from two or more tables
B. Sort the result set
C. Combine rows into groups
D. Join multiple tables

What is the purpose of the Oracle NVL() function?

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

In Oracle, what is the purpose of the JOIN clause?

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

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

What is the purpose of the SQL IN operator?

A. Filter rows based on a range
B. Filter rows based on a list of values
C. Sort the result set
D. Join multiple tables

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

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

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

In MySQL, what is the purpose of the SHOW TABLES statement?

A. Display the structure of a table
B. Show the list of tables in a database
C. Display the content of a table
D. Show the indexes of a table

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise