In a Database Replay workload capture， what client request information is gathered？（）A、 SQL textB、 Shared server requests （Oracle MTS）C、 Bind variable valuesD、 Information about transactionsE、 Remote DESCRIBE and COMMIT operations
In a Database Replay workload capture， what client request information is gathered？（）
- A、 SQL text
- B、 Shared server requests （Oracle MTS）
- C、 Bind variable values
- D、 Information about transactions
- E、 Remote DESCRIBE and COMMIT operations
相关考题：
Which two client requests are captured during database replay Capture?() A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations
Which client requests to the database can be captured as a part of the workload capture?() A. flashback queryB. distributed transactionsC. logging in and logging out of sessionsD. all DDL statements having bind variablesE. direct path load of data from external files
Which two client requests are captured during database replay Capture?() (Choose two) A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?() A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
Which client requests to the database can be captured as a part of the workload capture？（） A、 flashback queryB、 distributed transactionsC、 logging in and logging out of sessionsD、 all DDL statements having bind variablesE、 direct path load of data from external files
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）A、Allocates memory for RMAN backup and restore operationsB、Allocates memory for shared and private SQL areasC、Contains a cursor area for storing runtime information about cursorsD、Contains stack spaceE、Contains a hash area performing hash joins of tables
Which two prerequisites are needed for performing workload capture and replay？（）A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A、Information about each Oracle Net connection.B、Information about each entry in theLinstener.orafileC、Information about the changed done in the databaseD、Information about the different listeners in your systemE、Information about all thenondatabasefiles required to operate the database
Performance divergence indicated in the Workload Replay report is most likely due to what？（） A、 DML and SQL statement results that do not match between the capture and replay systemsB、 When errors that occur in the capture system dont occur in the replay systemC、 Top SQL statementsD、 Infrastructure or system-configuration differencesE、 Time-of-day differences between capture and replay systems
Which two client requests are captured during database replay Capture？（）A、 Flashback queriesB、 Shared server requestsC、 Login and logoff activities of sessionsD、 Direct path load of data from external files by using utilities such as SQL *loaderE、 Data definition language （DDL） and data manipulation language （DML） operations
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）A、 the SQL textB、 the execution planC、 the execution contextD、 the execution frequencyE、 the system change number （SCN）
Which two client requests are captured during database replay Capture?（） (Choose two)A、Flashback queriesB、Shared server requestsC、Login and logoff activities of sessionsD、Direct path load of data from external files by using utilities such as SQL *loaderE、Data definition language (DDL) and data manipulation language (DML) operations
Which two statements about workload capture and replay operations are true?（）A、The clients must be created manually on the test machines to perform more realistic testing.B、Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.C、Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.D、The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
Which of these recommendations should be followed before capturing a workload？（）A、 Make sure your replay database has the same structure as the capture database， except without data.B、 Make sure the replay and capture databases are similar in data content.C、 Perform a clean shutdown and restart of the capture database before beginning a workload capture.D、 Start the capture database in UNRESTRICTED mode， then start the capture.E、 Define inclusion and exclusion filters.
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 Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（） A、For the AdventureWorks database, enable Server Auditing B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance C、You should configure the data collector and make it capture the deadlock graphsD、You should configure a SQL Profiler trace, and make it capture the deadlock graphs
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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal？（）A、You should recapture the workload by using the data collector.B、You should enable the XP_MSVER stored procedure on the local server.C、You should enable the XP_MSVER stored procedure on the remote serverD、You should recapture the workload to a trace file by using SQL Profiler.
多选题Which two client requests are captured during database replay Capture？（）AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language （DDL） and data manipulation language （DML） operations
多选题Which two statements about workload capture and replay operations are true？（）AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
多选题Which two prerequisites are needed for performing workload capture and replay？（）AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the 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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. So what action should you perform to achieve this goal？（）AYou should recapture the workload by using the data collector.BYou should enable the XP_MSVER stored procedure on the local server.CYou should enable the XP_MSVER stored procedure on the remote serverDYou should recapture the workload to a trace file by using SQL Profiler.
多选题In a Database Replay workload capture， what client request information is gathered？（）ASQL textBShared server requests （Oracle MTS）CBind variable valuesDInformation about transactionsERemote DESCRIBE and COMMIT operations
多选题Which client requests to the database can be captured as a part of the workload capture?（）Aflashback queryBdistributed transactionsClogging in and logging out of sessionsDall DDL statements having bind variablesEdirect path load of data from external files
多选题Which of these recommendations should be followed before capturing a workload？（）AMake sure your replay database has the same structure as the capture database， except without data.BMake sure the replay and capture databases are similar in data content.CPerform a clean shutdown and restart of the capture database before beginning a workload capture.DStart the capture database in UNRESTRICTED mode， then start the capture.EDefine inclusion and exclusion filters.
单选题Performance divergence indicated in the Workload Replay report is most likely due to what？（）A DML and SQL statement results that do not match between the capture and replay systemsB When errors that occur in the capture system dont occur in the replay systemC Top SQL statementsD Infrastructure or system-configuration differencesE Time-of-day differences between capture and replay systems
多选题Which two client requests are captured during database replay Capture?（） (Choose two)AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language (DDL) and data manipulation language (DML) operations
多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables