You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：
1：Shut down the instance.
2：Execute the ALTER DATABASE ARCHIVELOG command.
3：Start up the instance and mount the database.
4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database.
Which is the correct sequence of steps for accomplishing the task（）
A.4，1，3，2，5
B.1，3，4，5，2
C.1，3，2，5；4 not required
D.4，1，5，2；3 not required
E.1，3，4，5；2 not required
您可能感兴趣的试卷
你可能感兴趣的试题
You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.
What will be the implications on the archiving and the location of archive redo log files（）
A.Archiving will be disabled because the destination for the redo log files is missing.
B.The database instance will shut down and the error details will be logged in the alert log file.
C.Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.
D.Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）
A.flashback log files
B.backups that have become obsolete
C.copies of the data files and control files
D.archived redo log files that have multiple copies in a different archive location and not backed up
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.
Which configuration will you do to accomplish the task（）
A.Multiplex all database files
B.Configure the Flash Recovery Area.
C.Configure the database instance for ARCHIVELOG mode.
D.Configure the FAST_START_MTTR_TARGET initialization parameter.
A.Inactive and current redo log files are required to accomplish recovery.
B.Online and archived redo log files are required to accomplish instance recovery.
C.All redo log entries after the last checkpoint are applied from redo log files to data files.
D.All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in each redo log group.
A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation（）
A.The online redo log files and archived redo log files are required to accomplish the recovery.
B.The uncommitted transaction will be committed at the next startup of the database instance.
C.The uncommitted transaction is rolled back automatically at the next opening of the database.
D.The DBA has to perform the recovery on the database to recover the uncommitted transaction.
Given below is a list of scenarios：
1）A user terminates his session abnormally.
2）The connection between the server and the client application terminates because of a network failure.
3）A schema is accidentally dropped.
4）The tablespace is accidentally dropped from the database.
5）The hard disk gets corrupted and the data files in the disk are lost.
6）The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery（）
A.4 and 5
B.1，3，and 6
C.4，5，and 6
D.3，4，and 5
E.1，2，and 6
最新试题
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）
In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error（）
Which statements are true regarding the Oracle Data Pump export and import operations（）
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（）
Examine the following statement that is used to modify the primary key constraint on the SALES table：SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；Which three statements aretrue regarding the above command（）
In a new installation of Oracle Database 11g， you perform these activities：1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed（）
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this（）