1.
When you create a stored outline, in which schema is it stored?
2.
What is the maximum number of parallel recover servers when the FAST_START_PARALLEL_ROLLBACK
parameter is set to HIGH?
3.
Given:
LOG_ARCHIEVE_DEST_2" - "LOCATION = /archive2 OPTIONAL" What effect does OPTIONAL have in the
location parameter?
4.
What does fine-grained access enable you to do?
5.
What are autonomous transactions?
6.
When the listener is NOT available during client load balancing and failover, which file does the client use to
pick a listener/
7.
Which four steps are required to transport a tablespace? (Choose four)
8.
Examine this statement:
SELECT deptno, job, SUM(sal)
FROM emp
Which GROUP BY clause would you use to generate a subtotal of the sum of salaries in each department, and
a subtotal of the sum of salaries of all the different job types?
9.
Why would you drop a column instead of marking it unused?
10.
Which statement about transportable tablespaces is true?