Q. What cannot be done on a view?

View solution

Q. What can be used to check for views that have been invalidated by DROP or ALTER operations?

View solution

Q. Which of the following does not support a materialized view?

View solution

Q. To perform a delete on a single-table, how is the name of a column qualified?

View solution

Q. A multiple-table delete can apply any join.

View solution

Q. Qualifying the name of column with the table name is not necessary in single-table updates.

View solution

Q. UPDATE statement is a DML statement. What does DML stand for?

View solution

Q. Which keyword in the UPDATE statement is used to assign values to columns?

View solution

Q. Which keyword is used to delete all the rows from the table?

View solution

Q. What is known as the set of SQL statements that either executes successfully or none of them have an effect?

View solution

Q. What is generally done after the transactions are executed successfully?

View solution

Q. What is generally done if an error occurs during the transaction?

View solution

Q. What does ‘A’ stand for in the ACID property of transactions?

View solution

Q. What does ‘C’ stand for in the ACID property of transactions?

View solution

Q. What is the command to disable autocommit and launch a transaction?

View solution

Q. Transactional processing provides strong guarantees about the outcome of operations.

View solution

Q. Transactional processing requires lesser overhead due to CPU cycles and memory.

View solution

Q. What is the durability property of transactions?

View solution

Q. How many storage engines among the following are transaction-safe?

InnoDB, Falcon, MyISAM, MEMORY

View solution

Q. Which key declares that an index in one table is related to that in another?

View solution