Oracle 1Z0-062 Exam Questions

Which two can be recommendations given by SQL Access Advisor? (Choose two.)

Reveal Solution Hide Solution   Discuss   0

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?

Reveal Solution Hide Solution   Discuss   0

Which two can be recommendations given by SQL Access Advisor? (Choose two.)

Reveal Solution Hide Solution   Discuss   0

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

Reveal Solution Hide Solution   Discuss   0

You want to create a test database as a replica of your production database with minimum intervention from a DBA.

Which method would you use?

Reveal Solution Hide Solution   Discuss   0