Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A.All database operations performed by the impdp command are logged.
• B.Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
• C.Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
• D.None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

Comment: *

Name: *

Email: *

Verification: *

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

• A.The RMAN backup contains only data files.
• B.The database must be in MOUNT state to take RMAN backup.
• C.The database must be shut down to take a user-managed backup.
• D.The user-managed backup consists of only formatted data blocks.
• E.The RMAN backup can be performed while the database is open.

Comment: *

Name: *

Email: *

Verification: *

Examine the details of the uncompressed, non-partitioned heap table CITIES.

Examine the command:
SQL>ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

• A.Disable all indexes on the table.
• B.Ensure there are no pending transactions on the table.
• C.Enable row movement is enabled.
• D.Ensure free space that is approximately equal to the space used by the table should be available.

Comment: *

Name: *

Email: *

Verification: *

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

• A.BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• B.BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• C.BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• D.BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• E.BACKUP SPFILE SECTION SIZE 1M;
• F.BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
• G.BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

Comment: *

Name: *

Email: *

Verification: *

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:

HRthen opens a second session.

• A.SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;
• B.INSERT INTO employees(empno,ename,job) VALUES (2001,'Harry','CLERK');
• C.INSERT INTO employees(empno,ename) VALUES (1289, 'Dick');
• D.Which two operations wait when executed in HR's second session? (Choose two.) LOCK TABLE employees IN EXCLUSIVE MODE;
• E.SELECT empno,ename FROM employees WHERE job='CLERK';

Comment: *

Name: *

Email: *

Verification: *