题目内容

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？（）

A. You should check ERRORLOG
B. You should check QL1.log
C. You should check SQLAGEN
D. OUT
E. You should check log_xx.trc

查看答案

搜索结果不匹配？点我反馈

更多问题

您正在使用MicrosoftVisualStudioIDE检查返回字符串的方法的输出。您将该方法的输出赋给一个名为fName的字符串变量。您需要编写一个代码段，该代码段在单一行中打印以下内容 ·信息："TestFailed：” ·fName的值（如果fName的值不等于“John”）您还需要确保代码段同时能不中断应用程序的执行。您应该使用哪个代码段？（）

A
B
C
D

查看答案

你正在读入一个名为doc的XML文档，其内容如下（）

A. foreach(XmlNodenodeinnodes){node.Attributes[0].Value=“NA”;}
B. foreach(XmlNodenodeinnodes){node.Attributes[1].Value=“NA”;}
C. foreach(XmlNodenodeinnodes){XmlNodegenre=node.SelectSingleNode(“/genre”);genre.Value=“NA”;}
D. foreach(XmlNodenodeinnodes){XmlNodegenre=node.SelectSingleNode(“@genre”);genre.Value=“NA”;}
E. foreach(XmlNodenodeinnodes){XmlNodegenre=node.SelectSingleNode(“genre”);genre.Value=“NA”;}

查看答案

YournetworkhasNetworkAccessProtection(NAP)deployed.ThenetworkcontainstwoserversnamedServer1andServer2.Server1isaNetworkPolicyServer(NPS).Server2hasathird-partyantivirussolutioninstalled.Server1isconfiguredtouseacustomsystemhealthvalidatorprovidedbytheantivirusvendor.ThesystemhealthvalidatorusesServer2toidentifytheversionofthecurrentantivirusdefinition.YouneedtoensurethatNAPclientsareconsiderednoncompliantifServer1cannotconnecttoServer2.Whicherrorcoderesolutionsettingshouldyouconfigure？（）

A. SHAnotrespondingtoNAPclient
B. SHAunabletocontactrequiredservices
C. SHVnotresponding
D. SHVunabletocontactrequiredservices

查看答案

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？（）

A. BACKUP LOG DB1 TO DISK = 't:\backups\db1.trn';
BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL;
C. BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH NOUNLOAD;
D. BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COPY_ONLY;

查看答案

A. You should check ERRORLOG B. You should check QL1.log C. You should check SQLAGEN D. OUT E. You should check log_xx.trc

你正在读入一个名为doc的XML文档，其内容如下（）

A. You should check ERRORLOG
B. You should check QL1.log
C. You should check SQLAGEN
D. OUT
E. You should check log_xx.trc