NEW QUESTION 1

To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?

• A. RESUMABLE_SPACE_TIME
• B. RESUMABLE_SPACE
• C. RESUMABLE_TIME
• D. RESUMABLE_TIMEOUT
• E. TIME_RESUMABLE

Answer: D

NEW QUESTION 2

Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

• A. A single ADR can support multiple ADR homes for different database instances.
• B. The alert files are stored in XML file format in the TRACE directory of each ADR home.
• C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to$ORACLE_BASE.
• D. The BACKGROUND_DUMP_DEST initialization parameter overrides theDIAGNOSTIC_DEST initialization parameter for the location of the alert log file.

Answer: AC

Explanation:
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
✑ If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
✑ If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to
ORACLE_HOME/log
Within ADR base, there can be multiple ADR homes, where each ADR home is the root directory for all diagnostic data—traces, dumps, the alert log, and so on—for a particular instance of a particular Oracle product or component. For example, in an Oracle Real Application Clusters environment with Oracle ASM, each database instance, Oracle ASM instance, and listener has an ADR home.

NEW QUESTION 3

Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

• A. set SHARED_POOL_SIZE to zero
• B. set STATISTICS_LEVEL to BASIC
• C. set SGA_TARGET to a non-zero value
• D. set DB_CACHE_SIZE to a non-zero value
• E. set STATISTICS_LEVEL to TYPICAL or ALL

Answer: AC

NEW QUESTION 4

View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.
Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?
ASM-disk-group-1 (exhibit):

ASM-disk-group-2 (exhibit):

• A. Because the disk group is created with NORMAL redundancy
• B. Because the disk repair time attribute is set to a nonzero value
• C. Because the mirrored extents cannot be rebalanced across the other three disks
• D. Because the other three disks have 60% free space, the disk rebalancing is delayed

Answer: B

Explanation:
Key points:
1. The COMPATIBILITY.ASM>=11.1 and COMPATIBILITY.RDBMS>=11.1
2. The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr. Refer to here.
Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For more information, refer to "Disk Group Compatibility".
Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought back online.
By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.

NEW QUESTION 5

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?

• A. Yes, if the database is in ARCHIVELOG mode.
• B. Yes, if the database is in NOARCHIVELOG mode.
• C. No, the backup is not usable in any way.
• D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.

Answer: C

NEW QUESTION 6

If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

• A. The next time you back up the database when you are also connected to the recovery catalog and the target database
• B. The next time you are connected to the target database and the recovery catalog database and issue the resync command
• C. The next time you connect RMAN to just the recovery catalog
• D. The next time you connect to the recovery catalog and the target database with RMAN
• E. Connecting to the recovery catalog and issuing the resync all databases command

Answer: AB

Explanation:
Deciding When to Resynchronize the Recovery Catalog
RMAN automatically resynchronizes the recovery catalog when
✑ RMAN is connected to a target database and recovery catalog
✑ And you have executed RMAN commands.
Thus, you should not need to manually run the RESYNC CATALOG command very often.

NEW QUESTION 7

Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?

• A. when ASM disk goes offline
• B. when one or more ASM files are dropped
• C. when some disks in a disk group are offline
• D. when some disks in a failure group for a disk group are rebalancing

Answer: C

Explanation:
In the FORCE mode, Oracle ASM attempts to mount the disk group even if it cannot discover all of the devices that belong to the disk group. This setting is useful if some of the disks in a normal or high redundancy disk group became unavailable while the disk group was dismounted. When MOUNT FORCE succeeds, Oracle
ASM takes the missing disks offline.
If Oracle ASM discovers all of the disks in the disk group, then MOUNT FORCE fails. Therefore, use the MOUNT FORCE setting only if some disks are unavailable. Otherwise, use NOFORCE.
In normal- and high-redundancy disk groups, disks from one failure group can be unavailable and MOUNT FORCE will succeed. Also in high-redundancy disk groups, two disks in two different failure groups can be unavailable and MOUNT FORCE will succeed. Any other combination of unavailable disks causes the operation to fail, because Oracle ASM cannot guarantee that a valid copy of all user data or metadata exists on the available disks.

NEW QUESTION 8

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components
WHERE current_size!=0; What do you infer from this? Exhibit:

• A. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
• B. The database instance is running with manual shared memory management.
• C. The database instance is running with manual PGA management.
• D. The database instance has the MEMORY_TARGET value set to a nonzero value.

