question In MySQL what is the purpose of the DESC keyword in an ORDER BY clause

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 SYSTEM_USER function?

A. Find the length of a string
B. Find the current user
C. Calculate the average value
D. Concatenate multiple rows

What is the purpose of the Oracle UTL_FILE package?

A. Perform data manipulation tasks
B. Read and write files on the server's file system
C. Calculate the average value
D. Create triggers

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

A. Find the average value
B. Find the total number of rows
C. Find the highest value
D. Find the lowest value

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

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

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 MySQL, what does the term "ACID" stand for in the context of transactions?

A. Atomicity, Consistency, Isolation, Durability
B. Association, Consistency, Isolation, Dependency
C. Atomicity, Consistency, Integration, Durability
D. Association, Commitment, Isolation, Dependency

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

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 SQL Server, what is the purpose of the XML data type?

A. Stores XML data
B. Stores binary data
C. Stores integer values
D. Stores a list of values

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise