Tag: 1Z0-062 Dumps

Vendor: Oracle
Exam Code: 1Z0-062
Exam Name: Oracle Database 12c: Installation and Administration

QUESTION 1
Examine the parameters for your database instance:
NAMETYPE VALUE
————————– ——————————- —————————
undo_management string AUTO
undo_retentioninteger 12 00
undo_tablespace string UNDOTBS1
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

A.    Undo data is written to flashback logs after 1200 seconds.
B.    Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
C.    You can perform a Flashback Database operation only within the duration of 1200 seconds.
D.    An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Answer: A

» Read more

QUESTION 1
Which three statements are true about a job chain?

A.    It can contain a nested chain of jobs.
B.    It can be used to implement dependency-based scheduling.
C.    It cannot invoke the same program or nested chain in multiple steps in the chain.
D.    It cannot have more than one dependency.
E.    It can be executed using event-based or time-based schedules.

Answer: ABE
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12459

» Read more