NEW QUESTION 1
Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

• A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
• B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
• C. A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB.
• D. Only a common user can create additional services for a PDB.
• E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

Answer: AC

NEW QUESTION 2
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

• A. ADBA can check specific tables with the DMU
• B. The database to be migrated must be opened read-only.
• C. The release of the database to be converted can be any release since 9.2.0.8.
• D. The DMU can report columns that are too long in the converted characterset
• E. The DMU can report columns that are not represented in the converted characterset

Answer: ADE

Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion. E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

NEW QUESTION 3
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

• A. Set the backup_tape_io_slaves parameter to true.
• B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
• C. Configure large pool if not already done.
• D. Remove the rate parameter, if specified, in the allocate channel command.
• E. Always use RMAN compression for tape backups rather than the compression provided by media manager.
• F. Always use synchronous I/O for the database.

Answer: BCD

NEW QUESTION 4
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

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

Answer: C

NEW QUESTION 5
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

• A. It succeeds and displays all the tablespaces that belong to the root database.
• B. It fails and returns an error because a connection is not made by using the SYSDBA privilege.
• C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
• D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Answer: C

NEW QUESTION 6
Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

• A. loss of a non-critical data file
• B. loss of a control file
• C. physical data block corruption
• D. logical data block corruption
• E. loss of an archived redo log file

Answer: BCE

NEW QUESTION 7
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database. Identify the required steps in the correct order.

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

Answer: D

Explanation: Step 1 (1): To copy tablespaces from one database to another using transportable tablespace, the source tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source database to target database (using any available methods like scp, sftp, rcp, etc).
Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of the tablespaces that needs to transported using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that needs to be transported, we need to copy the Export Dump file as well as all the datafiles belonging to the tablespaces to be transported to the target database server.
References:
http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/

NEW QUESTION 8
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)

• A. The current online redo log file is missing.
• B. A data file belonging to a noncritical tablespace is missing.
• C. All the control files are missing.
• D. The control file backup is older than the database backup.
• E. All the data files are missing.

Answer: CD

NEW QUESTION 9
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

• A. Database Resident Connection Pooling
• B. Oracle Suggested Backup Strategy
• C. Database Vault in ORACLE_HOME
• D. Non default block size tablespaces
• E. Configure Label Security

Answer: CE

NEW QUESTION 10
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed. Which backup strategy satisfies the requirements?

• A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Answer: A

NEW QUESTION 11
Identify two scenarios in which the RMAN CROSSCHECK command can be used. (Choose two.)

• 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: BE

NEW QUESTION 12
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.

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

Answer: C

Explanation: This example example is a dumpfile-based full transportable export/import operation. In this case the metadata from the source database is exported to a dump file, and both the dump file and the tablespace data files are transferred to a new system. The steps would be as follows:
* (1) Set user tablespaces in the source database to READ ONLY.
* (3) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (4) From the Oracle Database 11g Release 2 (11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VERSION=12 parameter is required only when exporting from an Oracle Database 11g Release 2 database.
* (5) Copy the tablespace data files from the source system to the destination system.
* (6) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.
References:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf, page 11

NEW QUESTION 13
Your database instance is started using an SPFILE. You are connected to CDB$ROOT, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the STATISTICS_LEVEL parameter? (Choose two.)

• A. It is immediately set to ALL in the SPFILE and the CDB instance.
• B. It is immediately set to ALL in only those pluggable databases (PDBs) where the value is set to TYPICAL.
• C. It is immediately set to ALL only for CDB$ROOT.
• D. It is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter is not set.
• E. It is set to ALL for all PDBs only in the SPFILE.

Answer: AB

NEW QUESTION 14
You are administering a multitenant container database (CDB) cdb1. Examine the command and its output:
SQL>show parameterfile NAME TYPE VALUE
-----------------------------------------------------------------------
db_create_file_dest string db_file_name_convert string
db_files integer 200
You verify that sufficient disk space is available and that no file currently exists in the ‘/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command: SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSER salesadm IDENTIFIED BY password; ROLES=(dba)
DEFAULTTABLESPACE sales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf’SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/', '/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB'; Which statement is true?

• A. SALESPDB is created and is in mount state.
• B. PDB creation fails because the db_file_name_convert parameter is not set in the CDB.
• C. SALESPDB is created and is in read/write mode.
• D. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

Answer: A

NEW QUESTION 15
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION 2 YEAR;
What is the outcome?

• A. An error is returned because the retention period cannot be reduced.
• B. All historical data older than two years, if any, is purged from the flashback archive FDA1.
• C. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.
• D. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Answer: B

NEW QUESTION 16
Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)

• A. All redo log files are opened.
• B. The root, the seed, and all the PDBs are opened in read-write mode.
• C. All the PDBs are opened in read-write mode.
• D. All the PDBs are in closed state.
• E. Only the root database is opened in read-write mode.

Answer: AE

NEW QUESTION 17
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

• A. It returns an error because there is no level 0 backup available for new data files.
• B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
• C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
• D. It performs an image copy backup of all data files including those that belong to the new tablespace.
• E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Answer: B

NEW QUESTION 18
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?

• A. The resulting backupset has backup pieces that cannot exceed 300 MB.
• B. RMAN uses multiplexing to perform the backup.
• C. RMAN always performs this type of backup in parallel.
• D. The backup succeeds only if the USERS tablespace is locally managed.
• E. The backup set size is limited to 300 MB.

Answer: A

NEW QUESTION 19
Which two statements are true when row-archival management is enabled? (Choose two.)

• A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
• B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• C. The row archival visibility session parameter defaults to all rows.
• D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Answer: BD