question Which of the following MySQL functions is used to find the current date and time

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

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

A. Generate a random globally unique identifier
B. Concatenate multiple columns
C. Calculate the average value
D. Round numeric values

In Oracle, what is the purpose of the INTERSECT operator?

A. Combine rows from two or more tables
B. Rotate rows into columns based on values in a specified column
C. Find the common rows between two SELECT statements
D. Join multiple tables

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

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

Which Oracle function is used to find the current user?

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

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

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

Which SQL Server statement is used to grant specific privileges to a user?

A. ALLOW PRIVILEGES
B. GRANT PRIVILEGES
C. GRANT
D. ALLOW ACCESS

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 statement is used to remove a user's privileges?

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

What is the purpose of the SQL Server ISNULL() function?

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

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise