NEW QUESTION 1
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

• A. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
• B. The MTTR advisor is enabled only if the value is greater than the default value.
• C. Automatic checkpoint tuning is enabled.
• D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Answer: AB

NEW QUESTION 2
A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

• A. image copy backup by using RMAN
• B. multisection image copy backup by using RMAN
• C. multisection parallel backup by using RMAN
• D. cold backup after taking the tablespace offline
• E. cold backup after placing the tablespace in backup mode

Answer: C

NEW QUESTION 3
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions? Choose the best answer.

• A. when recovering data that was lost after a DDL operation modified the structure of a table
• B. when recovering dropped tables that are present in the recyclebin
• C. when recovering a table that has been logically corrupted
• D. when recovering a table to a point in time
• E. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo.

Answer: A

NEW QUESTION 4
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

• A. Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.
• B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.
• C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
• D. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
• E. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

Answer: DE

NEW QUESTION 5
ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

• A. The data is decrypted during SORT and JOIN operations.
• B. The data remains encrypted when it is read into memory.
• C. The data remains encrypted when it is stored in the redo logs
• D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Answer: C

NEW QUESTION 6
You plan to migrate a production database to Real Application Clusters (RAC).
You created a test RAC database by cloning the production database and plan to replay a workload, captured from the production database.
Examine these steps:
1) Preprocess the captured workload.
2) Restart the database instance in RESTRICTED mode.
3) Set up Replay Clients.
4) Restore the test database to the point when the capture started on the production database.
5) Remap connections.
Which is the correct sequence of required steps?

• A. 1, 4, 3, 5
• B. 1, 4, 5, 3
• C. 2, 1, 5, 3, 4
• D. 1, 2, 4, 5, 3

Answer: A

NEW QUESTION 7
You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

• A. MAXSETSIZE TO 2;
• B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
• C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
• D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Answer: D

Explanation: Configuring Backup Duplexing You can use the CONFIGURE ... BACKUP COPIES command to specify how many copies of each backup piece should be created on the specified device type for the
specified type of file. This type of backup is known as a duplexed backup set. The CONFIGURE settings for duplexing only affect backups of datafiles, control files, and archived logs into backup
sets, and do not affect image copies. NOT A The CONFIGURE MAXSETSIZE command limits the size of backup sets created on a channel. This CONFIGURE setting applies to any channel, whether manually allocated or configured, when the BACKUP command is used to create backup sets. The default value
is given in bytes and is rounded down to the lowest kilobyte value. Reference: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137

NEW QUESTION 8
You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.

• A. 1, 3, 5, 4, 2, and 7
• B. 1, 2, 4, 6, 5, 3, and 7
• C. 1, 2,4, and 7
• D. 2, 4, 5, 6, and 7

Answer: A

Explanation: Reference: http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp- 12c-1896123.pdf

NEW QUESTION 9
Which three statements are true about the keystore storage framework for transparent data encryption?

• A. It facilitates and helps to enforce keystore backup requirements.
• B. It handles encrypted data without modifying applications.
• C. It enables a keystore to be stored only in a file on a file system.
• D. It enables separation of duties between the database administrator and the security administrator.
• E. It transparently decrypts data for the database users and applications that access this data.
• F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Answer: ADF

Explanation: References: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework)

NEW QUESTION 10
Identify two scenarios in which the RMAN crosscheck command can be used.

• A. when checking for backups that are not required as per the retention policy
• B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
• C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
• D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
• E. when listing backups that are required for recovery operations

Answer: BC

NEW QUESTION 11
You want to back up a database such that only formatted blocks are backed up. Which statement is
true about this backup operation?

• A. The backup must be performed in mount state.
• B. The tablespace must be taken offline.
• C. All files must be backed up as backup sets.
• D. The database must be backed up as an image cop

Answer: A

Explanation: If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG459

NEW QUESTION 12
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive. Which two actions would you take for tape streaming to happen during the backup?

• A. Configure backup optimization.
• B. Configure the channel to increase maxopenfiles.
• C. Configure a backup policy by using incremental backups.
• D. Configure the channel to increase capacity with the rate parameter.
• E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
• F. Configure large_pool, if not done alread
• G. Alternatively, you can increase the size of
• H. LARGE_POOL.

Answer: BE

Explanation: Allocation of Tape Buffers If you back up to or restore from an SBT device, then by default the database allocates four buffers for each channel for the tape writers. The size of the tape I/O buffers is platform-dependent. You can change this value with the PARMS and BLKSIZE parameters of the
ALLOCATE CHANNEL or CONFIGURE CHANNEL command. You can improve backup performance by adjusting the level of multiplexing, which is number of input files simultaneously read and then
written into the same RMAN backup piece. The level of multiplexing is the minimum of the MAXOPENFILES setting on the channel and the number of input files placed in each backup set. The following table makes recommendations for adjusting the level of multiplexing.

NEW QUESTION 13
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

• A. Corrupted blocks, if any, are repaired in the backup created.
• B. Only those data files that have corrupted blocks are backed up.
• C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
• D. The database is checked for physically corrupt blocks and any corrupted blocks are repaire

Answer: D

Explanation: Reference: http://www.dba-oracle.com/t_rman_36_validate_backup.htm

NEW QUESTION 14
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options. Identify the required steps in the correct order.
Choose the best answer.

• A. 1, 5, 4, 7, and 6
• B. 3, 2, 5, 1, 4, and 7
• C. 2, 5, 1, 4, 7, and 6
• D. 2, 1, 3, 5, 7, and 6

Answer: C

NEW QUESTION 15
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
$> impdp <user_name> full=Y network_link=hrdb_test transportable=always transport_datafiles=
‘/u01/app/oracle/oradata/hrdb/sales01.dbf’, ‘/u01/app/oracle/oradata/hrdb/cust01.dbf’, ‘/u01/app/oracle/oradata/hrdb/emp01.dbf’, version=12 logfile=import.log
Which three are prerequisites for successful execution of the command?

• A. The impdp operation must be performed by the same user that performed the expdp operation.
• B. The path of data files on the target database must be the same as that on the source database.
• C. The export dump file must be created before starting the import on the target database.
• D. All the user defined tablespaces must be in read-only mode on the source database.
• E. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.
• F. The source and target databases must be running on the same platform with the same endiannes

Answer: ACE

NEW QUESTION 16
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?

• A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
• B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
• C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
• D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
• E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Answer: CE

Explanation: https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

NEW QUESTION 17
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.