网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
- A、by using the SQL access advisor
- B、by using the Automatic Workload Repository report
- C、by running the Automatic Database Diagnostic Monitor （ADDM）
- D、by using the Automatic Workload Repository Compare Period report
- E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
参考答案
更多 “The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view” 相关考题
考题
You work as an application developer at Certkiller .com. Certkiller .com uses an application that calculates monthly payments based upon client input.You are currently debugging this application using the Microsoft Visual Studio 2005 IDE.The application contains the following code:public double CalculateMonthlyPayment (Single rate, double principal) {//Implementation code}You have discovered that unexpected results are being returned by the application. You would like to pause execution and display a message box containing an error message in the event of a negative or zero rate value is Passed to the CalculateMonthlyPayment method.You need to ensure that this only occurs during debugging mode.What should you do?（）A.B.C.D.
考题
Rapid application development(RAD) systems purport to lighten the developer's(46)by making it easy to program an application with simple intuitive steps.RAD tools(47)the developer everything needed to construct a fully functional application quickly and easily. They make short work of modifying the developed product to(48)changes after the program is finished. Applications developed with RAD tools are constructed as they are envisioned. As an application's real usefulness(49), the developer armed with RAD tools should be able to(50)on new features with little fuss.A．burdenB．troubleC．taskD．weight
考题
What are three of the fields used in defining a CSQ in IPCC Express Enhanced?（）A、WrapUp Time B、Service Level C、Overflow CSQ D、Agent Name E、Automatic Work F、CRS Application
考题
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
考题
You work as an application developer at Certkiller .com. Certkiller .com has asked you to develop an application that monitors and controls the activities of a Windows service.You need to use the appropriate class to meet Certkiller .com’s requirements. What should you do？（）A、 Use the ServiceBase class.B、 Use the ServiceInstaller class.C、 Use the ServiceManager class.D、 Use the ServiceController class.
考题
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）A、An application process acquires at least a share lock on the current row of every cursor.B、Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.C、Any row changed by another application process can be read, even if the change has not been committed by that application process.D、An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
考题
Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（） A、The database manager will rollback the transaction in both applications.B、The database manager will rollback the transaction in one of the two applications.C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
考题
If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?（）A、Read Stability (RS)B、Repeatable Read (RR)C、Uncommitted Read (UR)D、Cursor Stability (CS)
考题
Company.com has installed HACMP and is configuring a three-node cluster. One of the Applications uses the AIX hostname as a key for authorization to execute on the specific computer. The application vendor was contacted and consented to having multiple copies of the application but required that only one application be active at any one point in time. How can the AIX host name dependency be managed in an HACMP environment.（） A、 It cannot be managed because the application will not work properly with HACMP.B、 The application start and stop script for the application can manage the hostname.C、 HACMP will require customization to correctly manage a change in the hostname since it is tied to the primary network adapter.D、 HACMP will have to be restarted if the hostname is changed. This can be done with customization in the node_up and node_down event scripts.
考题
A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）A、Code the application to issue a LOCK TABLE statement. B、Code the application to issue a LOCK ROW statement. C、Decrease the number of I/O servers. D、Increase the locklist parameter.
考题
Which of the following is a feature of a unit of work?（）A、It applies to a single data server.B、It is a recoverable sequence of operations.C、Its value can be queried from the system catalog tables.D、It begins when the application connects to the data server.
考题
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 has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?（） A、The workload group which is used by default B、The workload group which is used by the finance application C、The classifier function which identifies the finance application D、The workload group which is used by the manufacturing application
考题
You work as an application developer at Certkiller .com. You are required to dynamically load assemblies into an application domain. You are using the Load method of the AppDomain class. What types of files can you this use method for？（）A、 Library application files （.dll）.B、 All assembly files， no matter what there file extensions are.C、 Application configuration files （.config）.D、 Standalone application files （.exe）.
考题
You work as an application developer at Certkiller .com. You are currently in theprocess of reviewing an application that was created by a fellow developer.The application that you are reviewing includes a declaration for a collection named EmployeeList， which stores Employee objects. The declaration is shown below： public class EmployeeList ： Enumerator， IEnumerable { // Class implementation } You require the ability to iterate through the EmployeeList with minimum development effort.What should you do？（）A、 Utilize the switch statementB、 Utilize the dowhile statementC、 Utilize the foreach statementD、 Utilize the if statement
考题
You work as an application developer at Cer-Tech.com.You are in the process of creating an application for Cert-Tech.com’s Human Resources department that tracks employee benefits You have to store current employee data without recompiling the application. You elect to store this employee data as a custom section in the application configuration file. The relevant portion of the application configuration file is shown in the following exhibit： What should you do？（）A、 Create a custom section handler class that inherits the ConfigurationSection interfaceB、 Add a section element to the EmployeeSection element of the application configuration fileC、 Create a custom section handler class that implements the IConfigurationSectionHandler interface.D、 Add an EmployeeSection element to the configSections element of the application confguration fileE、 Create a custom section handler class that implements the IApplicationSettingsProvider interfaceF、 Add a section element to the configSections element of the application configuration file
考题
单选题You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later， you are required to determine if assembly references in this application domain， which is the current application domain， are being cached. What property should you use to achieve this objective？（）A
AppDomain.CurrentDomain.ShadowCopyFilesB
AppDomain.CurrentDomain.CachePathC
AppDomain.CurrentDomain.ConfigurationFileD
AppDomain.CurrentDomain.Evidence
考题
单选题In a Java EE messaging application, one MDB is consuming a lot of memory at high traffic. What configuration should you use to prevent possible out-of-memory error at high traffic and at the same time not losing messages?（）A
Configure a Work Manager for the MDB with a Maximum Thread Constraint.B
Configure a Work Manager for the MDB with a Minimum Thread Constraint. C
Configure a Work Manager for the MDB with a Maximum Thread Constraint and a Capacity Constraint. D
Configure a Work Manager for the MDB with a Minimum Thread Constraint and a Capacity Constraint. E
Configure a Work Manager for the MDB with both a Maximum Thread Constraint and Minimum Thread Constraint.
考题
单选题Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）A
An application process acquires at least a share lock on the current row of every cursor.B
Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.C
Any row changed by another application process can be read, even if the change has not been committed by that application process.D
An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
考题
单选题You work as an application developer at Certkiller .com. You are required to dynamically load assemblies into an application domain. You are using the Load method of the AppDomain class. What types of files can you this use method for？（）A
Library application files （.dll）.B
All assembly files， no matter what there file extensions are.C
Application configuration files （.config）.D
Standalone application files （.exe）.
考题
单选题You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services， and configuring aweb services infrastructure. There is a server that runs Windows Server 2008. The Terminal Services server role is installed on theserver. You have a new application deployed on the server. The application creates files that have anextension of .xyz. You have to make sure that users are able to launch the remote application from theircomputers by double-clicking a file that has the .xyz extension. What action should you perform？（）A
The Remote Desktop Connection Client on the users’ computers should be configured to point to theserver.B
Configure the application as a published application You should use a Remote Desktop Program file.C
Configure the application as a published application by using a Microsoft Windows Installer packagefile.D
Configure the application as a published application by using a Terminal Server Web Access Web site.
考题
单选题A customer needs to ensure that the number of threads servicing an application does not exceed the number of database connections available to the application. What step must you take to address this situation?（）A
Configure a Max Threads Constraint and add your application to the list of applications for the Constraint.B
Configure a Work Manager with a Maximum Threads Constraint tied to the Connection Pool and configuration your application to use the Work Manager.C
Configure a Work Manager with a Minimum Threads Constraint tied to the Connection Pool and configure your application to use the Work Manager.D
Configure a global MaxThreads constraint and target it to the server or clusters where your application is deployed.E
Configure the startup parameter -Dwls-maxThreads to be the same as the number of database connections configured.
考题
单选题You work as the application developer at Certkiller .com. Certkiller .com uses Visual Studio.NET 2005 as its application development platform. You are developing a Windows Service application which contains three different Windows services. You are required to only set one Windows service to start automatically when the system is restarted. What should you do?（）A
Use the ServiceController class.B
Use the ServiceBase class.C
Use the ServiceProcessInstaller class.D
Use the ServiceInstaller class.
考题
单选题Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）A
The database manager will rollback the transaction in both applications.B
The database manager will rollback the transaction in one of the two applications.C
Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.D
Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
考题
多选题You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later you are asked to retrieve information from this application domain， which is the current application domain. What can you do to achieve this objective？（）AUse the following code： AppDomain appInfo = ApplicationDomain.Current；BUse the following code： AppDomain appInfo = AppDomain.CurrentDomain （）；CUse the following code： AppDomain appInfo = Thread.GetDomain （）；DUse the following code： AppDomain appInfo = MainThread.GetDomain （）；
考题
单选题Company.com has installed HACMP and is configuring a three-node cluster. One of the Applications uses the AIX hostname as a key for authorization to execute on the specific computer. The application vendor was contacted and consented to having multiple copies of the application but required that only one application be active at any one point in time. How can the AIX host name dependency be managed in an HACMP environment.（）A
It cannot be managed because the application will not work properly with HACMP.B
The application start and stop script for the application can manage the hostname.C
HACMP will require customization to correctly manage a change in the hostname since it is tied to the primary network adapter.D
HACMP will have to be restarted if the hostname is changed. This can be done with customization in the node_up and node_down event scripts.
考题
单选题You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this？（）A
Run Segment AdvisorB
Run the SQL Tuning Advisor （STA）C
Run the Automatic Workload Repository （AWR） reportD
Run the SQL Access Advisor with a hypothetical workload
考题
单选题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 has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?（）A
The workload group which is used by default B
The workload group which is used by the finance application C
The classifier function which identifies the finance application D
The workload group which is used by the manufacturing application
考题
单选题You work as an application developer at Certkiller .com. You have recently created a multithreaded application to manage Certkiller .com’s inventory system. The fulfillment task has to be executed on a regular basis， while other tasks are performed in the application. The task does not need any input to start. You are required to create and start the fulfillment thread using the appropriate code.What code should you use？（）A
AB
BC
CD
D
热门标签
最新试卷
