You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（） 

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 . Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. B . FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. C . FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. D . FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

A .  run { open script backup_database； run script backup_database } B .  run { engage script backup_database； } C .  run { run script backup_database； } D .  Run { execute script backup_database； } E .  The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

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 .  OPEN B .  MOUNT C .  NORMAL D .  NOMOUNT

A .   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN； B .   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； C .   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； D .   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

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 code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view. B .  The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view. C .  The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view. D .  The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

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 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 .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

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

<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' /> A. The pending area is automatically submitted after the plan creation B. The procedure must be executed before creating the resources plan directive C. The SYS_GROUP resource consumer group is not included in the resource plan directive D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

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