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

Q. Foreign keys cannot handle deletes and updates.

View solution

Q. Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________

View solution

Q. Which storage engine in MySQL provides foreign key support?

View solution

Q. The property of InnoDB that enforces foreign key relationships stay intact is called _____________

View solution

Q. Which clause names the parent table and the index columns in the table?

View solution

Q. If the storage engine InnoDB is not used, foreign key cannot be used.

View solution

Q. Which clause is used to remove a foreign key constraint?

View solution

Q. Which keyword is used to specify the foreign key after the table is created?

View solution

Q. Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

View solution