In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？ （）

相似题目

• Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode. E . The database operates in NOARCHIEVELOG mode.

  查看最佳答案

• You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）

  A . RCO1 only. B . DB01 only. C . DB02 only. D . DB01 and DB02 only. E . DB01，DB02，and RC01.

  查看最佳答案

• Identify the situations in which you use the alert log file in your database to check the detail.（）

  A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated." E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

  查看最佳答案

• Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）

  A .  You find that one of the redo log members in each redo log group is lost. B .  You find that a data file that belongs to the USERS tablespace is damaged. C .  You find that a data file that belongs to the SYSTEM tablespace is damaged. D .  You find that the current redo log group is damaged and is not available for recovery. E .  You realized while performing a recovery that an archived redo log file needed for recovery is lost.

  查看最佳答案

• You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）

  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

  查看最佳答案

• You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

  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

  查看最佳答案

• Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

  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

  查看最佳答案

• You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）

  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.

  查看最佳答案

• Identify the two situations in which you use the alert log file in your database to check the details.（）

  A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."  E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

  查看最佳答案

• Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）

  A . the size of an undo block B . the size of the redo log files C . undo blocks generated per second D . the size of the database buffer cache E . the value of the UNDO_RETENTION parameter

  查看最佳答案

• In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）

  A . The C # # ROLE1 role is created in the root database and all the PDBs. B . The C # # ROLE1 role is created only in the root database because the container clause is not used. C . Privileges are granted to the C##A_ADMIN user only in the root database. D . Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. E . The statement for granting a role to a user fails because the CONTAINER clause is not used.

  查看最佳答案

• You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

  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

  查看最佳答案

• Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel­based recovery？（）

  A . You find that one of the redo log members in each redo log group is lost. B . You find that a data file that belongs to the USERS tablespace is damaged. C . You find that a data file that belongs to the SYSTEM tablespace is damaged. D . You find that the current redo log group is damaged and is not available for recovery. E . You realized while performing a recovery that an archived redo log file needed for recovery is lost.

  查看最佳答案

• Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）

  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.

  查看最佳答案

• Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode.  E . The database operates in NOARCHIEVELOG mode.

  查看最佳答案

• Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

  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.

  查看最佳答案

• 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 work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

  A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

  查看最佳答案

• Examine the parameter setting in your database: https://assets.asklib.com/images/image2/2018080215045780340.jpg Which statement is correct about the 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

  查看最佳答案

• Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

  A . The destination must be global only. B . A maximum of five destinations can be assigned. C . A maximum of ten different destinations can be assigned. D . All the destinations are determined by the server automatically. E . The destination may be local or remote for a Standby Database. F . The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

  查看最佳答案

• You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

  A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

  查看最佳答案

• In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

  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.

  查看最佳答案

• You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

  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

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）

  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.

  查看最佳答案

• In your database, the flash recovery area （FRA) is configured as the default for RMAN back

  In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' /> A. Only one channel is allocated and the backup is created in the flash recovery area B. Only one channel is allocated and the backup is created in the destination specified for channel C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2 D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

  查看最佳答案