NEW QUESTION 1

Which of the following are correct about block media recovery? (Choose all that apply.)

• A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.
• B. Logical corruptions are repairable by BMR.
• C. Physical corruptions are repairable by BMR.
• D. RMAN can use any backup for a BMR restore.
• E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore.

Answer: AC

Explanation:
Overview of Block Media Recovery (link)
Basic Concepts of Block Media Recovery
Whenever block corruption has been automatically detected, you can perform block media recovery manually with the RECOVER ... BLOCK command. By default, RMAN first searches for good blocks in the real-time query physical standby database, then flashback logs and then blocks in full or level 0 incremental backups.
Identification of Corrupt Blocks
✑ The V$DATABASE_BLOCK_CORRUPTION view displays blocks marked corrupt by database components such as RMAN, ANALYZE, dbv, and SQL queries. The following types of corruption result in the addition of rows to this view: Physical corruption (sometimes called media corruption) The database does not recognize the block: the checksum is invalid, the block contains all zeros, or the block header is corrupt. Physical corruption checking is enabled by default. You can turn off checksum checking by specifying the NOCHECKSUM option of the BACKUP command, but other physical consistency checks, such as checks of the block headers and footers, cannot be disabled.
✑ Logical corruption:
The block has a valid checksum, the header and footer match, and so on, but the contents are logically inconsistent. Block media recovery may not be able to repair all logical block corruptions. In these cases, alternate recovery methods, such as tablespace point-in-time recovery, or dropping and re-creating the affected objects, may repair the corruption. Logical corruption checking is disabled by default. You can turn it on by specifying the CHECK LOGICAL option of the BACKUP, RESTORE, RECOVER, and VALIDATE
commands.
The database can detect some corruptions by validating relationships between blocks and segments, but cannot detect them by a check of an individual block. The V$DATABASE_BLOCK_CORRUPTION view does not record at this level of granularity. Prerequisites for Block Media Recovery (link)
The following prerequisites apply to the RECOVER ... BLOCK command:
✑ The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
✑ If the target database is a standby database, then it must be in a consistent state, recovery cannot be in session, and the backup must be older than the corrupted file.
✑ The backups of the data files containing the corrupt blocks must be full or level 0 backups and not proxy copies.
If only proxy copy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file copies and searches them for blocks during block media recovery.
✑ RMAN can use only archived redo logs for the recovery. RMAN cannot use level 1 incremental backups. Block media recovery cannot survive a missing or inaccessible archived redo log, although it can sometimes survive missing redo records.
✑ Flashback Database must be enabled on the target database for RMAN to search
the flashback logs for good copies of corrupt blocks.
If flashback logging is enabled and contains older, uncorrupted versions of the corrupt blocks, then RMAN can use these blocks, possibly speeding up the recovery.
✑ The target database must be associated with a real-time query physical standby
database for RMAN to search the database for good copies of corrupt blocks.

NEW QUESTION 2

As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)
SQL> select group_number, name, state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE
============ ======= ========== 0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED

• A. The DGROUP1 disk group was unmounted by another DBA.
• B. A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
• C. One of the redundant disks (DGROUP1) has been lost in a disk group.
• D. This query has no meaning in an ASM instance.
• E. A disk associated with a disk group was discovered after the ASM instance initially opened.

Answer: AE

NEW QUESTION 3

Which of the following describes how a distributed resumable transaction behaves?

• A. The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.
• B. The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.
• C. The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction.
• D. None of the above.

Answer: C

NEW QUESTION 4

What is the proper command to shut down the database in a consistent manner?

• A. shutdown abort
• B. shutdown kill
• C. shutdown nowait
• D. shutdown immediate
• E. shutdown halt

Answer: D

NEW QUESTION 5

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

• A. Automatic PGA Memory Management
• B. Automatic SGA Memory Management
• C. Automatic Shared Memory Management
• D. Automatic Memory Management
• E. Manual SGA Memory Management
• F. None of the above

Answer: C

NEW QUESTION 6

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

• A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
• B. An upper limit on how far you can flash back the database, depending on theinformation in the undo tablespace
• C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
• D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space

Answer: C

NEW QUESTION 7

View the Exhibit1 to examine the series of SQL commands. View the Exhibit2 to examine
the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

parameter-optimizer (exhibit):

• A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
• B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
• C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
• D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

Answer: B

