ITPub博客

（137）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 database and want to replay ...

（136）You issued the following command to mount the DATA disk group in restricted mode:ALTER DISKGROUP data MOUNT RESTRICT;What is the implication of this command?A. The client RDBMS instance can access the file as a read-only file.B. A new disk cannot be added to a disk group.C....

（135）The ADMIN_EMP table has columns EMPNO,ENAME,DEPTNO,and SAL.It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column.You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tables...

（134）You are managing an Oracle Database 11g database.You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB.You have tape drives of 300 MB each.To accomplish the backup,you issued the following RMAN command:RMAN>BACKUP SECTION SIZE 30...

（133）You performed the RMAN database backup with the KEEP option.Which two statements are true regarding this backup?(Choose two.)A. The backup contains data files,the server parameter file,and the control file even if the control file autobackup is disabled.B. The KEEP option overrides...

（132）You are managing an Oracle Database 11g database.You want to take the backup of MULT_DATA,a big file tablespace of size 100 TB on tape drive,but you have tape drives of only 10 GB each.Which method would accomplish the task quickly and efficiently?A. parallel image copy backupB...

（131）Exhibit:View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you assign?A. 1440 MBB. 90 MBC. 362 MBD. 272 MB

（130）Which are the prerequisites for performing flashback transactions on your database?(Choose all that apply.)A. Undo retention guarantee for the database must be configured.B. Supplemental log must be enabled for the primary key.C. Supplemental log must be enabled.D. Execute perm...

（129）You are managing an Oracle Database 11g database with ASM storage.The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.Which statements are true regarding extent management and allocation units in the ASM disk group?(Choose all that apply.)A. The au_size disk group attribute...

（128）You want to track and store all transactional changes to a table over its lifetime.To accomplish this task,you enabled Flashback Data Archive with the retention of 5 years.After some time,the business requirement changed and you were asked to change the retention from 5 years to 3 year...

（127）The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.Which option of Data Pump Import would you use to accomplish this?A. ownerB. touserC. attachD. remap_schema答案：（D）...

（126）Which statements are true regarding the creation of an incident package file by using the EM Workbench Support?(Choose all that apply.)A. You can add or remove the trace files to the package.B. You can create the incremental incident package ZIP file for new or modified diagnostic info...

（125）Which statement describes the significance of the CHANGE FAILURE command in RMAN?(Choose all that apply.)A. It is used to change failure priority only for HIGH or LOW priorities.B. It is used to execute the advised repair script.C. It is used to change failure priority only for the...

（124）You are managing Oracle Database 11g with an ASM storage with high redundancy.The following command was issued to drop the disks from the dga disk group after five hours:ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;Which statement is true in this scenario?A. ...

（123）What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)A. It cannot generate recommendations that support multiple workload queries.B. It can recommend partitioning on tables provided that the workloads have some predicates and joi...

（122）Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g?(Choose all that apply.)A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository(ADR).B. The problem key is the ...

（121）Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?(Choose three.)A. It creates jobs without considering the priorities associated with them.B. It translates tasks into jobs for execution by the scheduler.C. It determines the list of ...

（120）You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine.Both instances use the ASM instance as storage.Which statement regarding the ASM disk group compatibility attributes are true in this scenario?(Choose all that apply.)A. The dat...

（119）While performing the backup of the flash recovery area,you notice that one of the archived redo log files is missing.You have multiple destinations for archived redo log files.What implications does it have on the backup of the flash recovery area?A. The backup fails because one of...

（118）Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?A. SQL statements that are part of the AWR baseline onlyB. SQL statements based on the AWR top SQL identificationC. SQL statements that are part of the available SQL Tuning Set(STS)only...