Discussion
Home ‣ Database ‣ SQL Server 2000 Comments
- Question
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.
Options- A. True
- B. False
- Correct Answer
- False
- 1. Nonclustered indexes are faster than clustered indexes for retrieval.
Options- A. True
- B. False Discuss
- 2. SQL Server supports three recovery modes: simple, full and Bulk.
Options- A. True
- B. False Discuss
- 3. SQL Server automatically creates an index on all primary and foreign keys.
Options- A. True
- B. False Discuss
- 4. SERIALIZABLE is the strictest isolation level.
Options- A. True
- B. False Discuss
- 5. SQL Server AFTER Triggers may be assigned views.
Options- A. True
- B. False Discuss
- 6. SQL Server supports a language called Transact-SQL (also called T-SQL).
Options- A. True
- B. False Discuss
- 7. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
Options- A. True
- B. False Discuss
- 8. Better security occurs if Windows-only authentication is selected.
Options- A. True
- B. False Discuss
- 9. SQL Server indexes are special data structures used to improve performance.
Options- A. True
- B. False Discuss
- 10. With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
Options- A. True
- B. False Discuss
SQL Server 2000 problems
Search Results
Correct Answer: False
Correct Answer: True
Explanation:
SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are:
1. Simple Recovery Model
2. Full Recovery Model
3. Bulk-logged Recovery Model
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.