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

• A.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• B.It empties the recycle bin.
• C.It removes the audsys schema and the audit_admin and audit_viewer roles.
• D.It sets all user tablespaces to "read-only" before starting the upgrade.
• E.It Increases tablespace size, if required, to meet upgrade requirements.
• F.It recompiles all stored pl/sql code by using utlrp.sql.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

• A.It is an Oracle Database service
• B.It cannot be used to upgrade Oracle Database homes.
• C.It can be used to provision applications.
• D.It can be used to patch Grid Infrastructure homes containing Oracle Restart.
• E.It can be used to provision middleware.

Comment: *

Name: *

Email: *

Verification: *

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A.Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
• B.The valid time columns are not populated by the Oracle Server automatically.
• C.The valid time columns employee_time_start and employee_time_end are automatically created.
• D.Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe AS OF TIMESTAMP and PERIOD FOR clauses.
• E.The valid time columns are visible by default when the table is described.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

• A.CDB$ROOT, PDB2, PDB1, and PDB3
• B.CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
• C.CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
• D.CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
• E.CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

Comment: *

Name: *

Email: *

Verification: *

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true?

• A.An application seed PDB Is created for APP1.
• B.Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
• C.APP1 can never be unplugged.
• D.An application root PDB is created for APP1.
• E.A default service Is created for the application root APP1.
• F.Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

Comment: *

Name: *

Email: *

Verification: *