NEW QUESTION 1
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 2
Which three statements are true about common roles? (Choose three.)

• A. A common role can be granted only to a common user.
• B. Only system privileges can be granted to a common role in a container database (CDB).
• C. Object privileges can be granted to a common role in a pluggable database (PDB).
• D. A common user that is granted a common role can grant the role to other common and local users in a PDB.
• E. A common role cannot be created by a local user.

Answer: CDE

Explanation: C: Commonly granted privileges that have been made to the common role apply in the root and all PDBs to which the grantor can connect, including PDBs that may be added later on.
D: Common users can both create and grant common roles to other common and local users. E: Local users cannot create common roles.
Note: A common role is a role that is created in the root; a local role is created in a PDB.

NEW QUESTION 3
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 4
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 5
Consider the following scenario for your database: Backup optimization is enabled in RMAN.
The recovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1, 2013. The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk. Which statement is true about the backup of the tools tablespace?

• A. The RMAN backup fails because the tools tablespace is read-only.
• B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
• C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
• D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Answer: D

NEW QUESTION 6
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

• A. The minimum size for the standard buffer cache is 100 MB.
• B. The maximum size for the standard buffer cache is 100 MB.
• C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
• D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
• E. The minimum size for all buffer caches is 100 MB.

Answer: A

NEW QUESTION 7
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base is shared across multiple instances.
• B. The ADR base keeps all diagnostic information in binary format.
• C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
• D. The ADR can be used for problem diagnosis even when the database instance is down.
• E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Answer: AD

NEW QUESTION 8
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

• A. All data files belonging to PDB2_1 are backed up and all archive log files are deleted.
• B. All data files belonging to PDB2_1 are backed up along with the archive log files.
• C. Only the data files belonging to pdb2_1 are backed up.
• D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Answer: B

NEW QUESTION 9
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

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

Answer: D

NEW QUESTION 10
You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?

• A. The event parameter was not set.
• B. The sql_trace parameter is set to false.
• C. Enterprise Manager was not used.
• D. The statistics_level parameter is set to basic.
• E. The timed_statistics parameter is set to false.

Answer: D

NEW QUESTION 11
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH; SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines= TRUE SCOPE = BOTH; SQL> CONN sys/oracle _4U@cdbl AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baseline=TRUE SCOPE=BOTH; Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?

• A. It gives an error because it cannot be set for the root database.
• B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
• C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
• D. It is set to TRUE for the root database and all the PDBs, but is effective only when the CDB is restarted and the PDBs are reopened.

Answer: B

NEW QUESTION 12
Which three statements are true about the SQL*Loader utility? (Choose three.)

• A. It can be used to load data from multiple external files into multiple tables.
• B. It can be used to extract and reorganize data from external files, and then load it into a table.
• C. It can be used to load data from external files using direct path only.
• D. It can be used to create tables using data that is stored in external files.
• E. It can be used to generate unique sequential values in specified columns while loading data.

Answer: ABE

NEW QUESTION 13
Which two statements are true about roles in multitenant container databases (CDBs)? (Choose two.)

• A. Local roles can be granted to local and common users.
• B. A common role can be granted only to a common user.
• C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
• D. A common role can be granted only system privileges.
• E. The root container can have both local and common roles.
• F. A local role can be assigned to a common role in a PDB.

Answer: AF

NEW QUESTION 14
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 15
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges
granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

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

Answer: B

Explanation: 1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges’ lists.
4. Revoke the unused privileges.

NEW QUESTION 16
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 17
Which parameter must be set to which value to implement automatic PGA memory management?

• A. Set memory_target to zero.
• B. Set STATISTICS_LEVEL to BASIC.
• C. Set pga_aggregate_target to a nonzero value.
• D. Set pga_aggregate_target and sga_target to the same value.
• E. Set sgajtarget to zero.

Answer: C

NEW QUESTION 18
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 19
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