Question 106

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

    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 108

    Examine this description of the TRANSACTIONS table:

    Which two SQL statements execute successfully? (Choose two.)
    SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100
  • Question 109

    Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
    ALTER DATABASE MOUNT;
    Which two actions are performed? (Choose two.)
  • Question 110

    You execute this command:

    During the export operation, you detach from the job by using CTRL+C and then execute this command:
    Export> STOP_JOB=immediate
    Are you sure you wish to stop the job ([yes]/no): yes
    Which two statements are true about the job? (Choose two.)