question In MySQL what is the purpose of the FOREIGN KEY constraint

Which SQL statement is used to remove a table from a database?

A. DELETE TABLE
B. REMOVE TABLE
C. DROP TABLE
D. DELETE FROM 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

Which MySQL statement is used to grant all privileges to a user?

A. GRANT ALL PRIVILEGES
B. GRANT FULL ACCESS
C. GRANT SUPERUSER
D. GRANT ALL RIGHTS

What is the purpose of the SQL LEFT JOIN clause?

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

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

In SQL Server, what is the purpose of the MERGE statement?

A. Combine rows from two or more tables
B. Update, insert, or delete data based on a condition
C. Sort the result set
D. Join multiple tables

What is the purpose of the SQL Server XML INDEX option?

A. Index an entire XML column
B. Index specific elements or attributes in an XML column
C. Exclude XML columns from indexing
D. Disable indexing for XML columns

What is the default sorting order of the ORDER BY clause in SQL?

A. Ascending
B. Descending
C. Random
D. Alphabetical

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

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

What is the purpose of the SQL ROLLBACK statement?

A. Save changes to the database
B. Undo changes made during the current transaction
C. Commit changes to the database
D. Delete records from the database

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise