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

Q. In which mode of search is the search string parsed into words and the search looks for rows?

View solution

Q. The indicator of presence or absence of a word in search is used in which mode?

View solution

Q. Which search mode uses natural language search as a subroutine?

View solution

Q. FULLTEXT indexes can be created only for ____________

View solution

Q. A FULLTEXT index cannot be created for multiple columns.

View solution