NEW QUESTION 1
Which three statements are true about persistent lightweight jobs? (Choose three.)

• A. A user cannot set privileges on them.
• B. They generate large amounts of metadata.
• C. They may be created as fully self-contained jobs.
• D. They must reference an existing Scheduler Program.
• E. They are useful when users need to create a large number of jobs quickly.

Answer: ADE

NEW QUESTION 2
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps.

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

Answer: B

NEW QUESTION 3
In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns. Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

• A. heap table with a primary key index
• B. external table
• C. hash clustered table
• D. global temporary table
• E. index clustered table

Answer: E

NEW QUESTION 4
Which two statements are true regarding SecureFile lobs? (Choose two.)

• A. The amount of undo retained is user controlled.
• B. They can be used only for nonpartitioned tables.
• C. Fragmentation is minimized by using variable-sized chunks.
• D. They support random reads and writes of encrypted LOB data.

Answer: CD

NEW QUESTION 5
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

• A. It can be executed only from CDB$ROOT.
• B. It rolls back any pending transactions in the container from which it is executed.
• C. It will not fire login triggers for the specified container.
• D. It cannot be used to connect to PDB$SEED.
• E. It cannot be used to connect to CDB$ROOT from a pluggable database (PDB).

Answer: D

Explanation: The current container can be the root or a PDB.
The current container can be CDB$ROOT (root) only for common users. The current container can be a particular PDB for both common users and local users.
References: https://docs.oracle.com/database/121/ADMIN/cdb_admin.htm

NEW QUESTION 6
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 7
Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true? (Choose two.)

• A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
• B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
• C. The tablespace specifications of pdb2 are the same as pdb1.
• D. All database objects belonging to common users in PDB1 are cloned in PDB2.
• E. pdb2 is created with its own private undo and temp tablespaces.

Answer: AC

NEW QUESTION 8
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1. Create media families for data files and archived redo log files.
2. Configure database backup storage selectors or RMAN media management parameters.
3. Create an OSB user preauthorized for RMAN operations.
4. Configure RMAN Access to the OSB SBT.
5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

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

Answer: C

NEW QUESTION 9
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

• A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
• B. In a PDB plan, subplans may be used with up to eight consumer groups.
• C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
• D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE

Explanation: A: ACDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.
Resource Manager allocates the resources in two steps:
E: A PDB resource plan allocates resource among the consumer groups within a PDB. References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

NEW QUESTION 10
You are connected to a recovery catalog and target database. You execute the command: RMAN> CATALOG START WITH ‘/disk1/backups’;
Which statement is true?

• A. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
• B. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.
• C. It lists all data file copies, backup pieces, and achieved logs cataloged in the recovery catalog in the/disk1/backups directory and its subdirectories.
• D. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

Answer: D

Explanation: If you have data file copies, backup pieces, or archived logs on disk, then you can catalog them in the recovery catalog with the CATALOG command.
The following command catalogs all files in all of these directories, because /disk1/backups is a prefix for the paths for all of these directories:
CATALOG START WITH '/disk1/backups';
To catalog only backups in the /disk1/backups directory, the correct command is as follows: CATALOG START WITH '/disk1/backups/';
References: https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm

NEW QUESTION 11
Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

• A. from the last complete checkpoint position
• B. from the beginning of the current redo log file until the instance failure
• C. from the last committed transaction
• D. from the beginning of the current redo log file to the checkpoint position
• E. from the most recent incremental checkpoint

Answer: E

NEW QUESTION 12
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

• A. RMAN preauthorization on the host
• B. OSB encryption for data in transport and on tape
• C. matching the OS user identity of the Oracle instance associated with the database username
• D. assigned to a class with rights to back up or restore Oracle database
• E. scheduling of the RMAN backup to occur automatically at user-defined intervals
• F. assigned to a class with rights to browse all directories and catalogs

Answer: ADF

Explanation: A: Performing Oracle database backups using RMAN requires RMAN user preauthorization within OSBD: The preauthorized Oracle Secure Backup user must also be assigned to an Oracle Secure Backup class
possessing the following rights:
access Oracle backups (set to owner, class, or all) perform Oracle backups and restores
F: The preauthorized Oracle Secure Backup user must be mapped to operating system privileges to access the files to be backed up or restored. the preauthorized Oracle Secure Backup user can perform RMAN operations only on the host where it has access to files.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM199

NEW QUESTION 13
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition: create table employees
(empno number, salary number, deptid number, name varchar2(100), period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

• A. The valid time columns employee_time_start and employee_time_end are automatically created.
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIODFOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is described.
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABC

Explanation: A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table’s definition in the case of which, the Period For clause would be creating them internally.

NEW QUESTION 14
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)

• A. switching the online redo log file
• B. backing up all data files as image copies and archive log files, and deleting those archive log files
• C. backing up only the used blocks in the data files
• D. backing up all used and unused blocks in the data files
• E. backing up all archived log files and marking them as obsolete

Answer: ABD

NEW QUESTION 15
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir
LOCATION (‘ordersl.dmp','orders2.dmp’,’orders3.dmp’,’lorders4.dmp')
) PARALLEL AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

• A. TYPE
• B. LOCATION
• C. PARALLEL
• D. DEFAULT DIRECTORY
• E. ORGANIZATION EXTERNAL

Answer: C

NEW QUESTION 16
Which two statements are true about Flashback Version Query? (Choose two.)

• A. The result of a query can be used as part of a DML statement.
• B. It can be used to create views.
• C. It can be used only if Flashback Data Archive is enabled for a table.
• D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
• E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer: DE

NEW QUESTION 17
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved Serial Execution performance
• D. Reduced physical I/O
• E. Reduced CPU utilization

Answer: BE

NEW QUESTION 18
Which two are prerequisites for performing Flashback Transaction? (Choose two.)

• A. A supplemental log must be enabled for the primary key.
• B. Undo retention guarantee must be configured for the database.
• C. Fast Recovery Area must be enabled for the database.
• D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• E. Row movement must be enabled.

Answer: AD

NEW QUESTION 19
Which three statements are true about the keystore storage framework for transparent data encryption? (Choose three.)

• 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