exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 2 question 25 discussion

Actual exam question from Oracle's 1z0-062
Question #: 25
Topic #: 2
[All 1z0-062 Questions]

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?

  • A. It throws an error as the QUERY parameter is not supported on an empty table.
  • B. It throws an error as the table test_employees is empty and CONTENT=data_only is specified.
  • C. It performs the export successfully.
  • D. It throws an error as Data Pump cannot find a table called TEST.EMP.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
aleks2004
Highly Voted 4 years, 9 months ago
it is not given TABLES=emp exists , so D is true
upvoted 8 times
oanhnph
4 years, 9 months ago
D is true, I have tested and it given this error: ORA-39034: Table EMP does not exist.
upvoted 5 times
...
...
NorwayOracle
Most Recent 3 years ago
Selected Answer: D
The use of synonyms as values for the TABLES parameter is not supported. For example, if the regions table in the hr schema had a synonym of regn, then it would not be valid to use TABLES=regn. An error would be returned.
upvoted 2 times
...
badguy001djh
4 years ago
D is true, ref: https://docs.oracle.com/database/121/SUTIL/GUID-9D052182-6BD8-4167-B528-2E352C9CDBDB.htm#SUTIL866 key words: synonyms
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago