多选题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

题目
多选题
Which two prerequisites are needed for performing workload capture and replay？（）
A

Close all sessions performing queries using database links

B

running the database in shared server mode

C

The database on which the workload is replayed has to be a restore of the original database to a specific SCN

D

setting up the directory to capture the workload

相似考题

1.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

2.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

3. A customer has 4 application and 2 database servers that will be installed in partitions on a Power 750. They are concerned that the database software vendor will charge based on every processor core in the server. Which action will reduce the potential vendor software costs?（）A、Create capped partitions for the database servers.B、Create workload partitions for the database servers.C、Create a separate shared processor pool for the database servers.D、Create virtual processors equal to the entitlement for database servers.

4.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? ()(Choose Two)A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recovery using all available backupsD. Generating a new, unique DBID for the duplicate databaseE. Copying the online redo log files from the target database to the duplicate database

参考答案和解析
正确答案： A,B
解析： 暂无解析
更多“多选题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”相关问题

  • 第1题：

    A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）

    • A、 Use the SQL Server Profiler to capture all SQL activities.
    • B、 Use a Dynamic Management View to analyze performance.
    • C、 Use the Database Engine Tuning Advisor to analyze the workload.
    • D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.

    正确答案:B

  • 第2题：

    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

    正确答案:A,C,D

  • 第3题：

    The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

    • A、 LOG_BUFFER
    • B、 DB_CACHE_SIZE
    • C、 JAVA_POOL_SIZE
    • D、 LARGE_POOL_SIZE
    • E、 SHARED_POOL_SIZE
    • F、 STREAMS_POOL_SIZE

    正确答案:A,F

  • 第4题：

    Which two client requests are captured during database replay Capture?（） (Choose two)

    • A、Flashback queries
    • B、Shared server requests
    • C、Login and logoff activities of sessions
    • D、Direct path load of data from external files by using utilities such as SQL *loader
    • E、Data definition language (DDL) and data manipulation language (DML) operations

    正确答案:C,E

  • 第5题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

    • A、Creating the control file for the duplicate database
    • B、Restoring the target data files to the duplicate database
    • C、Performing complete recovery using all available backups
    • D、Generating a new, unique DBID for the duplicate database
    • E、Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第6题：

    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.

    正确答案:B,C

  • 第7题：

    多选题
    Which two client requests are captured during database replay Capture？（）
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language （DDL） and data manipulation language （DML） operations


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

  • 第8题：

    多选题
    You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）
    A

    Advisor Central

    B

    Global Attributes

    C

    Resource Monitors

    D

    Memory Parameters

    E

    Database Usage Statistics

    F

    All Initialization Parameters

    G

    Automatic Workload Repository


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

  • 第9题：

    单选题
    A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）
    A

     Use the SQL Server Profiler to capture all SQL activities.

    B

     Use a Dynamic Management View to analyze performance.

    C

     Use the Database Engine Tuning Advisor to analyze the workload.

    D

     Use Microsoft SQL Server Management Studio to analyze the SQL logs.


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

  • 第10题：

    多选题
    The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）
    A

    LOG_BUFFER

    B

    DB_CACHE_SIZE

    C

    JAVA_POOL_SIZE

    D

    LARGE_POOL_SIZE

    E

    SHARED_POOL_SIZE

    F

    STREAMS_POOL_SIZE


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

  • 第11题：

    多选题
    Which two are prerequisites for performing a flashback transaction?（）
    A

    Flashback Database must be enabled.

    B

    Undo retention guarantee for the database must be configured.

    C

    EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

    D

    Supplemental logging must be enabled.

    E

    Recycle bin must be enabled for the database.

    F

    Block change tracking must be enabled tor the database.


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

  • 第12题：

    多选题
    Which two client requests are captured during database replay Capture?（） (Choose two)
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language (DDL) and data manipulation language (DML) operations


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

  • 第13题：

    You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

    • A、 Advisor Central
    • B、 Global Attributes
    • C、 Resource Monitors
    • D、 Memory Parameters
    • E、 Database Usage Statistics
    • F、 All Initialization Parameters
    • G、 Automatic Workload Repository

    正确答案:A,C

  • 第14题：

    Which two prerequisites are needed for performing workload capture and replay？（）

    • A、Close all sessions performing queries using database links
    • B、running the database in shared server mode
    • C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
    • D、setting up the directory to capture the workload

    正确答案:C,D

  • 第15题：

    Which two client requests are captured during database replay Capture？（）

    • A、 Flashback queries
    • B、 Shared server requests
    • C、 Login and logoff activities of sessions
    • D、 Direct path load of data from external files by using utilities such as SQL *loader
    • E、 Data definition language （DDL） and data manipulation language （DML） operations

    正确答案:C,E

  • 第16题：

    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.

    正确答案:C,D

  • 第17题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）

    • A、 Creating the control file for the duplicate database
    • B、 Restoring the target data files to the duplicate database
    • C、 Performing complete recovery using all available backups
    • D、 Generating a new， unique DBID for the duplicate database
    • E、 Copying the online redo log files from the target database to the duplicate database

    正确答案:C,E

  • 第18题：

    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 server
    • D、You should recapture the workload to a trace file by using SQL Profiler.

    正确答案:D

  • 第19题：

    多选题
    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.


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

  • 第20题：

    多选题
    Which two prerequisites are needed for performing workload capture and replay？（）
    A

    Close all sessions performing queries using database links

    B

    running the database in shared server mode

    C

    The database on which the workload is replayed has to be a restore of the original database to a specific SCN

    D

    setting up the directory to capture the workload


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

  • 第21题：

    多选题
    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


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

  • 第22题：

    多选题
    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.


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

  • 第23题：

    单选题
    Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload：   1） Preprocess the captured workload.  2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients.  4） Restore the test database to the point when the capture started.  5） Remap connections.   Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）
    A

     1，4，5，3 （2 is not required.）

    B

     1，4，3，5 （2 is not required.）

    C

     1，2，4，5 （3 is not required.）

    D

     2，1，5，3，4 

    E

     1，2，4，5，3


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

  • 第24题：

    多选题
    A customer has determined they want to install an IBM x445 system in their company.  They will be running a large database on the system.  In order to determine how many CPUs will be needed to attain the optimum cost-effective solution， which TWO of the following questions should be asked？（）
    A

    How large is the database？

    B

    What is the expected user workload？

    C

    How is the database software licensed？

    D

    What type of user interface will be used？

    E

    How much data cache will the database be allocated？


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

相关内容