-
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 nonASM instance to an ASM instance?()
A . Oracle Migration Assistant
B . Recovery Manager (RMAN)
C . Oracle Data Pump Export and Import
D . conventional Oracle Export and Import
E . operating system utilities to copy the files to the ASM instance
-
Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period?()
A . Enterprise Manager GUI
B . DBMS_TRACE package APIs
C . DBMS_ADVISOR package APIs
D . DBMS_MONITOR package APIs
E . $ORACLE_HOME/rdbms/admin/addmrpt.sql script
-
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario?()
A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
-
The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?()
A . control file
B . tnsnames.ora
C . data dictionary
D . initialization parameter file
-
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
A . Set the UNDO_RETENTION parameter to AUTO.
B . Create an initial undo segment in undotablespace.
C . Set the UNDO_RETENTION parameter to 900 or more
D . Set the initialization parameter UNDO_MANAGEMENT to AUTO
E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
-
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()
A . data files
B . control files
C . parameter file
D . online redo log files
E . server parameter file
-
You executed the following PL/SQL block successfully:
https://assets.asklib.com/images/image2/2018080209212755738.jpg
The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.()
A . with the CPU Usage finding if it is less than 90
B . without the CPU Usage finding if it is less than 90
C . with the CPU Usage finding for snapshots below 90
D . with the CPU Usage finding for snapshots not between 150 and 162
-
Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
A . ASMB
B . PMON
C . RBAL
D . SMON
-
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?()
A . It collects data from SGA and compares it with a preserved snapshot.
B . It collects data from SGA, analyzes it, and provides a report.
C . It collects data from SGA and compares it with the latest snapshot.
D . It collects data from both SGA and PGA, analyzes it, and provides a report
-
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components?()
A . MMAN
B . PMON
C . MMON
D . MMNL
-
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)()
A . The ADDM requires at least four AWR snapshots for analysis.
B . The ADDM runs after each AWR snapshot is collected automatically by MMON.
C . The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).
D . The ADDM analysis provides only diagnostic information but does not provide recommendations.
E . The ADDM calls other advisors if required, but does not provide recommendations about the advisors.
-
下面有关Automatic Database Diagnostic Monitor(ADDM)的描述中,那两项是正确的?()
A . ADDM可以调用其它建议如果需要,但是不会产生推荐建议
B . ADDM是MMON进程在每次awr快照收集后自动运行
C . ADDM至少需要4个awr快照进行分析
D . ADDM分析结果存放在Automatic Workload Repository中
E . ADDM仅提供诊断分析,不提供建议
-
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()
A . Enable the flash recovery area and specify it as the archived redo log destination.
B . Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C . Enable the flash recovery area but do not specify it as the archived redo log destination.
D . Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
-
Which of the following would you use to enable automatic media recovery for a database?()
A . SET AUTORECOVERY ON
B . SET RECOVERY ON
C . SET AUTO ON
D . You cannot enable automatic media recovery.
-
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
A . ASMB
B . PMON
C . RBAL
D . SMON
-
Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?()
A . ALTER SYSTEM KILL SESSION
B . ALTER SYSTEM DISCONNECT SESSION
C . ALTER SYSTEM QUIESCE RESTRICTED
D . ALTER SYSTEM ENABLE RESTRICTED SESSION
-
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()
A . Data files
B . Control files
C . Parameter file
D . Online redo log files
E . Server parameter file
-
Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature?()
A . SWITCH_TIME
B . SWITCH_GROUP
C . MAX_SESS_POOL
D . SWITCH_ESTIMATE
-
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()
A . Enable the flash recovery area and specify it as the archived redo log destination.
B . Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C . Enable the flash recovery area but do not specify it as the archived redo log destination.
D . Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
-
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.Which statement describes the consequence?()
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/d39131b84ca6a8d8b08830b9d4753c7b.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/4c44618d517b4d4d3a08325cfb73e2e3.jpg' />
A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
-
A database instance is using an Automatic Storage Management (ASM) instance, which has a d
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK ‘/devices/diska1‘, ‘/devices/diska2‘FAILGROUP controller2 DISK ‘/devices/diskb1‘, ‘/devices/diskb2‘ ;What happens when the whole CONTROLLER1 Failure group is damaged?()
A. The transactions that use the disk group will halt.
B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.
C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
-
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/f856003f497492b5fcd1516f347bc3b8.jpg' />
A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.
-
You are administering a database stored in Automatic Storage Management (ASM). You use RMA
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.In which three ways can you re-create the lost disk group and restore the data?()
A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
-
Examine the parameters for your database instance:Which three statements are true about the process of automatic optimization by using cardinalityfeedback?()
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.