Question 66

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
  • Question 67

    Which three statements are true concerning logical and physical database structures? (Choose three.)
  • Question 68

    Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)
  • Question 69

    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 70

    Your database instance is started with a PFILE.
    Examine these parameters:

    You want to increase the size of the buffer cache.
    Free memory is available to increase the size of the buffer cache.
    You execute the command:
    SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
    What is the outcome?