Similar Collections

.

questions

Title
What is the disadvantage of locking
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 ?
A transaction is delimited by statements (or function calls) of the form __________
Identify the characteristics of transactions
Which of the following has “all-or-none” property
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
The property of transaction that persists all the crashes is
__________ states that only valid data will be written to the database
The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties
____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed
In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
Which character function can be used to return a specified portion of a character string
Which of the following is TRUE for the System Variable $date$
What are the different events in Triggers?
The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints
Which of the following SQL command can be used to modify existing data in a database table?
When SQL statements are embedded inside 3GL, we call such a program as
_______________ provides option for entering SQL queries as execution time, rather than at the development stage
Each modification done in database transaction are first recorded into the
_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed
total questions: 143

Questions

143

Views

1266

Best Answers

299

Points

5