nerdexam
Oracle

1Z0-071 · Question #332

Examine the description of the TRANSACTIONS table: Which two SQL statements execute successfully? (Choose two.)

The correct answer is C. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount +100 DUES FROM D. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES. See the full explanation below for the reasoning.

Question

Examine the description of the TRANSACTIONS table:

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

Exhibit

1Z0-071 question #332 exhibit

Options

  • ASELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES"
  • BSELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
  • CSELECT customer_id CUSTID, transaction_date TRANS_DATE, amount +100 DUES FROM
  • DSELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES
  • ESELECT customer_id AS CUSTOMER-ID', transaction_date AS DATE, amount + 100 DUES'

How the community answered

(47 responses)
  • A
    11% (5)
  • B
    2% (1)
  • C
    83% (39)
  • E
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice