In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

相似题目

• Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

  A .  log writer B .  archival C .  process monitor D .  system monitor E .  change tracking writer F .  database writer

  查看最佳答案

• Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

  A .  ALTER DATABASE DROP LOGFILE GROUP 1 B .  ALTER DATABASE CLEAR LOGFILE GROUP 1 C .  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1 D .  ALTER DATABASE DROP LOGFILE MEMBER ’D：\REDO01.LOG&rsquo

  查看最佳答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

  A .  import the database from the last export B .  restore all the members in the group from the last backup C .  drop the lost member from the database and then add a new member to the group D .  restore all the database files from the backup and then perform a complete recovery E .  restore all the database files from the backup and then perform an incomplete recovery

  查看最佳答案

• 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 production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

  A . archival B . log writer C . database writer D . system monitor E . process monitor F . change tracking writer

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

  A .  open the database with the RESTRICTED option B .  open the database with the RESETLOGS option C .  recover to the required SCN only that data file in which the error occurred D .  recover all the data files to the same system change number （SCN）

  查看最佳答案

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

  查看最佳答案

• 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

  查看最佳答案

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

  查看最佳答案

• When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  

  A .  log_file_name_convert B .  convert_log_file_name C .  file_name_convert_log D .  redo_log_file_name_convert E .  logfile_convert_directory

  查看最佳答案

• Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

  A .  The database does not record flashback logs for MY_TABLESPACE B .  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin. C .  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature. D .  None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

  查看最佳答案

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

  查看最佳答案

• 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

  查看最佳答案

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

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）

  A . open the database with the RESETLOGS option B . open the database with the RESTRICTED option C . recover all the data files to the same system change number （SCN） D . recover to the required SCN only that data file in which the error occurred

  查看最佳答案

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

  查看最佳答案

• The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） 

  A .  The database will hang. B .  The database will be crashed. C .  The database will be shut down. D .  The LGWR process writes redo log entries to the other redo log member of the Group2 grou

  查看最佳答案

• As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

  A .  Shut down the database B .  Clear the online redo log C .  Back up the database D .  Checkpoint the database E .  Call Oracle support

  查看最佳答案

• If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  A .  Complete database recovery. B .  Incomplete database recovery. C .  Approximate database recovery. D .  Archived database recovery. E .  The database could not be recovered with RMAN.

  查看最佳答案