单选题You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）AExamine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.BEnable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.CEnable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.DEnable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
单选题
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）
A
Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
B
Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
C
Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
D
Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
参考解析
解析：
暂无解析
相关考题：
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following commands:Which two statements are true regarding the tasks accomplished with these commands?（）A. They import all metadata from the RCAT10 catalog.B. They unregister the database from the RCAT10 catalog.C. They do not register the databases registered in the RCAT10 catalog.D. They register all databases registered in the RCAT10 catalog.
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities? （）A. to minimize plan regression due to the use of a new optimizer versionB. to completely avoid the use of new plans generated by a new optimizer versionC. to prevent plan capturing when the SQL statement is executed after the database upgradeD. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL@utlu111i.sqlWhich statement about the execution of this script is true?（）A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run.The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs.How do you accomplish this?（）A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
What are two benefits of installing Grid Infrastructure software for a stand－alone server before installing and creating an Oracle database?() A. Effectively implements role separationB. Enables you to take advantage of Oracle Managed Files.C. Automatically registers the database with Oracle Restart.D. Helps you to easily upgrade the database from a prior release.E. Enables the Installation of Grid Infrastructure files on block or raw devices.
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this： RMAN CONNECT CATALOG rco11/password@catdb RMAN IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242； What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）A、 The scripts in the RCO11 catalog are overwritten.B、 RMAN renames the local stored scripts in the RCO11 catalog.C、 The RMAN session in which the command is executed aborts.D、 RMAN renames the global scripts that are imported from the RCAT10 catalog.
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQLALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema. Which process writes the before images of the physical database blocks to the flashback database logs？（）A、 LGWRB、 DBWRC、 MMOND、 RVWR
In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A、Oracle Migration AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）A、The ASM compatibility attribute controls the format of the disk group metadata.B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You executed the following commands： RMAN CONNECT CATALOG rco11/password@catdb RMAN IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER； Which two statements are true regarding the tasks accomplished with these commands？（）A、 They import all metadata from the RCAT10 catalog.B、 They unregister the database from the RCAT10 catalog.C、 They do not register the databases registered in the RCAT10 catalog.D、 They register all databases registered in the RCAT10 catalog.
What does it mean if a backup is expired?（）A、The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B、The backup set has one or more invalid blocks in it and is not usable for recovery. C、The backup set contains one or more tablespaces no longer in the database. D、The backup set contains one or more missing backup set pieces.E、The backup set is from a previous version of RMAN and was not upgraded.
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
You delete content from a file named Speed.doc that is stored in the C:///Data folder. You edit 20 files in this folder over the next two days. You need to restore the version of the file that had the correct data. You also need to ensure that the other files in the folder remain unaffected. What should you do？ （）A、From the Previous Versions tab， restore the version of the file that contains the correct data.B、Restore a version of the folder that contains the correct version of the file.C、Open a version of the folder that contains the correct version of the file.D、Copy a version of the folder that contains the correct version of the file. Replace the existing version of the folder with the older version.
单选题You delete content from a file named Speed.doc that is stored in the C:///Data folder. You edit 20 files in this folder over the next two days. You need to restore the version of the file that had the correct data. You also need to ensure that the other files in the folder remain unaffected. What should you do？ （）AFrom the Previous Versions tab， restore the version of the file that contains the correct data.BRestore a version of the folder that contains the correct version of the file.COpen a version of the folder that contains the correct version of the file.DCopy a version of the folder that contains the correct version of the file. Replace the existing version of the folder with the older version.
单选题What does it mean if a backup is expired？（）A The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B The backup set has one or more invalid blocks in it and is not usable for recovery.C The backup set contains one or more tablespaces no longer in the database.D The backup set contains one or more missing backup set pieces.E The backup set is from a previous version of RMAN and was not upgraded.
多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
单选题You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this： RMAN CONNECT CATALOG rco11/password@catdb RMAN IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242； What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）A The scripts in the RCO11 catalog are overwritten.B RMAN renames the local stored scripts in the RCO11 catalog.C The RMAN session in which the command is executed aborts.D RMAN renames the global scripts that are imported from the RCAT10 catalog.
多选题What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）AEffectively implements role separationBEnables you to take advantage of Oracle Managed Files.CAutomatically registers the database with Oracle Restart.DHelps you to easily upgrade the database from a prior release.EEnables the Installation of Grid Infrastructure files on block or raw devices.
单选题You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQLALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）A The log sequence is reset to 0.B All the online redo logs are deleted.C All the archived redo logs from a previous incarnation become useless.D The full database backup taken from a previous incarnation can be used in future.E Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
单选题You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema. Which process writes the before images of the physical database blocks to the flashback database logs？（）A LGWRB DBWRC MMOND RVWR
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility
单选题You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）Ato minimize plan regression due to the use of a new optimizer versionBto completely avoid the use of new plans generated by a new optimizer versionCto prevent plan capturing when the SQL statement is executed after the database upgradeDto keep the plan in the plan history so that it can be used when the older version of the optimizer is used
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）ASet OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.BCapture the plans from the previous version using STS and then load them into the stored outline.CCapture the plans from the previous version using STS and then load them into SQL Management Base (SMB).DSet OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL@utlu111i.sql Which statement about the execution of this script is true？（）A It must be executed from the Oracle Database 11g environment.B It must be executed only after the SYSAUX tablespace has been created.C It must be executed from the environment of the database that is being upgraded.D It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B Capture the plans from the previous version using STS and then load them into the stored outline.C Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.