Discussion
Home ‣ Database ‣ Managing Multiuser Databases Comments
- Question
Locks placed by the DBMS are explicit locks.
Options- A. True
- B. False
- Correct Answer
- False
- 1. The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
Options- A. True
- B. False Discuss
- 2. The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
Options- A. True
- B. False Discuss
- 3. When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
Options- A. True
- B. False Discuss
- 4. In optimistic locking, the assumption is made that conflict will occur.
Options- A. True
- B. False Discuss
- 5. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
Options- A. True
- B. False Discuss
- 6. By default, SQL Server will create one data file and one log file for each newly created database.
Options- A. True
- B. False Discuss
- 7. With SQL Server, parameters and variables in T-SQL start with the "%" sign.
Options- A. True
- B. False Discuss
- 8. SQL Server AFTER Triggers may be assigned views.
Options- A. True
- B. False Discuss
- 9. SERIALIZABLE is the strictest isolation level.
Options- A. True
- B. False Discuss
- 10. SQL Server automatically creates an index on all primary and foreign keys.
Options- A. True
- B. False Discuss
Managing Multiuser Databases problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.