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 : ?
A cursor type in which the application can only move forward through the recordset is called: dynamic. static. keyset. forward only. TRUE ANSWER : ? YOUR ANSWER : ?
The overall responsibility of the DBA is to facilitate the development and use of the database. True False 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 : ?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads? Read uncommitted Read committed Repeatable read Serializable TRUE ANSWER : ? YOUR ANSWER : ?
In optimistic locking, the assumption is made that conflict will occur. True False TRUE ANSWER : ? YOUR ANSWER : ?
Database administration refers to a function that applies to the entire organization. False True TRUE ANSWER : ? YOUR ANSWER : ?
A cursor type in which the application sees the data as they were at the time the cursor was opened is called: keyset forward only dynamic static 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? Forward only Keyset Dynamic Static TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by the DBMS are called ________ . exclusive locks shared locks implicit locks explicit locks TRUE ANSWER : ? YOUR ANSWER : ?