NEW QUESTION 1
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)) PARTITION BY RANGE(po_date)
(PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mm-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-mm-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-mm-yyyy')));
CREATE TABLE purchase_order_items (po_idNUM3ER(4)NOT NULL,
product_idNUMBER(6)NOT NULL, unit_price NUMBER(8,2),
quantity NUMBER(8), CONSTRAINT po_items_f k
FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk);
Which two statements are true? (Choose two.)

• 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 partition each.
• 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

NEW QUESTION 2

Which three statements are true about Consolidated Database Replay? (Choose three.)

• 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

NEW QUESTION 3

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1. Restore an autobackup of the server parameter file.
2. Restore the control file.
3. Start up the database instance in NOMOUNT state.
4. Mount the database.
5. Restore the data files.
6. Open the database with the RESETLOGS option.
7. Recover the data files.
8. Set DBID for the database.
Identify the required steps in the correct order.

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

Answer: B

NEW QUESTION 4

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

• A. The MTTR advisor is enabled only if the value is greater than the default value.
• B. Automatic checkpoint tuning is enabled.
• C. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
• 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: AC

Explanation:
The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected "mean time to recover" (MTTR), which is the expected amount of time Oracle takes to perform crash or instance recovery for a single instance.
To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero value. If FAST_START_MTTR_TARGET is not specified, then MTTR advisory will be OFF.
When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL. Note: The default value is 0. Range of values is 0 to 3600 seconds.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058 https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

NEW QUESTION 5

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors: SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
Why did the instance fail to start?

• A. because pga_aggregate_target is not set
• B. because statistics_level is set to basic
• C. because memory_target and memory_max_target cannot be equal
• D. because sga_target and memory_target are both set

Answer: B

NEW QUESTION 6

For which three pieces of information can you use the RMAN LIST command? (Choose three.)

• A. stored scripts in the recovery catalog
• B. available archived redo log files
• C. backup sets and image copies that are obsolete
• D. backups of tablespaces
• E. backups that are marked obsolete according to the current retention policy

Answer: ABD

NEW QUESTION 7

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 8

Which three statements are true about compression of backup sets? (Choose three.)

• A. Compressed backups can only be written to media.
• B. Binary compression creates performance overhead during a backup operation.
• C. Unused blocks below the high-water mark are not backed up.
• D. Compressed backups cannot have section size defined during a backup operation.
• E. It works only for locally managed tablespaces.

Answer: BCE

NEW QUESTION 9

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE; SHUTDOWN IMMEDIATE
You then restart the instance and get an error: STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

• A. because the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command
• B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command
• C. because the threaded architecture requires authentication using a password file before issuing a startup command
• D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
• E. because the threaded architecture requires restarting the listener before issuing a startup command

Answer: C

NEW QUESTION 10

Examine the parameters for your database instance: NAME TYPE VALUE
------------------------------------------------
optimizer_adaptive_reporting_only boolean FALSE optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2
optimizer_features_enable string 12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback? (Choose three.)

• A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• B. The optimizer can re optimize a query only once using cardinality feedback.
• C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Answer: ACE

NEW QUESTION 11

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

NEW QUESTION 12

Which three statements are true about Oracle Secure Backup (OSB)? (Choose three.)

• A. It can encrypt client data written to tape.
• B. It can be used to take image copy backups to tape.
• C. It can be used to manage tape backup and restore operations for multiple databases.
• D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
• E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

Answer: ACE

NEW QUESTION 13

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter: DB_FLASH_CACHE_FILE= ‘ /dev/f lash_device_1‘,‘ /dev/f lash_device_2‘ How should the D3_flash_cache_size be configured to use both devices?

• A. Set DB_FLASH_CACHE_SIZE=64G.
• B. Set D3_FLASH_CACHE_SIZE=64G, 64G.
• C. Set D3_FLASK_CACKE_SI2E=128G.
• D. db_flash_cache_SI2E is automatically configured by the instance at startup.

Answer: B

Explanation:
* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database Smart Flash Cache” area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by “DB Smart Flash Cache”
/dev/sda – size 32G
/dev/sdb – size 32G
/dev/sdc – size 64G
New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file|device and compute the average latency

NEW QUESTION 14

RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

What is the outcome?

• A. RMAN uses the push method to transfer image copies.
• B. RMAN uses the push method to transfer backup sets.
• C. RMAN uses the pull method to restore files using backup sets.
• D. RMAN uses the pull method to restore files using image copies.

Answer: C

Explanation:
When RMAN performs active database duplication using backup sets, a connection is established with the source database and the auxiliary database. The auxiliary database then connects to the source database through Oracle Net Services and retrieves the required database files from the source database. This method of active database duplication is also to as the pull-based method.
Example:
DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE
PASSWORDFILE SPFILE NOFILENAMECHECK;

NEW QUESTION 15

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)

• A. The COMPATIBLE initialization parameter is set to 10.2 or higher.
• B. There are no guaranteed restore points defined for the database.
• C. The default device for the backup must be set to disk.
• D. The tablespaces are locally managed.
• E. The fast recovery area is less than 50 percent free.

Answer: ABD

NEW QUESTION 16

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

• A. You cannot export data from a remote database.
• B. You can rename tables during import.
• C. You can overwrite existing dump files during export.
• D. You can compress data but not metadata during export.

Answer: BC

NEW QUESTION 17

Your database supports an OLTP workload. Examine the output of the query:

To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to 30.
What is the effect of this setting on the database?

• A. Automatic checkpoint tuning is disabled.
• B. The frequency of log switches is increased.
• C. The overhead on database performance is increased because of frequent writes to disk.
• D. The MTTR advisor is disabled.

Answer: C

NEW QUESTION 18

Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)

• A. A window specifies a resource plan that will be activated when that window becomes active.
• B. A window specifies a job class that will be activated when that window becomes active.
• C. A job class specifies a window that will be open when that job class becomes active.
• D. A window in association with a resource plan controls a job class allocation.
• E. A window in association with a job class controls a resource allocation.

Answer: AE

NEW QUESTION 19

Examine the command used to perform an incremental level-0 backup: RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command: RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation? (Choose two.)

• A. The block change tracking data is used only from the next incremental backup.
• B. The incremental level 1 backup fails because a block change tracking file is created after the level 0 backup.
• C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
• D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
• E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Answer: CE

NEW QUESTION 20

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 21

user_data is a non-encrypted tablespace containing tables with data. You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)

• A. Use Data Pump.
• B. Use ALTERTABL
• C. . .MOVE
• D. Use CREATE TABLE AS SELECT
• E. Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space
• F. Use altertablespace to encrypt the tablespace.

Answer: ABC

NEW QUESTION 22

Which two statements are true about making RMAN image copies of a database? (Choose two.)

• A. The can only be written to disk.
• B. The can be made only when the database is running in NOARCHIVELOG mode.
• C. They can be made only when the database is in MOUNT state.
• D. They consist of all used an unused blocks in the data files.
• E. They can be made only when the database is running in ARCHIVELOG mode.

Answer: AD

Explanation:
An image copy can be written only to disk.
An image copy is the same as datafiles. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks.
References:
http://www.dba-oracle.com/t_rman_10_image_copies.htm

NEW QUESTION 23

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 24

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement is true about the c##connect role?

• A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
• B. It is granted to the c##admin user only in the CDB.
• C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
• D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Answer: D

NEW QUESTION 25

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?

• A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
• B. It fails and reports an error because the container=all clause is not used.
• C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
• D. It fails and reports an error because the container=current clause is not used.

Answer: B

NEW QUESTION 26
......