Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）

A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

A . You must use Oracle predefined names to identify raw partitions that will hold OMF structures.  B . You must define directories for two online redo log groups and three copies of the control file.  C . If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.  D . You must use only OMF data files when adding new tablespaces or data files to your database in the future.

A . only the control file, the current SPFILE, and data files B . only the current SPFILE and data files if autobackup is disabled C . only the data files and the archived redo logs D . the control file, current SPFILE file, data files, and archived redo log

A . The backup is similar to image copy. B . The backup contains all used data blocks. C . The backup contains only unused data blocks. D . The backup contains all data blocks changed since the last incremental level 1 backup.

A . Undo data becomes obsolete after 1，000 seconds. B . Undo data gets refreshed after 1，000 seconds. C . Undo data will be stored permanently after 1，000 seconds. D . Committed undo data would be retained for 1，000 seconds if free undo space is available. E . Undo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.

A . Restore and recover the datafile.  B . Restore and recover the tablespace.  C . Restore and recover the database.  D . Restore and recover the control file.  E . Restore and recover the parameter file.

A . backup of offline tablespaces B . backup of read­only tablespaces C . backup of system­critical tablespaces D . backup of online， locally managed tablespaces E . backup of read/write dictionary­managed tablespace

A . The backup is similar to image copy. B . The backup contains all used data blocks. C . The backup contains only unused data blocks. D . The backup contains all data blocks changed since the last incremental level 1 backup.

A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

A .  The database does not record flashback logs for MY_TABLESPACE B .  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin. C .  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature. D .  None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

A .  Backup of offline tablespaces. B .  Backup of read-only tablespaces. C .  Backup of system-critical tablespaces. D .  Backup of online， locally managed tablespaces. E .  Backup of read/write dictionary-managed tablespaces.

A . every week B . a day C . every trip D . a watch or once a trip，whichever is shorter

A . Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set B . The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set C . The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set D . Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startu

A .  You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage. B .  You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage. C .  You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles. D .  You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

A . The destination must be global only. B . A maximum of five destinations can be assigned. C . A maximum of ten different destinations can be assigned. D . All the destinations are determined by the server automatically. E . The destination may be local or remote for a Standby Database. F . The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

A .  Restore and recover the datafile. B .  Restore and recover the tablespace. C .  Restore and recover the database. D .  Restore and recover the control file. E .  Restore and recover the parameter file.

A .  only the control file， the current SPFILE， and data files B .  only the current SPFILE and data files if autobackup is disabled C .  only the data files and the archived redo logs D .  the control file，current SPFILE file，data files，and archived redo log

A . The database instance aborts. B . The database operation temporarily halts till the member becomes available. C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members. D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file. E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

A . Execute the ALTER DATABASE ARCHIVELOG statement B . Select ARCHIVELOG option in the database control and restart the database to apply the changes. C . Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. D . Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL ＞ SHUTDOWN IMMEDIATE SQL ＞ STARTUP MOUNT SQL ＞ FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema？（） A. Only 1 B. Only 2 C. Only 3 D. 3 and 1 E. 1 and 2

Part II Vocabulary & Structure Directions: This part is to test your ability to construct correct and meaningful sentences. It consists of 2 sections. Section A Directions: In this section, there are 10 incomplete sentences. You are required to complete each one by deciding on the most appropriate word or words from the 4 choices marked A), B), C) and D). Then you should mark the corresponding letter on the Answer Sheet with a single line through the center. 25. It was not until yesterday __________ they decided to reopen the business talk. （） A．when B．which C．that D．as

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' /> A. Only one channel is allocated and the backup is created in the flash recovery area B. Only one channel is allocated and the backup is created in the destination specified for channel C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2 D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA