Which two statements are true about Oracle network connections? (Choose two.)

• A. The listener always spawns a new server process to deal with each new connection.
• B. A listener may listen on behalf of only one database instance at a time.
• C. A server process checks a user's authentication credentials and creates a session if the credentials are valid.
• D. The listener continuously monitors a connection after the user process connects to a service handler.
• E. A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.

Your production database PROD uses file system storage. You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic Storage Management (ASM) by using RMAN.
You back up the entire database.
What should the next step be in this migration process?

• A. enabling row movement for the database
• B. placing all tablespaces in read-only mode
• C. disabling Oracle Flashback Database if enabled
• D. opening the database in exclusive mode

To enable faster incremental backups, you enabled block change tracking for the database.
Which two statements are true about the block change tracking file? (Choose two.)

• A. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
• B. RMAN does not support backup and recovery of the change tracking file.
• C. Multiple change tracking files can be created for a database.
• D. The change tracking file must be created after the first level 0 backup.

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.)

• A. LOCK TABLE employees IN EXCLUSIVE MODE;
• B. INSERT INTO employees(empno,ename) VALUES (1289, 'Dick');
• C. SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;
• D. SELECT empno,ename FROM employees WHERE job='CLERK';
• E. INSERT INTO employees(empno,ename,job) VALUES (2001,'Harry','CLERK);

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

• A. Recover the table using traditional Tablespace Point In Time Recovery.
• B. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  OCP.EXAM_RESULTS; connected as SYSTEM.
• C. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  EXAM_RESULTS; connected as the OCP user.
• D. Recover the table using Automated Tablespace Point In Time Recovery.
• E. Recovery the table using Database Point In Time Recovery.