单选题What view might you use to try to determine how long a particular backup will take?（）A V$SESSION_EVENT B V$SESSION C V$W0041ITSD V$WAITSTAT E V$SESSION_LONGOPS 

题目
单选题
What view might you use to try to determine how long a particular backup will take?（）
A

V$SESSION_EVENT 

B

V$SESSION 

C

V$W0041ITS

D

V$WAITSTAT 

E

V$SESSION_LONGOPS 

相似考题

1.Whatviewmightyouusetotrytodeterminehowlongaparticularbackupwilltake?()A.V$SESSION_EVENTB.V$SESSIONC.V$WAITSD.V$WAITSTATE.V$SESSION_LONGOPS

2.You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP

3.You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION

4. You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）A、Update the view to use an outer join between the Customers and Sales tables.B、Create a clustered index on the v CustomerSales view.C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

更多“单选题What view might you use to try to determine how long a particular backup will take?（）A V$SESSION_EVENT B V$SESSION C V$W0041ITSD V$WAITSTAT E V$SESSION_LONGOPS”相关问题

  • 第1题：

    You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

    • A、 V$FLASHBACK_DATABASE_LOG
    • B、 V$FLASHBACK_DATABASE_STAT
    • C、 V$DATABASE
    • D、 V$UNDOSTAT

    正确答案:A

  • 第2题：

    There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）

    • A、Define user profiles and set the CPU_PER_CALL limit. 
    • B、Define a SWITCH_TIME for a plan in the Resource Manager. 
    • C、Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. 
    • D、Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.

    正确答案:B

  • 第3题：

    What view might you use to try to determine how long a particular backup will take?（）

    • A、V$SESSION_EVENT 
    • B、V$SESSION 
    • C、V$W0041ITS
    • D、V$WAITSTAT 
    • E、V$SESSION_LONGOPS 

    正确答案:E

  • 第4题：

    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）  

    • A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
    • B、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
    • C、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
    • D、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

    正确答案:A

  • 第5题：

    In what view are you likely to see the following output？（）   SID SERIAL# EVENT SECONDS_IN_WAIT  121 269 RMAN backup & recovery I/O 2  129 415 SQL*Net message from client 63 130 270 SQL*Net message from client  

    • A、 V$SESSION_EVENT
    • B、 V$SESSION
    • C、 V$WAITS
    • D、 V$WAITSTAT
    • E、 V$SYSSTAT

    正确答案:B

  • 第6题：

    What view might you use to try to determine how long a particular backup will take？（）  

    • A、 V$SESSION_EVENT
    • B、 V$SESSION
    • C、 V$WAITS
    • D、 V$WAITSTAT
    • E、 V$SESSION_LONGOPS

    正确答案:E

  • 第7题：

    单选题
    You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）
    A

    Update the view to use an outer join between the Customers and Sales tables.

    B

    Create a clustered index on the v CustomerSales view.

    C

    Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.

    D

    Create a stored procedure for the business analysts that uses the v CustomerSales view.


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

  • 第8题：

    单选题
    There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）
    A

    Define user profiles and set the CPU_PER_CALL limit. 

    B

    Define a SWITCH_TIME for a plan in the Resource Manager. 

    C

    Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations. 

    D

    Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.


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

  • 第9题：

    单选题
    What view might you use to try to determine how long a particular backup will take？（）
    A

     V$SESSION_EVENT

    B

     V$SESSION

    C

     V$WAITS

    D

     V$WAITSTAT

    E

     V$SESSION_LONGOPS


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

  • 第10题：

    单选题
    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）
    A

    create a backup of the database and recover all corrupted blocks found in the backup

    B

    run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database

    C

    run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view

    D

    run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view

    E

    run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired


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

  • 第11题：

    单选题
    You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）
    A

     V$SYSSTAT

    B

     V$SESSSTAT

    C

     V$RSRC_PLAN

    D

     V$RSRC_CONSUMER_GROUP


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

  • 第12题：

    单选题
    You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）
    A

     V$BACKUP_CORRUPTION

    B

     V$COPY_CORRUPTION

    C

     V$DATABASE_BLOCK_CORRUPTION

    D

     RC_BACKUP_CORRUPTION


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

  • 第13题：

    You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

    • A、V$SESSION 
    • B、V$SYSSTAT 
    • C、DBA_SEGMENTS 
    • D、V$SORT_USAGE

    正确答案:D

  • 第14题：

    Which view provides information on the backup status of the datafiles in the database？（）  

    • A、 V$BACKUP
    • B、 V$BACKUP_STATUS
    • C、 V$BACKUP_DATAFILE
    • D、 V$DATAFILE_BACKUP
    • E、 V$TABLESPCE_BACKUP

    正确答案:A

  • 第15题：

    Which view provides information on the backup status of the datafiles in the database?（）

    • A、V$BACKUP
    • B、V$BACKUP_STATUS 
    • C、V$BACKUP_DATAFILE 
    • D、V$DATAFILE_BACKUP 
    • E、V$TABLESPCE_BACKUP

    正确答案:A

  • 第16题：

    A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

    • A、granting SELECT privilege to SMITH on V$SESSION
    • B、granting SELECT privilege to SMITH on V_$SESSION
    • C、asking the user SMITH to run the catalog.sql script
    • D、granting SELECT privilege to SMITH on V$FIXED_TABLES
    • E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
    • F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

    正确答案:B,F

  • 第17题：

    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

    • A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
    • B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
    • C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
    • D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    正确答案:C

  • 第18题：

    You need to recommend a backup strategy for Hyper-V. What should you recommend？（）

    • A、Take a snapshot of each VM， and then run a full backup of the Hyper-V hosts by using Windows Server  Backup.
    • B、Shut down the VMs，and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.
    • C、From each VM,run a full backup by using Windows Server Backup， and then run a full backup of the Hyper-V hosts by using Windows Server Backup.
    • D、From each VM,run a full backup by using Windows Server Backup. Shut down the VMs， and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.

    正确答案:C

  • 第19题：

    单选题
    In what view are you likely to see the following output？（）   SID SERIAL# EVENT SECONDS_IN_WAIT  121 269 RMAN backup & recovery I/O 2  129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
    A

     V$SESSION_EVENT

    B

     V$SESSION

    C

     V$WAITS

    D

     V$WAITSTAT

    E

     V$SYSSTAT


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

  • 第20题：

    单选题
    Which view provides information on the backup status of the datafiles in the database？（）
    A

     V$BACKUP

    B

     V$BACKUP_STATUS

    C

     V$BACKUP_DATAFILE

    D

     V$DATAFILE_BACKUP

    E

     V$TABLESPCE_BACKUP


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

  • 第21题：

    单选题
    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
    A

     The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

    D

     The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management


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

  • 第22题：

    单选题
    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）
    A

     The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.

    B

     The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.

    C

     The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    D

     The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.


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

  • 第23题：

    单选题
    You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
    A

     V$FLASHBACK_DATABASE_LOG

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$DATABASE

    D

     V$UNDOSTAT


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

相关内容