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

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 SQL Server statement is used to grant execute permissions on a stored procedure?

A. GRANT EXECUTE
B. GRANT EXECUTION
C. ALLOW EXECUTE
D. ALLOW EXECUTION

Which Oracle statement is used to grant execute permissions on a stored procedure?

A. GRANT EXECUTE
B. GRANT EXECUTION
C. ALLOW EXECUTE
D. ALLOW EXECUTION

What is the purpose of the Oracle DBMS_SCHEDULER package?

A. Perform data manipulation tasks
B. Schedule and manage jobs, including PL/SQL blocks and stored procedures
C. Calculate the average value
D. Create database links

In Oracle, what is the purpose of the WITH clause?

A. Combine rows from two or more tables
B. Create a temporary result set for use in a SELECT statement
C. Sort the result set
D. Join multiple tables

Which SQL statement is used to insert new data into a table?

A. INSERT INTO
B. ADD DATA
C. UPDATE DATA
D. ADD INTO

What is the purpose of the SQL WHERE clause?

A. Specify the columns to be selected
B. Filter rows 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

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 does T-SQL stand for in the context of SQL Server?

A. Table Structured Query Language
B. Transactional SQL
C. Transact-SQL
D. Table SQL

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise