1. Which three statements are true about the Pre-Upgrade Information Tool?
A) It clears all user recycle bins in a database and releases their storage space.
B) It writes a list of invalid SYS and SYSTEM objects to the registry$sys_inv_objs table.
C) It evaluates the dependencies of network utility packages.
D) It identifies any deprecated and unsupported parameters.
E) It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.


2. Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
A) configuration of unified auditing mode
B) execution of SQL statements by users connected with the SYSDBA privilege
C) usage of the AUDIT statement
D) creation of a fine grained audit policy


3. Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c
A) Put all read­only tablespaces in read write mode.
B) Recompile all invalid objects
C) Set the compatible parameter to 12 ­ 1 ­ 0 ­ 1
D) Gather dictionary statistics.
E) Empty all user recycle bins.


4. Which two tools can be used to configure static service information in the listener.ora file?
A) Oracle Net Manager
B) Oracle Enterprise Manager Cloud Control
C) Oracle Net Configuration Assistant
D) Listener Control Utility (LSNRCTL)
E) Oracle Enterprise Manager Database Express

5. In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and a Automatic Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
A) It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
B) It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
C) It calls other advisors if required, but does not provide recommendations about the advisors to be used.
D) It always compares the latest snapshot with the baseline snapshot for analysis.
E) It requires at least four AWR snapshots for analysis.

6. Which three file types are stored in the Fast Recovery Area by default in a traditional non­OMF file system?
A) online redo log files
B) parameter file
C) multiplexed copies of the current control file
D) archived log files
E) Flashback Data Archive files
F) Flashback logs


7. You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?
A) A custom database template
B) A Data Warehouse database template
C) Automatic Storage Management (ASM) for storage of data files.
D) A file system for storage of data files


8. Which two statements are true about the Database Configuration Assistant (DBCA)?
A) It can be used to add an new tablespace
B) It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
C) It can configure Automatic Storage Management (ASM) diskgroups.
D) It can be used to create a database template from an existing database
E) It can generate SQL database creation scripts.


9. Identify two prerequisites for configuring Enterprise Manger Database Express (EM Express).
A) Grant the APEX_PUBLIC_USER role to the SYSMAN user
B) Install Oracle HTTP Server
C) Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server
D) Configure at least one dispatcher for the TCP/IP protocol
E) Create a SYSMAN user with the SYSDBA privilege as an administration for EM Express.


10. Which three tools or tasks are run by default as part of automated maintenance tasks?
A) SQL Access Advisor
B) Optimizer statistics gathering
C) Segment Advisor
D) Automatic SQL Tuning Advisor
E) Automatic Database Diagnostic Monitor


11. Which three statements are true about automated maintenance tasks?
A) Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
B) A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
C) They run at predefined time intervals that are intended to occur during a period of low system loads
D) An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.
E) A maintenance window is automatically extended until all the maintenance tasks defined are completed.


12. What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?
A) It generates a log file containing the fixes that can be made to the source database.
B) It recompiles all invalid PLSQL and Java code.
C) It provides parallel upgrade options to finish the upgrade process with a reduced down time.
D) It provides a summary of the upgrade results.
E) It generates fix­up scripts to be run on the source database before upgrade.


13. You install Oracle Grid Infrastructure standalone server and issue the following command:
crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration?
A) Oracle CSSD services
B) the database whose instance is running
C) Oracle Notification services
D) Oracle Healthcheck services
E) Oracle Net Listener


14. Which three statements are true about Oracle Restart?
A) It can be configured to automatically attempt to restart various components after a hardware or software failure
B) It can be used to only start Oracle components
C) While starting any components, it automatically attempts to start all dependencies first and in proper order
D) It runs periodic check operations to monitor the health of Oracle components.
E) It can be configured to automatically restart a database in case of normal shutdown of the database instance.


B & D: Oracle Restart ensures that Oracle components are started in the proper order

E: Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted.


15. Which two statements are true about using SQL*Loader?
A) It can load into multiple tables using the same load statement.
B) It can generate unique sequential key values in specified columns.
C) It can load data from external files by using the direct path only.
D) It can load data into one table at a time.
E) It can load data from external files by using the conventional path only.


16. Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?
A) The DEGREE_OF_PARALLELISM parameter is set to AUTO
B) You cannot load data into multiple tables.
C) You can selectively load rows into a table based on a filter.
D) If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory and uses it.
E) You cannot have multiple SQL*Loader data files.


17. You want the execution of a large database operation to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600
Which two statements are true?
A) Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE ­ Statement must be issued in its session.
B) Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C) A suspended statement will report an error if no corrective action has taken place during timeout period.
D) Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
E) A resumable statement can be suspended and resumed only once during execution.


18. In your database instance, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:
CREATE PROFILE app_user LIMIT
SESSIONS_PER_USER    5
CPU_PER_SESSION   UNLIMITED
CPU_PER_CALL   3000
IDLE_TIME    10
PASSWORD_LIFE_TIME  60
PASWORD_REUSE_TIME  60
PASWORD_REUSE_MAX  UNLIMITED
Which two statements are true about users and their sessions that are subject to this profile?
A) The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
B) These users can never reuse a password
C) The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
D) In each user session, the limit for LOGICAL_READS_PER_SESSION is the same as defined in the DEFAULT profile.


19. You want to reduce fragmentation and reclaim unused space of the SALES table but not its dependent objects. During the operation, you want to ensure the following:
i. Long-running queries are not affected
ii. No extra space is used
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommended?
A) DEALLOCATE UNUSED
B) SHRINK SPACE CASCADE
C) SHRINK SPACE COMPACT
D) ROW STORE COMPRESS BASIC

20. The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
A) Exclusive table-level lock on the EMPLOYEES table
B) Row-exclusive lock on the row being updated
C) Null lock on the EMPLOYEES table
D) Null lock on the row being updated


21. You have the following entry in the tnsnames.ors file of your hq.us.example.com host machine:
ORCL =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADRESS = (PROTOCOL = TCP)(HOST = hq.us.example.com)(PORT = 1521))
  )
  CONNECTED_DATA =
   (SERVICE_NAME = ORCL.us.example.com)
  )
 )
You issue the following command at the command prompt:
Sqlplus HR/HR@ORCL
Which statement is true about the connection to the ORCL database instance?
A) The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.
B) The connection fails because the net service name does not have the suffix us.example.com.
C) The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.
D) The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.


22. Which statement is true about redo log files during instance recovery?
A) All current, active, and inactive redo logs are required to complete instance recovery.
B) All redo log entries in the current and active logs are applied to the data files to reconstruct changes made after the most recent checkpoint.
C) All redo log entries in the current log are applied to data files until the checkpoint position is reached.
D) All current, online, and archived redo logs are required to complete instance recovery.


23. A database uses Automatic storage Management (ASM) as database storage, which has diskgroup, DATA1, which is created as follows:
SQL> CREATE DISKGROUP data1 NORMAL REDUNDANCY
 FAILUREGROUP failuregrp1 DISK ‘/dec/sda1’, ‘/dev/sda2’,
FAILUREGROUP failuregrp2 DISK ‘/dec/sda3’, ‘/dev/sda4’;
What happens when the FAILURGRP1 failure group is corrupted?
A) Mirroring of allocation units occurs within the FAILUREGRP2 failure.
B) Transactions that are using diskgroup fail.
C) ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILUREGRP2 failure group.
D) Data in the FAILUREGRP1 failure group is move to the FAILUREGRP2 failure group and rebalancing is started.


24. Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make –f ins_rdbms.mk uniaud_on ioracle ORACLE_Home=$ORACLE_HOME
Which two steps should you perform before executing this command?
A) Ensure that the initialization parameter AUDIT_TRAIL is set to DB.
B) Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.
C) Shutdown the database instance
D) Drop any existing fine-grained audit (FGA) policies
E) Stop the listener.


25. Which three factors influences the optimizer’s choice of an execution plan?
A) Cardinality estimates
B) The OPTIMIZER_MODE initialization parameter
C) Fixed baselines
D) Type of connection used to connect to database instance
E) Object statistics in the data dictionary


26. Which three statements are true about Oracle Data Pump?
a) IMPDP can be used to change target data file names, schemas, and tablespaces during import.
b) Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
c) IMPDP always use the conventional path insert method to import data.
d) The DBMS_DATAPUMPS Pl/SQl Packages can be used independently of Data Pump clients to perform export and import operations.
e) EXPDP and EIMPDP are the client components of Oracle Data Pump.


27. The DEFERRED_SEGMENT_CREATION parameter is set TRUE in your database instance.    (erfasst)
You execute the following command to create a table:
SQL> CREATE TABLE acctl
 (ac_no NUMBER,
 ac_desc varchar2(25),
 amount number(10,2));
Which two statements are true?
A) A segment is allocated when an index is created for any column in the table.
B) The table is created without segment because the storage clause is missing
C) A segment is allocated when the first row is inserted table.
D) A segment is allocated for the table if the ALTER TABLE …..ALLOCATE EXTENT command is issued.
E) The table is created and extents are immediately allocated as per default storage defined for its tablespace.


28. The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMETS .DEPARTMENT_ID column. An index exists on the DEPARTMETS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?
A) The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
B) Only the rows that are deleted in the DEPARTMETS and EMPLOYEES tables are locked until the transaction on the DEPARTMENTS table is complete.
C) The transaction acquires a table lock only on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS is complete.
D) The transaction acquires a table lock only on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS is complete.


29. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
A) It runs automatically after each AWR snapshot is created and it requires at least two snapshots for analysis.
B) Its results are stored in AWR.
C) It calls SQL advisors automatically if required.
D) It provide recommendations only for poorly performing SQL statements.
E) It requires at least one AWR snapshot for analysis.


30. Which set of statements is true about data dictionary views?
1) They are stored in the SYSTEM tablespace.
2) They are based on virtual tables
3) They are owned by the SYS user
4) They can be queried by a normal user only of the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5) The V$FIXED_TABLE view can be queried to list the names of these views
6) They are owned by the SYSTEM user.
A) 2, 5 and 6
B) 2, 3, 4, and 5
C) 1 and 3
D) 1, 2 and 3