Which two can be recommendations given by SQL Access Advisor? (Choose two.)
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?
Which two can be recommendations given by SQL Access Advisor? (Choose two.)
Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)
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?
Currently there are no comments in this discussion, be the first to comment!