NEW QUESTION 1
Which two statements are true about scheduling operations in a pluggable database (PDB)?

• A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
• B. A job defined in a PDB runs only if that PDB is open.
• C. Scheduler attribute setting is performed only at the CDB level.
• D. Scheduler objects created by users can be exported or imported using Data Pump.
• E. Scheduler jobs for a PDB can be created only by common user

Answer: BD

Explanation: In general, all scheduler objects created by the user can be exported/imported into the PDB using data pump. Predefined scheduler objects will not get exported and that means that any changes made to these objects by the user will have to be made once again after the database has been imported into the pluggable database. However, this is how import/export works currently. A job defined in a PDB will run only if a PDB is open.

NEW QUESTION 2
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE_SID = [oracle] ? cdb1
The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
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 promp

Answer: C

NEW QUESTION 3
Evaluate these statements: CREATE TABLE purchase_orders (po_idNUMBER(4), po_dateTIMESTAMP, supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITIONBYRANGE(po_date)
(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));
CREATETABLEpurchase_order_items (po_idNUM3ER(4)NOTNULL,
product_idNUMBER(6)NOTNULL, unit_prlceNUMBER(8,2),
quantity NUMBER(8), CONSTRAINTpo_items_f k
FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id)) PARTITIONBYREFERENCE(po_items_fk);
Which two statements are true?

• A. Partitions of purchase_order_items are assigned unique names based on a sequence.
• B. The purchase_orders and purchase_order_items tables are created with four partitioneach.
• C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
• D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
• E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Answer: BC

Explanation: The following example creates a parent table orders which is range-partitioned on order_date. The reference-partitioned child table order_items is created with four partitions, Q1_2005, Q2_2005, Q3_2005, and Q4_2005, where each partition contains the order_items rows corresponding to orders in the respective parent partition. Partitions of a reference-partitioned table will collocate with the corresponding partition of the parent table, if no explicit tablespace is specified for the reference-partitioned table’s partition. The partitions of a reference-partitioned table can be named. If a partition is not explicitly named, then it will inherit its name from the corresponding partition in
the parent table. http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC

NEW QUESTION 4
Which three statements are true about Consolidated Database Replay?

• A. The workload capture and replay systems must have the same operating system (OS).
• B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
• C. A subset of the captured workload can be replayed.
• D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
• E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer: BCE

Explanation: https://docs.oracle.com/database/121/RATUG/GUID-36DE5567-5A64-493B-A154- 6581C678FC8A.htm#RATUG105
These capture files are platform independent and can be transported to another system. https://docs.oracle.com/database/121/RATUG/GUID-42958859-005D-4B93-9DD3- 79807968EA9E.htm#RATUG4199
You can use Consolidated Database Replay to combine the captured workloads from the three applications and replay them concurrently on PDBs. https://docs.oracle.com/database/121/RATUG/GUID-C4DC0795-74B2-456D-AA0AB4F7F45C81F8. htm
https://docs.oracle.com/database/121/RATUG/GUID-B1AEA82F-60E5-43CE-BB12- C6D72232886A.htm

NEW QUESTION 5
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges. You then execute the commands:
SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB assysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?

• A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
• B. B_admin can create and select any table in both the root container and kr_pdb.
• C. c##admin can create and select any table in the root container and all the PDBs.
• D. B_admin can create and select any table only in hr_pdb.
• E. The grant c=»role1 to b_admin command returns an error because container should be set to AL

Answer: CD

NEW QUESTION 6
In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:
SQL> GRANT create tablespace to C##A_ADMIN; Which statement is true? (Choose the best answer.)

• A. The command fails because the CONTAINER clause is not used.
• B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
• C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the plugging databases (PDBs).
• D. The command fails because system privileges cannot be granted to a common use

Answer: B

NEW QUESTION 7
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user: SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user? Choose the best answer.

• A. It is created in all the PDBs with CREATE SESSION privilege.
• B. It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.
• C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
• D. It is created only in CDB$ROOT and has the CREATE SESSION privileg

Answer: D

NEW QUESTION 8
RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE
NOFILENAMECHECK PASSWORD FILE SPFILE;
Which two statements are true about the execution of the DUPLICATE command?

• A. All archive redo log files are automatically copied to the duplicate database.
• B. The duplicate database has the same directory structure as the source database.
• C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
• D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.
• E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

Answer: AE

NEW QUESTION 9
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(‘SH’, 'CUSTOMERS')from dual statement.
2. Execute the dbms_stats.seed_col_usage (null,‘SH’,500) procedure. 3.Execute the required queries on the customers table.
4.Issue the select dbms_stats.reportwcol_usage(‘SH’, 'customers') from dual statement. Identify the correct sequence of steps.

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

Answer: B

Explanation: Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column
groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the
DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for
each column group whenever statistics are gathered on the table. Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statistics
Here are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.
2 – Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute (“exec”) statement, Oracle extended statistics are created via a select statement.

NEW QUESTION 10
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

• A. Block change tracking must be enabled before executing this command.
• B. The database must be running in archivelog mode for the successful execution of this command.
• C. A complete database backup must exist before executing this command.
• D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
• E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Answer: D

NEW QUESTION 11
Which three RMAN persistent settings can be set for a database?

• A. backup retention policy
• B. default backup device type
• C. default section size for backups
• D. default destinations for backups
• E. multiple backup device types for a single backup

Answer: ABD

Explanation: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1019739 To simplify
ongoing use of RMAN, you can set several persistent configuration settings for each target database. These settings control many aspects of RMAN behavior. For example, you can configure the backup retention policy, default destinations for backups, default backup device type, and so on. You can use the SHOW and CONFIGURE commands to view and change RMAN configurations.

NEW QUESTION 12
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

• A. Tables or table partitions can be recovered by using an auxiliary instance only.
• B. Tables or table partitions with a foreign key cannot be recovered.
• C. Tables or table partitions can be recovered only when the database is in mount state.
• D. Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
• E. Tables with not null constraints cannot be recovere

Answer: AD

Explanation: References:
https://www.pythian.com/blog/table-recovery-with-rman-in-database-12c/ https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695

NEW QUESTION 13
When is the UNDO_RETENTION parameter value ignored by a transaction?

• A. when the data file of the undo tablespace is autoextensible
• B. when there are multiple undotablespaces available in a database
• C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
• D. when Flashback Database is enabled

Answer: C

Explanation: References:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention, see the bullets)

NEW QUESTION 14
You set the following parameters in the parameter file and restart the database instance: MEMORY_MAX_TARGET=0
MEMORY TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true?

• A. The memory_max_target parameter is automatically set to 500 MB.
• B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
• C. The value of the memory_max_target parameter remains zero for the database instance.
• D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
• E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Answer: AD

NEW QUESTION 15
Which two statements are true about RMAN duplexed backups? (Choose two.)

• A. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
• B. It is only supported for backups to tape via media management interface.
• C. It is not supported for image copies.
• D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
• E. Duplex backups can contain only data files and control files.

Answer: CD

NEW QUESTION 16
Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

• A. Only one nested subplan is allowed per parent plan
• B. The plans can be nested up to four levels.
• C. Nested plans only control resources used by recursive SQL
• D. Nested plans control only the degree of parallelism and I/O requests
• E. Each nested plan gets a proportion of the CPU resources assigned to its parent grou

Answer: E

NEW QUESTION 17
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

• A. by using the RMAN switch command to set the new location for the data files
• B. by using the RMAN duplicate command with no filename check to recover the database to the new host
• C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
• D. by creating a new database in the new host, and then using the RMAN recover command

Answer: B

Explanation: Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#CHDGFABD