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

In MySQL, what is the purpose of the BLOB data type?

A. Binary Large Object
B. Basic Long Object
C. Binary Linked Object
D. Basic Linked Object

Which Oracle statement is used to remove a user's privileges?

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

In SQL Server, what is the purpose of the LIKE operator?

A. Filter rows based on a condition
B. Sort the result set
C. Combine rows into groups
D. Search for a specified pattern in a column

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

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

Which Oracle 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 IDENTITY property?

A. Establish a link between two tables
B. Automatically increments the value of a column
C. Enforce a unique constraint
D. Limit the number of rows returned

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

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 Server INNER JOIN clause?

A. Combines rows from two or more tables
B. Retrieves all rows from a table
C. Retrieves rows that have no matching rows in the other table
D. Excludes specified rows

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise