A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following refers to a cursor type where changes of any type and from any source are visible? Keyset Forward only Static Dynamic TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row? Keyset Forward only Static Dynamic TRUE ANSWER : ? YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent. False True TRUE ANSWER : ? YOUR ANSWER : ?
The size of a lock is called: exclusive lock implicit lock lock granularity shared lock TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read? Consistent read Phantom read Dirty read Nonrepeatable read TRUE ANSWER : ? YOUR ANSWER : ?
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times. True False TRUE ANSWER : ? YOUR ANSWER : ?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance. Read committed Read uncommitted Serializable Repeatable read TRUE ANSWER : ? YOUR ANSWER : ?
What is the overall responsibility of the DBA? Facilitate the development and use of the database Development, operation, and maintenance of the database and its applications Create and populate tables Both the first and third answers above are correct. TRUE ANSWER : ? YOUR ANSWER : ?