ITPub博客

（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

场景：Oracle Grid上单实例数据库配置,数据库创建在Oracle ASM上.         修改初始化参数时,提示错误：ORA-32000: write to SPFILE requested but SPFILE is not modifiable数据库版本：Oracle 11.2.0.3解决：1. 首先想到的是数据库实例是否是用spfile启动的,如果不是，当然...

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

/etc/vfstab：用户可以修改，系统在启动时读取该配置文件，自动挂载相应的文件系统/etc/mntab：用户不可以修改，记录系统当前已经挂载的文件系统，随着系统的运行在不断变化

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

（117）Which two changes and their effect on the system can be tested by using the Database Replay feature?(Choose two.)A. multiplexing of the control fileB. adding the redo log member to the databaseC. database and operating system upgradesD. changing the database storage to ASM-mana...

（116）Which two are the uses of the ASM metadata backup and restore(AMBR) feature?(Choose two.)A. It can be used to back up all data on ASM disks.B. It can be used to recover the damaged ASM disk group along with the data.C. It can be used to gather information about a preexisting ASM di...

（115）What are the advantages of variable extent size support for large ASM files?(Choose two.)A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.B. It improves performance in the extended cluster configuration by reading from a loc...

（114）Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g?(Choose all that apply.)A. Generate reports on data failure such as data file failures.B. You can track the Service Request(SR)and implement repairs.C. You can package and upload d...