ITPub博客

（73）You are managing an Oracle Database 11g database.  You configured the database to run in ARCHIVELOG mode.Which two statements are true in this scenario? (Choose two.)A. You must shut down the database instance to perform the backups.B. You must configure the Flash Recovery Area...

（72）You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG 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 t...

（71）You configured the Flash Recovery Area for your database. The database instance has been started in 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 bec...

（70）You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode.The default location for the archived redo log files is the Flash Recovery Area.Which two files are removed automatically if the space is required in the FRA as per the re...

（69）You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of 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 do...

（68）You are managing an Oracle Database 11g database. You want to ensure the recovery of the database 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 instanc...

（67）The instance abnormally terminates because of a power outage.Which statement is true about redo log files during instance recovery?A. Inactive and current redo log files are required to accomplish recovery.B. Online and archived redo log files are required to accomplish instance rec...

（66）You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)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_STA...

（65）Which two statements are true about checkpointing? (Choose two.)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...

（64）Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)A. The MTTR advisor will be disabled.B. Automatic checkpoint tuning will be enabled.C. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter ...

（63）Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications of these values in your database? (Choose two.)A. The SGA advisor will be disabled.B. The MTTR advisor will be enabled.C...

（62）You are in the middle of a transaction updating a very important table.The machine on which a database 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 fi...

（61）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 table...

（60）In which of the scenarios will the DBA perform recovery? (Choose all that apply.)A. The alert log file is corrupted.                              ...

（59）In your database, the current status of a PL/SQL procedure has become INVALID.Which action would fix the problem and make the PL/SQL procedure usable?A. Recompile the PL/SQL procedure.B. Modify the procedure to run with a definer's right.C. Modify the procedure to run with an in...

（58）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 on the TRANS table...

（57）Automatic Shared Memory Management is disabled for your database instance.You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.What would be your next step to improve performance?A. Run the...

（56）View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively.Why are advisors not available for the shared pool and the buffer cache?A. because the DB_CACHE_ADVICE parameter is set to OFFB. because Automatic Memory Management (AMM) is disa...

（55）View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US...

（54）Automatic Shared Memory Management (ASMM) has been enabled for your database instance.The initialization parameters for the components that are managed by ASMM are not set.After observing the effects of ASSM, you executed the following command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 1...