1z0-071 Exam Question 11

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week Which query can be used?
  • 1z0-071 Exam Question 12


    Which three statements are true?
  • 1z0-071 Exam Question 13

    You execute these commands successfully:
    CREATE GLOBAL TEMPORARY TABLE invoices _ gtt
    ( customer id INTEGER,
    invoice_ total NUMBER (10, 2)
    ) ON COMMIT PRESERVE ROWS;
    INSERT INTO invoices_ gtt VALUES (1, 100);
    COMMIT;
    Which two are true?
  • 1z0-071 Exam Question 14

    Examine the description of the EMPLOYEES table:

    Examine this query:

    Which line produces an error?
  • 1z0-071 Exam Question 15

    Which three statements are true about GLOBAL TEMPORARY TABLES?