Answer: D

NEW QUESTION 9

Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

• A. configuring control file autobackup to be ON
• B. backing up data filed only and not the archived redo log files
• C. running the recovery catalog database in NOARCHIVELOG mode.
• D. setting the retention policy to a REDUNDANCY value greater than 1
• E. backing up the recovery catalog to the same disk as that of the target database

Answer: AD

Explanation:
Refer to here.
Configuring the Recovery Catalog Database
When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog.
Decide which database you will use to install the recovery catalog schema, and also how you will back up this database. Also, decide whether to operate the catalog database in ARCHIVELOG mode, which is recommended.
Note: Do not use the target database to be backed up as the database for the recovery catalog. The recovery catalog must be protected if the target database is lost.

NEW QUESTION 10

You have the following requirements in relation to the detection of block corruption for your database instance:
✑ Check for logical self-consistency of data blocks when modified in memory.
✑ Checksums are calculated before and after the block change.
✑ Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?

• A. Set the DB_SECUREFILE parameter to PERMITTED.
• B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
• C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
• D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.

Answer: B

Explanation:

C:\Users\albo\Desktop\1-1.jpg Values:
OFF
When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or
DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.
DATA_ONLY
✑ DB_BLOCK_CHECKING will be set to MEDIUM.
✑ DB_LOST_WRITE_PROTECT will be set to TYPICAL.
✑ DB_BLOCK_CHECKSUM will be set to FULL.
DATA_AND_INDEX
DB_BLOCK_CHECKING will be set to FULL. DB_LOST_WRITE_PROTECT will be set to TYPICAL. DB_BLOCK_CHECKSUM will be set to FULL.

C:\Users\albo\Desktop\1-1.jpg Values:
OFF or FALSE
No block checking is performed for blocks in user tablespaces. However, semantic block checking for SYSTEM tablespace blocks is always turned on.
LOW
Basic block header checks are performed after block contents change in memory (for example, after UPDATE or INSERT statements, on-disk reads, or inter-instance block transfers in Oracle RAC).
MEDIUM
All LOW checks and full semantic checks are performed for all objects except indexes (whose contents can be reconstructed by a drop+rebuild on encountering a corruption).
FULL or TRUE
All LOW and MEDIUM checks and full semantic checks are performed for all objects.

NEW QUESTION 11

Which of the following parameters defines the location where Oracle should create archived redo logs?

• A. LOG_ARCHIVE_1
• B. LOG_DESTINATION_1
• C. LOG_ARCHIVED_DESTINATION_1
• D. LOG_ARCHIVE_DEST_1
• E. LOG_ARCHIVE_SOURCE_1

Answer: D

NEW QUESTION 12

Which three statements are true about persistent configuration? (Choose three.)

• A. A user cannot set privileges on the persistent lightweight jobs
• B. Persistent lightweight jobs generate a large amount of metadata
• C. It is possible to create fully self-contained persistent lightweight jobs
• D. The use of a template is mandatory to create persistent lightweight jobs
• E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

Answer: ADE

NEW QUESTION 13

What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

• A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
• B. CONFIGURE DEFAULT DEVICE TYPE TO TAPE
• C. CONFIGURE DEFAULT DEVICE TYPE TO SBT
• D. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE

Answer: C

Explanation:
SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike.

NEW QUESTION 14

Observe the structure of the table employees: The table contains 8475 records.

One of the employees wants to know the names of all employees of the company. For this, he fires the following query:
SELECT * FROM EMPLOYEES ORDER BY emp_fname;
Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.
Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?

• A. Rollback segment
• B. Temporary segment
• C. Data segment
• D. Index segment

Answer: B

NEW QUESTION 15

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

• A. fixed tables
• B. heap tables
• C. external tables
• D. temporary tables
• E. Index-Organized Tables (IOTs)
• F. views

Answer: BE

NEW QUESTION 16

After executing the command
ALTER DISKGROUP diskgroup2 DROP DISK dg2a;
You issue the following command from the ASM instance: SELECT group_number, COUNT(*) FROM v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?

• A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
• B. The drop disk operation is complete and you can run the undrop disks command if needed.
• C. The drop disk operation is complete and you cannot run the undrop disks command.
• D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
• E. None of the above is true.

Answer: C

