tailieunhanh - Microsoft Press Configuring sql server 2005 môn 70 - 431 phần 10

System Monitor không thể cho bạn biết những gì đang thực hiện, nhưng nó có thể định lượng một hoạt động cho một hệ thống hoặc một thành phần ứng dụng. Trong thực tế này, bạn sẽ cấu hình Màn hình đăng nhập hệ thống truy cập, mà bạn sẽ sử dụng trong Bài 5 | 846 Chapter 2 Lesson Review Answers Lesson 3 1. Correct Answer A A. Correct When a database is in the Simple recovery model the database engine minimally logs most operations. B. Incorrect In a Full recovery model all transactions are logged. C. Incorrect In a Bulk-Logged recovery model only bulk operations are minimally logged. D. Incorrect The Simple recovery model logs transactions only minimally. 2. Correct Answers B and C A. Incorrect The recovery model is a database-level configuration so you cannot change the recovery model by using sp_configure. B. Correct You can change the database recovery model graphically in SSMS. C. Correct ALTER DATABASE is the Transact-SQL statement that lets you change the recovery model. D. Incorrect You cannot specify the recovery model in the CREATE DATABASE statement. When you create a database with the CREATE DATABASE statement SQL Server creates it with the recovery model from the model database. 3. Correct Answers A and D A. Correct Because the transaction log is truncated in the Simple recovery model you cannot restore the database to a given point in time. B. Incorrect You can restore differential backups because they are database backups and you do not need transaction log information. C. Incorrect You can restore full backups because you do not need transaction log information to perform that action. D. Correct You cannot restore a data page in the Simple recovery model. A page restore requires an unbroken chain of log backups up to the current log file. Lesson 4 1. Correct Answers B C and D A. Incorrect Database users are database-level objects not server-level principals. Chapter 2 Lesson Review Answers 847 B. Correct Fixed server roles are server principals that let you assign administrative rights to logins. C. Correct Windows logins are server principals that let you give access to Windows users and groups. D. Correct SQL Server logins are server principals created stored and managed in SQL Server. 2. Correct .