Question 210 identify the two steps that are

This preview shows page 3 - 6 out of 7 pages.

74
QUESTION:210Identify the two steps that are performed during native PL/SQL compilation for the PL/SQLblocks other than the top-level anonymous PL/SQL blocks. (Choose two.)
QUESTION:211You observe that the current default temporary tablespace, TEMP01, for your database isrunning out of space. You create a new temporary tablespace, TEMP02, and execute thefollowing command to make it the current default temporary tablespace:SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp02;What will be the impact of this command on the active transactions that are still using the olddefault temporary tablespace?
QUESTION:212When you enable the Oracle Flashback feature by providing a specific time, how is thespecified time resolved to the corresponding SCN?
75

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 7 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
Oracle Database

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture