相关考题

单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now you get an order from your company CIO, you have to identify whether a database integrity check (DBCC CHECKDB) was run for a particular database.  Which log file should you examine?()

单项选择题 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11:00. When you perform this back up, you must make sure that the overall backup will not be affected. What;s more, you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence.  In the options below, which Transact-SQL statement should you use?()

单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E:drive. The job logs information to the text file. You get a report from users saying that the server doesn;t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn;t function any loner. As the IT support, you have to identify the reason for the failure of the SQL Server Agent service.  Which log should you check? ()