Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)

Which four statements are true about database instance behavior? (Choose four.)

Your database is in ARCHIVELOG mode. 

You want to disable archiving for the database. 

Examine these steps: 

1. Execute the ALTER DATABASE NOARCHIVELOG command 

2. Execute SHUTDOWN IMMEDIATE 

3. Execute STARTUP MOUNT 

4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/ 

5. Execute STARTUP NOMOUNT 

6. Open the database 

7. Execute SHUTDOWN TRANSACTIONAL 

Identify the required steps in the correct sequence.

A database is open READ WRITE and the instance has multiple sessions some of which have active transactions. 

You execute this command: S

QL> ALTER SYSTEM ENABLE RESTRICTED SESSION; 

Which three are true about the active transactions? (Choose three.)

Which three statements are true about a job chain? (Choose three.)

An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted. 

Which two types of lock are held by the transaction? (Choose two.)

DEFERRED_SEGMENT_CREATION is TRUE in one of your databases. 

You execute this command: 

Which three statements are true immediately after this statement executes successfully? (Choose three.)