单选题Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV

题目
单选题
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility?（）
A

1

B

2 and 4

C

2 and 5

D

3 and 4

E

3 and 5

相似考题

1.You are developing a Windows Communication Foundation (WCF) service.You enable message logging, trace listeners, activity propagation, and tracing on the trace sources.You have the following code segment in the client application. (Line numbers are included for reference only.)01 Guid multiCallActivityId = Guid.NewGuid();02 TraceSource ts = new TraceSource("Multicall");03 Trace.CorrelationManager.ActivityId = multiCallActivityId;04You encounter errors when your client application consumes the service.You need to ensure that your client application can correlate tracing information with the service.Which code segment should you add at line 04?（）A.B.C.D.

2. You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

3. Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility?（）A、1B、2 and 4C、2 and 5D、3 and 4E、3 and 5

4.Your company has a domain controller named Server1 that runs Windows Server 2008 R2 and the DNS Server server role. A server named Server2 runs a custom application.You need to configure DNS to include the following parameters for the custom application: &710;Service &710;Priority &710; Weight &710; Protocol &710; Port number &710;Host offering this service Which record should you create？（）A. Host Info (HINFO)B. Service Location (SRV)C. Canonical Name (CNAME)D. Well-Known Service (WKS)

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL exec DBMS_MONITOR.SERV_”相关问题

  • 第1题：

    Your company has a domain controller named Server1 that runs Windows Server 2008 and the DNS server role. A server named Server2 runs a custom application. You need to configure DNS to include the following parameters for the custom application： Service Priority Weight Protocol Port Number Host offering this service Which record should you create？（）

    • A、 Host Info （HINFO）
    • B、 Service Locator （SRV）
    • C、 Canonical Name （CNAME）
    • D、 Well-Known Service （WKS）

    正确答案:B

  • 第2题：

    You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You plan to use a PresentationTraceSources object when the application is executed by users. When the application is executed in a test environment, all debug information is successfully captured. You need to be able to capture debug information when the application is deployed. What should you do?（）

    • A、 Enable WPF tracing in the registry.Restart the application.
    • B、 Enable tracing by modifying local Group Policy.Restart the application.
    • C、 Open the XML configuration file for your application on the user's computer.Set tracing to a verbose level.Restart the application.
    • D、 Open the XML configuration file for your application on the user's computer.Add a trace listener.Restart the application.

    正确答案:A

  • 第3题：

    Your network consists of a single Active Directory domain. The network contains a server that runs Windows Server 2003 Service Pack 2 （SP2）. The server has an application that runs as a service. The application uses a domain service account to access other servers in the domain. Security policies require that users reset their passwords every 30 days. After the application runs for a month， the application fails.You need to ensure that the application starts and can access the remote servers. What should you do？（）

    • A、In the Services snap-in, set the service to log on as the Local System account and start the service.
    • B、In the Services snap-in, set the service to log on as the Local Administrator account and start the service.
    • C、In Active Directory Users and Computers, reset the server’s computer account. In the Services snap-in, start the service.
    • D、In Active Directory Users and Computers, set the Account Expires option to Never. In the Services snap-in, start the service. 

    正确答案:D

  • 第4题：

    You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has Terminal Server installed. You have a new multi-user application that you plan to install on the server. The setup program for the application is named setup.exe. You need to install the application on the server. You must ensure that the application can be used by all users. What should you do? （）

    • A、From the command prompt, run setup.exe.
    • B、From Add or Remove Programs, add a new program.
    • C、In Windows Explorer, use the Run As option to run setup.exe.
    • D、In Windows Explorer, use Compatibility mode to run setup.exe.

    正确答案:B

  • 第5题：

    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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

    • A、You should use Dynamic Management Views 
    • B、You should use SQL Server Resource Governor 
    • C、You should use SQL Server Profiler 
    • D、You should use Windows System Monitor

    正确答案:A

  • 第6题：

    Your company has a server that runs an instance of Actrve Directory Lightweight Directory Service （AD LDS） You need to create new organizational units in the AD LDS application directory partition What should you do（）

    • A、Use the Actrve Directory Users and Computers snap-in to create the organizational units on the AD LDS application directory partition
    • B、Use the ADSI Edit snap-in to create the organizational units on the AD LDS application directory partition
    • C、Use the dsadd OU  command to create the organizational units
    • D、Use the dsmod OU  command to create the organizational units

    正确答案:B

  • 第7题：

    单选题
    You develop a service application that needs to be deployed. Your network administrator creates a specific user account for your service application.You need to configure your service application to run in the context of this specific user account. What should you do？（）
    A

    Prior to installation，set the StartType property of the ServiceInstaller class.

    B

    Prior to installation，set the Account，Username，and Password properties of theServiceProcessInstaller class.

    C

    Use the CONFIG option of the net.exe command-line tool to install the service.

    D

    Use the installutil.exe command-line tool to install the service.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You are installing an application on a computer that runs Windows Server 2008. During installation， the application will nedd to install new attributes and classes to the Active Directory database. You need to ensure that you can install the application. What should you do（）
    A

    Change the functional level of the forest to WIndows Server 2008.

    B

    Log on by using an account that has Server Operator rights.

    C

    Log on by using an account that has Schema Administrator rights and the appropriate rights to install the application.

    D

    Log on by using an account that has the Enterprise Administrator  rights and the appropriate rights to install the application.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    Your network contains a server that runs Windows Server 2003 Service Pack 2 （SP2）. The server has an application that runs as a service.The application fails intermittently. After each failure， you manually restart the service. You need to ensure that the application starts automatically after a failure. What should you do？（）
    A

    From the Services snap-in， modify the Log On settings of the service.

    B

    From the Services snap-in， modify the Recovery settings of the service.

    C

    From the properties of the application executable， set the compatibility mode to Windows 2000.

    D

    From the properties of the application executable， enable the Allow non-administrators to run this program setting.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Your company has a domain controller named Server1 that runs Windows Server 2008 R2 and the DNS Server server role. A server named Server2 runs a custom application.You need to configure DNS to include the following parameters for the custom application: ˆService ˆPriority ˆ Weight ˆ Protocol ˆ Port number ˆHost offering this service Which record should you create？（）
    A

    Host Info (HINFO)

    B

    Service Location (SRV)

    C

    Canonical Name (CNAME)

    D

    Well-Known Service (WKS)


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    Your company has a server that runs an instance of Actrve Directory Lightweight Directory Service （AD LDS） You need to create new organizational units in the AD LDS application directory partition What should you do（）
    A

    Use the Actrve Directory Users and Computers snap-in to create the organizational units on the AD LDS application directory partition

    B

    Use the ADSI Edit snap-in to create the organizational units on the AD LDS application directory partition

    C

    Use the dsadd OU  command to create the organizational units

    D

    Use the dsmod OU  command to create the organizational units


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）
    A

    To achieve the goal， a Linked Server connection should be configured to the application database.

    B

    To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.

    C

    To achieve the goal， a Remote Server connection to the application database should be configured.

    D

    To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You are installing an application on a computer that runs Windows Server 2008. During installation， the application will nedd to install new attributes and classes to the Active Directory database. You need to ensure that you can install the application. What should you do（）

    • A、Change the functional level of the forest to WIndows Server 2008.
    • B、Log on by using an account that has Server Operator rights.
    • C、Log on by using an account that has Schema Administrator rights and the appropriate rights to install the application.
    • D、Log on by using an account that has the Enterprise Administrator  rights and the appropriate rights to install the application.

    正确答案:C

  • 第14题：

    Your company has a domain controller named Server1 that runs Windows Server 2008 R2 and the DNS Server server role. A server named Server2 runs a custom application.You need to configure DNS to include the following parameters for the custom application: ˆService ˆPriority ˆ Weight ˆ Protocol ˆ Port number ˆHost offering this service Which record should you create？（）

    • A、Host Info (HINFO)
    • B、Service Location (SRV)
    • C、Canonical Name (CNAME)
    • D、Well-Known Service (WKS)

    正确答案:B

  • 第15题：

    Your network contains a server that runs Windows Server 2003 Service Pack 2 （SP2）. The server has an application that runs as a service.The application fails intermittently. After each failure， you manually restart the service. You need to ensure that the application starts automatically after a failure. What should you do？（）

    • A、From the Services snap-in， modify the Log On settings of the service.
    • B、From the Services snap-in， modify the Recovery settings of the service.
    • C、From the properties of the application executable， set the compatibility mode to Windows 2000.
    • D、From the properties of the application executable， enable the Allow non-administrators to run this program setting.

    正确答案:B

  • 第16题：

    Your company has a domain controller named Server1 that runs Windows Server 2008 R2 and the DNS Server server role. A server named Server2 runs a custom application. You need to configure DNS to include the following parameters for the custom application: ?¤Servic ?¤Priorit ?¤Weigh ?¤Protoco ?¤Port numbe ?¤Host offering this servic Which record should you create？（）

    • A、Host Info (HINFO)
    • B、Service Location (SRV)
    • C、Canonical Name (CNAME)
    • D、Well-Known Service (WKS)

    正确答案:B

  • 第17题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）

    • A、To achieve the goal， a Linked Server connection should be configured to the application database.
    • B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.
    • C、To achieve the goal， a Remote Server connection to the application database should be configured.
    • D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.

    正确答案:D

  • 第18题：

    单选题
    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）
    A

    Configure a Linked Server connection to the application database.

    B

    Write a query that uses an OPENDATASOURCE command.

    C

    Write a query that uses an OPENQUERY command.

    D

    Configure a Remote Server connection to the application database.


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Your network consists of a single Active Directory domain. The network contains a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has an application that runs as a service. The application uses a domain service account to access other servers in the domain. Security policies require that users reset their passwords every 30 days. After the application runs for a month, the application fails. You need to ensure that the application starts and can access the remote servers.  What should you do?（）
    A

    In the Services snap-in， set the service to log on as the Local System account and start the service.

    B

    In the Services snap-in， set the service to log on as the Local Administrator account and start the service.

    C

    In Active Directory Users and Computers， reset the servers computer account. In the Services snap-in， start the service.

    D

    In Active Directory Users and Computers， set the Account Expires option to Never. In the Services snap-in， start the service.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility?（）
    A

    1

    B

    2 and 4

    C

    2 and 5

    D

    3 and 4

    E

    3 and 5


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （）
    A

    You should use Dynamic Management Views 

    B

    You should use SQL Server Resource Governor 

    C

    You should use SQL Server Profiler 

    D

    You should use Windows System Monitor


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）
    A

    Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.

    B

    Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’

    C

    Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）

    D

    Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has Terminal Server installed. You have a new multi-user application that you plan to install on the server. The setup program for the application is named setup.exe. You need to install the application on the server. You must ensure that the application can be used by all users. What should you do? （）
    A

    From the command prompt, run setup.exe.

    B

    From Add or Remove Programs, add a new program.

    C

    In Windows Explorer, use the Run As option to run setup.exe.

    D

    In Windows Explorer, use Compatibility mode to run setup.exe.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    Your company has a domain controller named Server1 that runs Windows Server 2008 and the DNS server role. A server named Server2 runs a custom application. You need to configure DNS to include the following parameters for the custom application： Service Priority Weight Protocol Port Number Host offering this service Which record should you create？（）
    A

     Host Info （HINFO）

    B

     Service Locator （SRV）

    C

     Canonical Name （CNAME）

    D

     Well-Known Service （WKS）


    正确答案： B
    解析： 暂无解析

相关内容