1z0-071 Exam Question 96

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?
  • 1z0-071 Exam Question 97

    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEEStable in the HR schema by issuing the following command:
    $> sqlldr hr/hr@pdb table=employees
    Which two statements are true regarding the command? (Choose two.)
  • 1z0-071 Exam Question 98

    Evaluate the following SQL statement:
    SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION
    SELECT cust_id CUST_NO, cust_last_name
    FROM customers
    WHERE country_id = 30;
    Which ORDER BY clause are valid for the above query? (Choose all that apply.)
  • 1z0-071 Exam Question 99

    Which two are true about a SQL statement using SET operators such as UNION?
  • 1z0-071 Exam Question 100

    Which two statements are true about INTERVAL data types? (Choose two.)