Q. ________ allows only committed data to be read, but does not require repeatable reads

View solution

Q. ___________ allows uncommitted data to be read

View solution

Q. State true or false: All the isolation levels disallow dirty writes

View solution

Q. When is a timestamp allotted

View solution

Q. In ___________ isolation each transaction is given its own version of the database

View solution

Q. What is the disadvantage of locking?

View solution

Q. Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction ?

View solution

Q. A transaction is delimited by statements (or function calls) of the form __________

View solution

Q. Identify the characteristics of transactions

View solution

Q. Which of the following has “all-or-none” property ?

View solution

Q. The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as

View solution

Q. The property of transaction that persists all the crashes is

View solution

Q. __________ states that only valid data will be written to the database.

View solution

Q. The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.

View solution

Q. ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

View solution

Q. In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

View solution

Q. Which character function can be used to return a specified portion of a character string?

View solution

Q. Which of the following is TRUE for the System Variable $date$?

View solution

Q. What are the different events in Triggers?

View solution

Q. The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints

View solution