Question 101

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?
  • Question 102

    Which two statements are true about single row functions? (Choose two.)
  • Question 103

    The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
    Segment creation is not deferred.
    You execute this command:

    Which three statements must be true so that the SALES user can create tables in SALES_Q1?
    (Choose three.)
  • Question 104

    Which three activities are recorded in the database alert log? (Choose three.)
  • Question 105

    You execute this query:
    SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?