question In SQL Server what is the purpose of the TRIGGER

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

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

Which statement is used to delete records from a table in SQL Server?

A. DELETE FROM table;
B. REMOVE * FROM table;
C. TRUNCATE TABLE table;
D. DROP TABLE table;

What is the maximum length of the VARCHAR data type in MySQL?

A. 255
B. 512
C. 1024
D. It varies based on the version

What does the SQL NOT NULL constraint do?

A. Allows NULL values
B. Prevents NULL values
C. Sorts values in descending order
D. Groups values

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 Oracle, what is the purpose of the JOIN clause?

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

In Oracle, what is the purpose of the 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

In MySQL, what is the purpose of the CASCADE keyword in a FOREIGN KEY constraint?

A. Automatically adds a new row
B. Automatically updates or deletes related rows
C. Allows NULL values
D. Sorts values in ascending order

What is the purpose of the Oracle DUAL table?

A. Store binary data
B. Store XML data
C. Provide a one-row, one-column table for selecting expressions
D. Store numeric values

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

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise