You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
* 1.Make the UNIVERSITY tablespace read-only on the source system.
* 2. Export the UNIVERSITY tablespace metadata using EXPDP.
* 3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
* 4. Copy the UNIVERSITY tablespace data files to the destination system.
* 5.Copy the Data Pump dump set to the destination system.
* 6. Convert the UNIVERSITY tablespace data files to thedestination platform format using RMAN on the destination system.
* 7. Import the UNIVERSITY tablespace metadata using IMPDP.
* 8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

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

Correct Answer: B

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

1. A. It recompiles all stored PL/SQL code by using utlrp.sql.
2. B. It empties the RECYCLE BIN.
3. C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
4. D. It sets all user tablespaces to “read-only” before starting theupgrade.
5. E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
6. F. It increases tablespace size, if required, to meet upgrade requirements.

Correct Answer: ACF

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

1. A. defining primary keys for all tables to speed up all queries
2. B. using check constraints to speed upupdates
3. C. defining foreign keys for all tables to speed up joins
4. D. the physical data model
5. E. the configuration of storage arrays

Correct Answer: AE

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

1. A. The runfixup.sh script can install missing RPMs.
2. B. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
3. C. It allows you to select the languages supported by the Oracledatabase server.
4. D. It can be done before installing Grid Infrastructure for a Standalone Server.
5. E. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
6. F. It can be done after installing Grid Infrastructure for a Standalone Server.
7. G. The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

Correct Answer: CEG

A user complains about poor database performance.
You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

1. A. V$SESSION_EVENT
2. B. V$SESSTAT
3. C. V$SESSION_WAIT
4. D. V$SESSION_WAIT_CLASS
5. E. V$SESSION

Correct Answer: A