Discussion
Home ‣ Database ‣ Managing Multiuser Databases Comments
- Question
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read
- Correct Answer
- Nonrepeatable read
- 1. Locks placed by command are called ________ .
Options- A. implicit locks
- B. explicit locks
- C. exclusive locks
- D. shared locks Discuss
- 2. A cursor type in which the application can only move forward through the recordset is called:
Options- A. forward only.
- B. static.
- C. keyset.
- D. dynamic. Discuss
- 3. A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
Options- A. forward only.
- B. static.
- C. keyset.
- D. dynamic. Discuss
- 4. A transaction for which all committed changes are permanent is called:
Options- A. atomic.
- B. consistent.
- C. isolated.
- D. durable. Discuss
- 5. The advantage of optimistic locking is that:
Options- A. the lock is obtained only after the transaction has processed.
- B. the lock is obtained before the transaction has processed.
- C. the lock never needs to be obtained.
- D. transactions that are best suited are those with a lot of activity. Discuss
- 6. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Options- A. REPEATABLE READ
- B. SERIALIZABLE
- C. READ COMMITTED
- D. READ UNCOMMITTED Discuss
- 7. In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
Options- A. Complete backup
- B. Transaction Log
- C. Differential backup
- D. None of the above is correct. Discuss
- 8. Which of the following is a way to create and modify tables using SQL Server?
Options- A. Write SQL code using either CREATE or ALTER SQL statements only.
- B. Use the graphical facilities of SQL Server Enterprise Manager only.
- C. Both of the two methods above will work.
- D. Neither of the two methods above will work. Discuss
- 9. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Options- A. Nonclustered
- B. Clustered
- C. Primary
- D. Secondary Discuss
- 10. With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Options- A. Nonclustered
- B. Clustered
- C. Primary
- D. Secondary Discuss
Managing Multiuser Databases problems
Search Results
Correct Answer: explicit locks
Correct Answer: forward only.
Correct Answer: static.
Correct Answer: durable.
Correct Answer: the lock is obtained only after the transaction has processed.
Correct Answer: REPEATABLE READ
Correct Answer: Differential backup
Correct Answer: Both of the two methods above will work.
Correct Answer: Nonclustered
Correct Answer: Clustered
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.