Exit 1Z0-082 Oracle DBA Administration I
Question 1 of 5
0% complete
Q1 Multiple choice

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

Select all that apply.

  • A

    SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM
    transactions;

  • B

    SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM
    transactions;

  • C

    SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES
    AMOUNT" FROM transactions;

  • D

    SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM
    transactions;

  • E

    SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES
    AMOUNT' FROM transactions;

Previous Next