Explanation:
Once the DROP DISK operation is completed, you CANNOT run the UNDROP DISKS
command any more.

NEW QUESTION 17

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

• A. An ASM instance mounts an ASM control file
• B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
• C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
• D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Answer: CD

NEW QUESTION 18

In your test database:
✑ You are using Recovery Manager (RMAN) to perform incremental backups of your test database
✑ The test database is running in NOARCHIVELOG mode
✑ One of the data files is corrupted
✑ All online redo log files are lost because of a media failure
Which option must you consider in this scenario?

• A. Configuring the database in ARCHVIELOG mode and then using incremental backup to recover the database
• B. Using incremental backup to recover the damaged data file and then manually creating the online redo log files
• C. Creating a new test database because the database is not recoverable due to the fact that the database is configured in NOARCHIVELOG mode
• D. Using incremental backups to recover the database by using the RECOVER DATABASE NOREDO command and then using the RESETLOGS option to open the database.

Answer: D

Explanation:
Example 3-6 Recovering a NOARCHIVELOG Database
You can perform limited recovery of changes to a database running in NOARCHIVELOG mode by applying incremental backups. The incremental backups must be consistent, like all backups of a database run in NOARCHIVELOG mode, so you cannot back up the database when it is open.
Assume that you run database prod in NOARCHIVELOG mode with a recovery catalog.
You shut down the database consistently and make a level 0 backup of database prod to tape on Sunday afternoon. You shut down the database consistently and make a level 1 differential incremental backup to tape at 3:00 a.m. on Wednesday and Friday.
On Saturday, a media failure destroys half the data files and the online redo logs. Because the online logs are lost, you must specify the NOREDO option in the RECOVER command. Otherwise, RMAN searches for the redo logs after applying the Friday incremental backup and issues an error message when it does not find them.
After connecting RMAN to prod and the catalog database, recover as follows: STARTUP FORCE NOMOUNT;
RESTORE CONTROLFILE; # restore control file from consistent backup
ALTER DATABASE MOUNT;
RESTORE DATABASE; # restore data files from consistent backup
RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost
ALTER DATABASE OPEN RESETLOGS;
The recovered database reflects only changes up through the time of the Friday incremental backup. Because there are no archived redo log files, there is no way to recover changes made after the incremental backup.

NEW QUESTION 19

Which commands are used for RMAN database recovery? (Choose all that apply.)

• A. restore
• B. repair
• C. copy
• D. recover
• E. replace

Answer: AD

NEW QUESTION 20

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)

• A. Database datafiles
• B. Control files
• C. Archived redo logs
• D. Online redo logs
• E. Flashback logs

Answer: ABD

Explanation:
Recovering a Database in NOARCHIVELOG Mode
1. Restore all the data files and control files
2. (optional) if the media failure is not fixed, you need to modify the control file to the new location of data files and redo log files.
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RENAME FILE '<damaged file, datafile, redo log>' TO '<new location>';
3. SQL> RECOVER DATABASE UNTIL CANCEL Because online redo logs are never backed up, you cannot restore them with the data files and control files. To enable the
database to reset the online redo logs, you must first mimic incomplete recovery:
4. SQL> ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 21

You want to use the automatic management of backup and recovery operations features for your database.
Which configuration must you set?

• A. Enable the flash recovery area and specify it as the archived redo log destination.
• B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
• C. Enable the flash recovery area but do not specify it as the archived redo log destination.
• D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

Answer: A

NEW QUESTION 22

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).
Which two are the prerequisites to perform this operation? (Choose two)

• A. You must configure block change tracking file
• B. You must have first level 1 backups for RMAN to restore blocks
• C. You must ensure that the SALES database is mounted or open
• D. You must have full or level 0 backups for RMAN to restore blocks
• E. You must take the tools01.dbf data file offline before you start a block media recovery

Answer: CD

Explanation:
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 23

In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the
database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA Which DB01 is the net service name.
Which authentication method would be used first?

• A. authentication by password file
• B. authentication by using certificates over SSL
• C. authentication by using the Oracle Internet Directory
• D. authentication by using the local OS of the database server

Answer: A

NEW QUESTION 24

Which of the following most closely represents an image copy?

• A. Unix cp command of a file
• B. Bit-by-bit copy of a file
• C. Windows COPY command of a file
• D. All of the above

Answer: D

NEW QUESTION 25
......