question What is the purpose of the SQL DISTINCT keyword

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 Oracle 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 XML data type?

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

In SQL Server, 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

What does SQL stand for in the context of Oracle Database?

A. Structured Question Language
B. Standard Query Language
C. Sequential Query Language
D. Structured Query Language

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

A. Find the average value
B. Find the length of a string
C. Find the position of a substring in a string
D. Concatenate multiple strings

In SQL Server, what is the purpose of the TRIGGER?

A. Generate a sequence of numbers
B. Execute a set of statements in response to an event
C. Establish a link between two tables
D. Enforce a unique constraint

In SQL Server, what is the purpose of the SEQUENCE object?

A. Generate a sequence of numbers
B. Execute a set of statements in a loop
C. Define a cursor for record processing
D. Create a temporary table

Which SQL Server statement is used to remove all records from a table and reset identity seed?

A. DELETE TABLE
B. REMOVE TABLE
C. TRUNCATE TABLE
D. DROP TABLE

In Oracle, what is the purpose of the TO_DATE() function?

A. Convert a date to a string
B. Convert a string to a date
C. Concatenate multiple dates
D. Round a date value

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise