You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c. 

The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade. 

What must you do first in this situation to attempt to fix this problem?

What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

You plan to install the Oracle Database 12c software on a new server. 

The database will use Automatic Storage Management (ASM) and Oracle Restart. 

Oracle Grid Infrastructure for a standalone server is already installed on the server. You want to configure job role separation. 

You create the following operating system users and groups:

- The user oracle as the owner of the Oracle database installation 

- The user grid as the owner of Oracle Grid Infrastructure 

- The group oinstall as an Oracle Inventory group 

- The group dba as the OSDBA group for Oracle database

- The group asmdba as the OSDBA group for Oracle ASM 

- The group asmadmin as the administration privileges group for Oracle ASM 

- The group asmoper as the group for Oracle ASM Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.)

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance. 

You execute the following command to create a table: 

Which two statements are true? (Choose two.)

Which three statements are true about automated maintenance tasks? (Choose three.)

You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. 

During this operation, you want to ensure the following: 

- Long-running queries are not affected. - No extra space is used. 

- Data manipulation language (DML) operations on the table succeed at all times throughout the process. 

- Unused space is reclaimed both above and below the high water mark. 

Which ALTER TABLE option would you recommend?

Examine these statements: 

Which two are true about the result and effects of executing these commands? (Choose two.)

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that: 

HR then opens a second session. 

Which two operations wait when executed in HR’s second session? (Choose two.)