Oracle Exam 1Z0-062 Topic 5 Question 6 Discussion

Examine these steps:

CONNECT / AS SYSDBA

CREATE DIRECTORY dumpdir AS '/u01/app/';

Directory created.

GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC;

Grant succeeded.

CREATE USER TEST IDENTIFIED BY test;

User created.

GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE TO test;

Grant succeeded.

CONN test/test

Connected.

CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7));

Table created.

SQL> CREATE SYNONYM emp FOR test_employees;

Synonym created.

Now examine this command:

$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP:"WHERE salary=12000"'

What is true about the execution of this command?