Explanation:
Setting the OPTIMIZER_MODE Initialization Parameter(Link)
The OPTIMIZER_MODE initialization parameter establishes the default behavior for choosing an optimization approach for the instance.
OPTIMIZER_MODE Initialization Parameter Values
✑ ALL_ROWS, The optimizer uses a cost-based approach for all SQL statements in the session regardless of the presence of statistics and optimizes with a goal of best throughput (minimum resource use to complete the entire statement). This is the default value.
✑ FIRST_ROWS_n, The optimizer uses a cost-based approach, regardless of the
presence of statistics, and optimizes with a goal of best response time to return the first n number of rows, where n equals 1, 10, 100, or 1000.
✑ FIRST_ROWS, The optimizer uses a mix of cost and heuristics to find a best plan
for fast delivery of the first few rows.
Note that using heuristics sometimes leads the optimizer to generate a plan with a cost that is significantly larger than the cost of a plan without applying the heuristic. FIRST_ROWS is available for backward compatibility and plan stability; use FIRST_ROWS_n instead.

NEW QUESTION 8

View the Exhibit and examine the RMAN commands.

Which statement describes the effect of a backup retention policy on the backup of a backup set?

• A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
• B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.
• C. The copies of the backup will be reported as obsolete under a recovery window-based backup retention policy.
• D. All the copies of the backup set are counted as one instance of a backup and will deleted in backup set exceeds the redundancy-based backup retention policy.

Answer: A

NEW QUESTION 9

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.
You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:
SQL> SELECT object_name, original_name, droptime FROM recyclebin;

What would be the outcome of the precedent statement?

• A. It retrieves the latest version of the table from the recycle bin
• B. It retrieves the oldest version of the table from the recycle bin
• C. It retrieves the version of the table for which undo information is available
• D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

Answer: A

NEW QUESTION 10

View the Exhibit to examine the parameter values. You are planning to set the value for the
MEMORY_TARGET parameter of your database instance. What value would you assign?
Exhibit:

• A. 1440 MB
• B. 90 MB
• C. 362 MB
• D. 272 MB

Answer: C

NEW QUESTION 11

You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window?

• A. The collection level for the AWR should be set to BASIC.
• B. The moving window size must be less than Undo Retention.
• C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.
• D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.

Answer: D

Explanation:
Moving Window Baseline (link)
A moving window baseline corresponds to all AWR data that exists within the AWR retention period. This is useful when using adaptive thresholds because the database can use AWR data in the entire AWR retention period to compute metric threshold values. Oracle Database automatically maintains a system-defined moving window baseline. The default window size for the system-defined moving window baseline is the current AWR retention period, which by default is 8 days.
If you are planning to use adaptive thresholds, consider using a larger moving window—such as 30 days—to accurately compute threshold values. You can resize the moving window baseline by changing the number of days in the moving window to a value that is equal to or less than the number of days in the AWR retention period. Therefore, to increase the size of a moving window, you must first increase the AWR retention period accordingly.

NEW QUESTION 12

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to terminate abnormally.
Which statement is true about the next database startup and the USERS tablespace?

• A. The database will open, and the tablespace automatically comes out of the backup mode.
• B. The database will be mounted, and recovery must be performed on the USERS tablespace.
• C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
• D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

Answer: C

NEW QUESTION 13

In what order would you execute the following steps to create a recovery catalog?

• A. Issue the create catalog command.
• B. Create the recovery-catalog database.
• C. Create the recovery-catalog user.
• D. Grant the recovery_catalog_owner privilege to the recovery-catalog user.
• E. Issue the register database command from the target database.
• F. a, b, c, d, e
• G. b, a, d, c, e
• H. b, c, d, a, e
• I. b, c, d, e, a
• J. b, d, c, a, e

Answer: C

NEW QUESTION 14

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.
How would you accomplish this task?

• A. Set metric threshold
• B. Implement Database Resource Manager
• C. Enable resumable timeout for user sessions
• D. Add directives to Automatic Database Diagnostic Monitor (ADDM)

Answer: B

NEW QUESTION 15

You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:
1. Put the tablespaces in backup mode.
2. Back up the datafiles for all tablespaces.
3. Take the tablespaces out of backup mode.
4. Back up all archived redo logs.
Your colleague asks for you to comment on his plan. Which response would be correct?

• A. The plan will work as is.
• B. The plan needs to be modified to allow for an archive-log switch after step 3.
• C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
• D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
• E. The plan cannot work as presented.

Answer: B

Explanation:
Without command ALTER SYSTEM SWITCH LOGFILE, the backup of archive redo logs will be useless.

NEW QUESTION 16

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?

