You executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5ignorecase=N  Which statement describes the purpose of the above password file（）

A .  To list all backups that were no longer available for restore operations B .  To list all backups that had aged beyond the RMAN retention criteria C .  To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media D .  To list all datafiles that are no longer part of the database and thus do not need to be backed up E .  To list all archived redo logs that are no longer needed for any database recovery

A . It will display a list of files that need incremental backup B . It will display a list of files that need backup after five days C . It will display a list of files that were backed up in the last five days D . It will display a list of files that have not been backed up in the last five days E . It will apply the current retention policy to determine the files that need to be backed u

A . Because row IDs may change during the flashback operation B . Because the object number changes after the flashback operation C . Because the rows are retrieved from the recycle bin during the flashback operation D . Because the table is moved forward and back to a temporary during the flashback opertio

A . ’SQL ALTER DATABASE OPEN’； B . SQL ALTER DATABASE ’OPEN’； C . OPEN DATABASE； D . DATABASE OPEN

A .  It will display a list of files that need incremental backup B .  It will display a list of files that need backup after five days C .  It will display a list of files that were backed up in the last five days D .  It will display a list of files that have not been backed up in the last five days E .  It will apply the current retention policy to determine the files that need to be backed u

A . Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT. B . Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session. D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully. E . One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

A .  A list of files that require a backup within 3 days B .  A list of files requiring more than 3 days of archivelogs to apply C .  A list of files that RMAN recommends be backed up only once in every three days，based on low volatility D .  A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

A .  All the objects of scott are moved to the Recycle Bin. B .  Any objects in the Recycle Bin belonging to scott are purged. C .  All the objects owned by scott are permanently dropped from the database. D .  All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E .  Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

A .  The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy. B .  The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup. C .  Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN. D .  Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

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 . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error. D . The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

A . All the objects of scott are moved to the Recycle Bin. B . Any objects in the Recycle Bin belonging to scott are purged. C . All the objects owned by scott are permanently dropped from the database. D . All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E . Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

A .  a list of files that require a backup within three days B .  a list of files requiring more than 3 days of archive logs to apply C .  a list of files that RMAN recommends be backed up only once in every three days，based on low volatility D .  a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

A . The database is in NOMOUNT state. B . The database is in ARCHIVELOG mode and the tablespace is online. C . The database is in ARCHIVELOG mode and the tablespace is offline. D . The database is in NOARCHIVELOG mode and the tablespace is online. E . The database is in NOARCHIVELOG mode and the tablespace is offline.

A . back up the control file to trace B . bring database to the MOUNT state C . open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D . set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

A . The IP addresses of workstations allowed gain access to the router via an access list B . Permanent name-to-address mappings created using the ip host command. C . Temporary and permanent DNS entries. D . The names of the routers created using the hostname command. E . The length of time of users logged into the router, as well as the duratio

A . A list of files that require a backup within 3 days B . A list of files requiring more than 3 days of archivelogs to apply C . A list of files that RMAN recommends be backed up only once in every three days, based on low volatility D . A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

A . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error D . The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

A .  The database is in NOMOUNT state. B .  The database is in NOARCHIVELOG mode and the tablespace is online. C .  The database is in NOARCHIVELOG mode and the tablespace is offline. D .  The database is in ARCHIVELOG mode and the tablespace is offline. E .  The database is in ARCHIVELOG mode and the tablespace is online.

A .  Create a backup of the database and recover all corrupted blocks found in the backup. B .  Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database. C .  Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view. D .  Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view. E .  Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

A .  back up the control file to trace B .  bring database to the MOUNT state C .  open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D .  set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

A .  It will display a list of files that need incremental backup. B .  It will display a list of files that need backup after five days. C .  It will display a list of files that were backed up in the last five days. D .  It will display a list of files that have not been backed up in the last five days. E .  It will apply the current retention policy to determine the files that need to be backed up.

A .  Because row IDs may change during the flashback operation B .  Because the object number changes after the flashback operation C .  Because the rows are retrieved from the recycle bin during the flashback operation D .  Because the table is moved forward and back to a temporary during the flashback opertio

<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135140/f84ceb3fdc962e09d81033fbefe54bf9.jpg' /> A. There is demand for space from the new table B. The undo tablespace does not have sufficient free space C. The new table name is the same as the table name in the recycle bin D. The temporary tablespace that is assigned to you does not have sufficient free space

A. Because row IDs may change during the flashback operation B. Because the object number changes after the flashback operation C. Because the rows are retrieved from the recycle bin during the flashback operation D. Because the table is moved forward and back to a temporary during the flashback operation