You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:
1)Shut down the instance.
2)Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3)Execute the ALTER DATABASE FLASHBACK OFF command.
4)Start up the instance and mount the database.
5)Execute the ALTER DATABASE FLASHBACKON command.
6)Open the database.
Select the correct order in which these tasks need to be performed. ()
A.2,1,4,3,5,6
B.1,4,3,2,6,5
C.1,4,2,6,3,5
D.3,2,1,4,5,6
您可能感兴趣的试卷
你可能感兴趣的试题
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
A.The alert log file is corrupted.
B.A tablespace is accidentally dropped.
C.One of the redo log members is corrupted.
D.A database user terminates the session abnormally.
E.The hard disk on which the data file is stored is corrupted.
View the Exhibit and examine the parameters.
User A executes the following command to update the TRANS table: SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’;
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command onthe TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario()
A.The ALTER TABLE command modifies the column successfully.
B.The DDL operation gets higher priority and transaction for user a is rolled back.
C.The ALTER TABLE command waits indefinitely until user a ends the transaction.
D.The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation of performance.
What would be your next step to improve performance? ()
A.Run the SQL Access Advisor.
B.Run the Memory Advisor for the sga.
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache.
最新试题
Which kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()
Which statements are true about checkpointing()
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted()
Which statements regarding the server parameter file (SPFILE) are true()
Which statements are correct about temporary tables()
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()
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is responsible for issuing alerts when the threshold is crossed()
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()