×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
What factor influences lock escalation?
2.
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?
3.
Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?
4.
When is an INTENT EXCLUSIVE (IX) lock required?
5.
What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?
6.
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
7.
When a COMMIT statement is executed, what happens?
8.
Which command is used to back out a subset of database changes that have been made within a unit of work?
9.
Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?
10.
Which command will delete all rows from a table without generating log records?