Your database initialization parameter file has the following entry：   SEC_MAX_FAILED_LOGIN_ATTEMPTS=3   Which statement is true regarding this setting？（）

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 permission on the DBMS_FLASHBACK package must be granted to the user.

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 . 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 . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

A . The database must have multiplexed redo log files B . The database must be in the MOUNT state to execute the command C . The database must be in the NOMOUNT state to execute the command D . The database must be opened in RESTRICTED mode before this operation E . The database must be opened with the RESETLOGS option after the flashback operatio

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 . renaming the control files B . dropping a user in your database C . enabling or disabling redo log archiving D . dropping a tablespace in your database E . re-creating the control files， after you lost all the control files in your database

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 . Only the SET command must be within a RUN block. B . All commands should be executed at the RMAN prompt. C . All three commands must be within a single RUN block. D . Only the RESTORE and RECOVER commands must be within a single RUN block.

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 .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

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 . You can perform open database backups. B . You can perform closed database backups. C . You cannot perform schema-level logical backups. D . You can perform the backup of only the SYSTEM tablespace when the database is open.

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 .  Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs. B .  Just back up the database datafiles without shutting down the database. C .  You will have to wait until you can shut down the database to perform the backup. D .  Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up. E .  Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backu

A . the time when the last flashback operation in your database was performed B . the time when the first flashback operation in your database was performed C . a list of flashback operations performed in your database using SCN and time D . the approximate time and the lowest system change number （SCN） to which you can flash back your database

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 .  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 . 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 .  The database must have multiplexed redo log files B .  The database must be in the MOUNT state to execute the command C .  The database must be in the NOMOUNT state to execute the command D .  The database must be opened in RESTRICTED mode before this operation E .  The database must be opened with the RESETLOGS option after the flashback operatio

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.

A . configure the database to run in ARCHIVELOG mode B . configure the Flash Recovery Area to enable automatic database backup C . schedule the database backup using DBMS_JOB package after creating the database D . schedule the database backup using Recovery Manager （RMAN）commands after creating the database E . schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

A .  Complete database recovery. B .  Incomplete database recovery. C .  Approximate database recovery. D .  Archived database recovery. E .  The database could not be recovered with RMAN.

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