Q1. Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
A. By default, EM express is available for a database after database creation.
B. You can use EM express to manage multiple databases running on the same server.
C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
E. You can create and configure pluggable databases by using EM express.
Answer: A
Explanation: EM Express is built inside the database.
Note: Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basicdatabase administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
Q2. Which three statements are true about the keystore storage framework for transparent data encryption?
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 databaseusers 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: A,D,F
Reference: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework)
Q3. You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?
A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D. Database files stored in ZFS and accessed using conventional NFS mounts.
E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Answer: A,E,G
Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or
Sun ZFS Storage Appliance (ZFSSA).
Note:
*
Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
*
Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.
Q4. Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
A. A PDB opened in restricted mode allows only local users to connect.
B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
C. When a CDB is in mount state, PDBs are automatically placed in mount state.
D. All PDBs must be shut down before shutting down a CDB instance.
E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable databasecommand.
Answer: B,C,E
Q5. Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
A. A DBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMU can report columns that are too long in the converted characterset
E. The DMU can report columns that are not represented in the converted characterset
Answer: A,D,E
Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps ofthe migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target
character set is different than the representation in the current character set, but neither
length limit issues nor invalid representation issues have been found.
Q6. 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 reconnectingwith 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 astartup command
Answer: C
Q7. In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?
A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
B. Setting the target tablespace to read-only after the segments are moved
C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3Spercent used
D. Taking the target tablespace offline after the segments are moved
E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
Answer: B,C
Q8. In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?
A. The tablespace will be renamed but the data file headers will not be updated.
B. The statement will fail because you cannot rename an undo tablespace.
C. The tablespace will be renamed and all the changes will be logged in the alert log.
D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.
Answer: C
Q9. 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 D3ID 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: D
Q10. Examine the RMAN commands executed in your database:
RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICETYPE 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 change.
Answer: B,E
Q11. 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: B,E
Q12. Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incrementalbackup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
Answer: B
Q13. Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?
A. The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
B. A backup of pdbi and pd35 must exist before executing the command.
C. The duplicate command first creates a backup, and then duplicates the PDBs by using the
D. backup.
E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
Answer: D,E
Q14. 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
Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TD PPT160(4thpara)
Q15. Which two statements are true about unified auditing?
A. A unified audit trail captures audit information from unified audit policies and audit settings.
B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
C. Audit records are created for all users except sys.
D. Audit records are created only for the DML and DDL operations performed on database objects.
E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
Answer: A,F
Q16. Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job’,FORCED_TRACKING=>'Y');
Which two statements are true?
A. Database operations will be monitored only when they consume a significant amount of resource.
B. Database operations for all sessions will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D. Only DML and DDL statements will be monitored for the session.
E. All subsequent statements in the session will be treated as one database operation and will be monitored.
Answer: C,E
Explanation: C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL
Monitoring and Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the
current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'.
/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.