You execute the following PL/SQL:Which two statements are true?（）

相似题目

• You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）

  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

  查看最佳答案

• Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）

  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

  查看最佳答案

• You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

  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.

  查看最佳答案

• You issue the following command on the RMAN prompt.   REPORT NEED BACKUP DAYS 5；   Which statement is true about executing this command？（）  

  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

  查看最佳答案

• You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

  A .  OPEN B .  MOUNT C .  NORMAL D .  NOMOUNT

  查看最佳答案

• You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

  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；

  查看最佳答案

• You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）  

  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

  查看最佳答案

• You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）

  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.

  查看最佳答案

• You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

  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.

  查看最佳答案

• You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）

  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.

  查看最佳答案

• You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

  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.

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this 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

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

  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.

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

  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

  查看最佳答案

• You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

  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

  查看最佳答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  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.

  查看最佳答案

• You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?（）

  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

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

  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.

  查看最佳答案

• You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

  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.

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）

  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

  查看最佳答案

• Before a Flashback Table operation，you execute the following command：   ALTER TABLE employees ENABLE ROW MOVEMENT；   Why would you need this to be executed？（）  

  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

  查看最佳答案

• You executed the following commands in a database session:What could have caused the recycle bin to clean up？（）

  <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

  查看最佳答案

• View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL＞ EXECUTE dbms_resources_manager.validate_pending_area ();What could be the reason？（）

  <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

  查看最佳答案

• Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed？（）

  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

  查看最佳答案