• A. all disks in the disk group
• B. all disks that are currently in OFFLINE mode
• C. all disks that are not currently in OFFLINE mode
• D. all disks in the disk group only if all of them are ONLINE

Answer: C

Explanation:
Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks. Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately.
The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline before Oracle ASM drops the disk. If a disk is made available before the DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror side. In Oracle Database 11g, the online disk operation does not restart if there is a failure of the instance on which the disk is running. You must reissue the command manually to bring the disk online.

NEW QUESTION 17

Which of the following is true about job chains?

• A. They consist of one or more Scheduler programs.
• B. They are used to implement dependency scheduling.
• C. They are used to implement time-based scheduling.
• D. They are used to implement event-based scheduling.
• E. None of the above.

Answer: B

Explanation:
Creating and Managing Job Chains
A job chain ("chain") is a named series of tasks that are linked together for a combined objective. Chains are the means by which you can implement dependency based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs.

NEW QUESTION 18

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.
Which two statements describe the implications of this? (Choose two.)

• A. It produces less accurate results of the comparison analysis.
• B. It automatically calls the SQL Tuning Advisor for recommendations.
• C. It shortens the time of execution and reduces the impact on system resources.
• D. Only the changes in the execution plan, and not performance regression, are detected.

Answer: AC

NEW QUESTION 19

Which two statements are true about the compressed backups in RMAN? (Choose two.)

• A. Compressed backups can only be taken on the tape drives.
• B. The binary compression creates some performance overhead during backup operation.
• C. The ZLIB compression algorithm can be used only if the COMPATIBLE initialization parameter is set to 11.1.0.
• D. The media manager compression for the tape drive should be enabled for taking compressed backups on the tape.

Answer: BD

NEW QUESTION 20

The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.
Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)
Exhibit:

• A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
• B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
• C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
• D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

Answer: AD

Explanation:
Using Oracle Flashback Transaction Query with Oracle Flashback Version Query (link) The query uses Oracle Flashback Version Query pseudocolumns:
SELECT versions_xid XID, versions_startscn START_SCN, versions_endscn END_SCN, versions_operation OPERATION, empname, salary
FROM emp
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
WHERE empno = 111; Results are similar to:

C:\Users\albo\Desktop\1-1.jpg 3 rows selected.
The results table rows are in descending chronological order.
✑ The third row corresponds to the version of the row in the table emp that was inserted in the table when the table was created.
✑ The second row corresponds to the row in emp that the erroneous transaction
deleted.
✑ The first row corresponds to the version of the row in emp that was reinserted with a new employee name.

NEW QUESTION 21

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

• A. Point-in-time recovery
• B. Execute the ROLLBACK command with transaction number
• C. Flashback the database to before the transaction was committed
• D. Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

Answer: D

NEW QUESTION 22

You issue the following command on the RMAN prompt.
REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?

• A. It will display a list of files that need incremental backup
• B. It will display a list of files that need backup after five days
• C. It will display a list of files that were backed up in the last five days
• D. It will display a list of files that have not been backed up in the last five days
• E. It will apply the current retention policy to determine the files that need to be backed up

Answer: D

NEW QUESTION 23

True or false: tablespace point-in-time recovery is possible only with RMAN.

• A. True
• B. False

Answer: B

NEW QUESTION 24

Which dependent object will get invalidated even if it is not affected by the table redefinition?

• A. packages
• B. triggers
• C. synonyms
• D. views

Answer: B

Explanation:
Results of the Redefinition Process
The following are the end results of the redefinition process:
The original table is redefined with the columns, indexes, constraints, grants, triggers, and statistics of the interim table.
Dependent objects that were registered, either explicitly using REGISTER_DEPENDENT_OBJECT or implicitly using COPY_TABLE_DEPENDENTS, are renamed automatically so that dependent object names on the redefined table are the same as before redefinition.
Note:
If no registration is done or no automatic copying is done, then you must manually rename the dependent objects.
The referential constraints involving the interim table now involve the redefined table and
are enabled.
✑ Any indexes, triggers, materialized view logs, grants, and constraints defined on the original table (prior to redefinition) are transferred to the interim table and are dropped when the user drops the interim table. Any referential constraints involving the original table before the redefinition now involve the interim table and are disabled.
✑ Some PL/SQL objects, views, synonyms, and other table-dependent objects may become invalidated. Only those objects that depend on elements of the table that were changed are invalidated. For example, if a PL/SQL procedure queries only columns of the redefined table that were unchanged by the redefinition, the procedure remains valid. See "Managing Object Dependencies" for more information about schema object dependencies.

NEW QUESTION 25
......