NEW QUESTION 1
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE
You then restart the instance and get an error: STARTUP
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?

• A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command
• B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus 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

Explanation: The first pitfall is, when you try to configure your database for such use. You need a connection which is authenticated trough the password file. Otherwise you will get are error similar to this. https://petesdbablog.wordpress.com/2013/07/09/12c-new-feature-multi-process-multi-threadedoracle/

NEW QUESTION 2
Examine the RMAN command: RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP
INCREMENTAL LEVEL = 0 (DATAFILE 1, 4, 5 CHANNEL c1)
(DATAFILE 2, 3, 9 CHANNEL c2)
(DATAFILE 6, 7, 8 CHANNEL c3)
SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
}
Which statement is true about the command? Choose the best answer.

• A. It uses multisection backup.
• B. It uses parallelization for the backup set.
• C. It uses asynchronous I/O for the backup.
• D. It creates compressed backup set

Answer: B

NEW QUESTION 3
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?

• 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 4
Examine the command and its output: SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
--------------------------------------------------------------------------------------------------------------
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true?

• A. It flashes back the employee table and all the constraints associated with the table.
• B. It automatically flashes back all the indexes on the employes table.
• C. It automatically flashes back any triggers defined on the table.
• D. It flashes back only the structure of the table and not the data.
• E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

Answer: BC

Explanation: A table and all of its dependent objects (indexes, LOB segments, nested tables, triggers, constraints and so on) go into the recycle bin together, when you drop the table. Likewise, when you perform Flashback Drop, the objects are generally all retrieved together. Trigger automatically flashbacked. http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1020594

NEW QUESTION 5
Identify three benefits of unified auditing.

• A. It helps to reduce disk space used to store an audit trail in a database.
• B. It guarantees zero-loss auditing.
• C. It reduces overhead on a database caused by auditing, by having a single audit trail.
• D. An audit trail cannot be modified because it is read-only.
• E. It automatically audits Recovery Manager (RMAN) event

Answer: CDE

NEW QUESTION 6
Examine the RMAN commands executed in your database: RMAN>CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command: RMAN> BACKUP DATABASE;
Which two statements are true about the command?

• A. It performs a log switch.
• B. It creates compressed backup sets by using binary compression by default.
• C. It backs up only the used blocks in data files.
• D. It backs up data files, the control file, and the server parameter file.
• E. It creates a backup of only the control file whenever the database undergoes a structural chang

Answer: CD

Explanation: C: RMAN backup sets automatically use unused block compression. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382
D: If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural
changes. http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642 Not E: spfile is also backed up.

NEW QUESTION 7
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1. Restore the control files by using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order. A. 7, 6, 1, 2, 3, 5, 4

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

Answer:

Explanation: “If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no datafiles have been restored, and open the database with the RESETLOGS option.” https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmadvre.htm#i1006245

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 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_ 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: C

NEW QUESTION 9
Which two statements are true about making RMAN image copies of a database? Choose two.

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

Answer: BD

NEW QUESTION 10
Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods are performed the truncated table data? (Choose two.)

• A. Table Point-in-Time Recovery.
• B. Database Point-in-Time Recovery
• C. Tablespace Point-in-Time Recovery
• D. Flashback Database
• E. Flashback Transaction Backout

Answer: CD

NEW QUESTION 11
Your database is running in archive log mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

• A. Enable minimal supplemental logging.
• B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
• C. Enable the recyclebin.
• D. Enable undo retention guarantee.
• E. Enable Fast Recovery Area.

Answer: BE

Explanation: https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582 Section: About Flashback Database
Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery are
A. You can only use Flashback Database if flashback logs are available. To take
advantage of this feature, you must set up your database in advance to create flashback logs.

NEW QUESTION 12
For which two requirements would you use the Database Resource Manager?

• A. limiting the CPU used per database call
• B. specifying the maximum number of concurrent sessions allowed for a user
• C. specifying the amount of private space a session can allocate in the shared pool of the SGA
• D. limiting the degree of parallelism of operations performed by a user or group of users
• E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Answer: DE

Explanation: Limit the degree of parallelism of any operation performed by members of a group of users. Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.

NEW QUESTION 13
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?

• A. The PDB is closed.
• B. The PDB is placed in mount state.
• C. The command executes only if the common user is granted the set container privilege for the PDB.
• D. The command results in an error because the PDB can be shut down only by a local use

Answer: B

Explanation: The PDB is placed in mount state. SQL> shutdown immediate; Pluggable Database closed. SQL>
select status from v$instance; STATUS ———— MOUNTED SQL> There is no closed Status in a PDB. PDB can have Mount/Read Write/Read Only.

NEW QUESTION 14
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

• A. password-mode encryption
• B. dual-mode encryption
• C. transparent encryption
• D. default encryption

Answer: B

Explanation: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH To make dualmode encrypted backups: Start RMAN and connect to a target database and recovery catalog (if
used). Execute the SET ENCRYPTION BY PASSWORD command, making sure to omit the ONLY keyword. The following example sets the encryption password for all tablespaces (where password is
a placeholder for the actual password that you enter) in the backup and omits ONLY to indicate dualmode encryption: SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES;

NEW QUESTION 15
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

• A. SQL Performance Analyzer
• B. SQL Access Advisor
• C. SQL Tuning Advisor
• D. Automatic Workload Repository (AWR) report
• E. Automatic Database Diagnostic Monitor (ADDM)

Answer: B

Explanation: References:
http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160

NEW QUESTION 16
Which three statements are true about unplugging a pluggable database (PDB)?

• A. The PDB must be open in read only mode.
• B. The PDB must be dosed.
• C. The unplugged PDB becomes a non-CDB.
• D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E. The unplugged PDB can be plugged into another CDB.
• F. The PDB data files are automatically removed from dis

Answer: BDE

Explanation: B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To explogt the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.

NEW QUESTION 17
View the Exhibit showing steps to create a database resource manager plan. SQL>executedbms_resource_manager.create_pendingarea(); PL/SQLproceduresuccessfully completed. 3QL>execdbms_resource_manager,create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’) PL/SQLproceduresuccessfullycompleted. SQL>execdbras_resource_raanager.create_plan(plan=>’PRIU3ER3',comment=>'dssprio’); SQL>exec
Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,comra ent=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After execting the steps in the exhibit you execute this procedure, which results in an error: SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
What is the reason for the error?

• A. The pending area is automatically submitted when creating plan directives.
• B. The procedure must be executed before creating any plan directive.
• C. The sys_group group is not included in the resource plan.
• D. The other_groups group is not included in the resource plan.
• E. Pending areas can not be validated until submitted.

Answer: D

Explanation: Reference: http://apunhiran.blogspot.com/2011/01/how-to-setup-resource-manager-to_14.html