Why would you execute the report obsolete command？（）  

相似题目

• You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）

  A .  a list of files that require a backup within three days B .  a list of files that have not been backed up for three days 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 and may need a backup after three day

  查看最佳答案

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

  查看最佳答案

• In the Expression Editor panel of CRS Script Editor, why would you use the Java tab? （）

  A . to execute a specified method of a Java class   B . to reference a variable or invoke a method of a custom Java Object   C . to pass variables between two different workflows   D . to create an object for the purpose of executing methods on a remote computer   E . to get a reference to the Contact and Session states   F . to allow for arguments to be passed to a specified method

  查看最佳答案

• Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；

  A .  to undo the changes made to the EMP table since the specified time B .  to restore the EMP table that was wrongly dropped from the database C .  to view the transactions that have modified the EMP table since the specified time D .  to view the changes made to the EMP table for one or more rows since the specified time

  查看最佳答案

• Why would you use the following FLASHBACK TABLE command？（）  FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； 

  A . to undo the changes made to the EMP table since the specified time B . to restore the EMP table that was wrongly dropped from the database C . to view the transactions that have modified the EMP table since the specified time D . to view the changes made to the EMP table for one or more rows since the specified time E . to recover the EMP table to a point in time in the past by restoring the most recent backu

  查看最佳答案

• You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）

  A . It succeeds because the PDB_ADMIN user has the required privileges. B . It fails because common users are unable to use the SET CONTAINER statement. C . It fails because local users are unable to use the SET CONTAINER statement. D . If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

  查看最佳答案

• Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）

  A . FORMS_DDL  B . DO_SQL  C . FORM_SUCCESS  D . FORM_NOT_SUCCESS E . DBMS.ERROR_CODE

  查看最佳答案

• View the Exhibit. https://assets.asklib.com/images/image2/2018080210291676439.jpg You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which type of backup would this command perform？（）

  A . backup set B . image copy C . incremental backup D . None; the user receives an error indicating that the backup type must be specified.

  查看最佳答案

• The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database：  RMAN> REPORT OBSOLETE;  What would you see in the output？（）

  A . a list of all the expired backups and copies B . a list of all those files that have been deleted in the last two days C . a list of all those files that have been recovered within the last two days D . a list of backups and copies that are outside the range covered by the current retention policy

  查看最佳答案

• 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 started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）

  A . guarantee undo retention B . add one more redo log group C . size the redo log files appropriately D . size the UNDO tablespace appropriately E . size the SYSTEM tablespace appropriately F . configure an appropriate undo retention interval G . change automatic undo management to manual

  查看最佳答案

• 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

  查看最佳答案

• After executing the "show host" command, which of the information below would you see?（）

  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

  查看最佳答案

• You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error：  ORA-01555： snapshot too old  How would you prevent such an error in the future？（）

  A . guarantee undo retention B . add one more redo log group C . size the redo log files appropriately D . size the UNDO tablespace appropriately E . size the SYSTEM tablespace appropriately F . configure an appropriate undo retention interval G . change automatic undo management to manual

  查看最佳答案

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

  查看最佳答案

• Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; 

  A . to undo the changes made to the EMP table since the specified time B . to restore the EMP table that was wrongly dropped from the database C . to view the transactions that have modified the EMP table since the specified time D . to view the changes made to the EMP table for one or more rows since the specified time E . to recover the EMP table to a point in time in the past by restoring the most recent backu

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 

  A . a list of files that require a backup within three days B . a list of files that have not been backed up for three days 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 and may need a backup after three day

  查看最佳答案

• In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting？（）

  A . The retention policy is cleared. B . RMAN does not consider any backup as obsolete. C . The retention policy is set to its default setting of redundancy 1. D . The retention policy is set to its default setting of recovery window 7.

  查看最佳答案

• Why would you run the delete obsolete command？（）  

  A .  To remove missing backup set pieces physically from disk B .  To remove metadata related to backup set pieces in the control file and the recovery catalog C .  To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets D .  To delete backup set pieces associated with backups that are no longer needed due to retention criteria E .  To remove old versions of RMAN backu

  查看最佳答案

• Examine the SQL statements that creates ORDERS table: https://assets.asklib.com/images/image2/201808011530357709.jpg For which columns would an index be automatically created when you execute the above SQL statement? （）

  A . SER_NO B . ORDER_ID C . STATUS D . PROD_ID E . ORD_TOTAL F . Composite index on ORDER_ID and ORDER_DATE

  查看最佳答案

• 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

  查看最佳答案

• Why did the tribe from Central Africa describe the picture differently from how you or I would describe the photo?

  查看最佳答案

• 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

  查看最佳答案