nerdexam
Oracle

1Z0-082 · Question #18

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

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

SQL and PL/SQL

Question

Examine this description of the TRANSACTIONS table:

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

Exhibit

1Z0-082 question #18 exhibit

Options

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

How the community answered

(55 responses)
  • A
    5% (3)
  • B
    84% (46)
  • C
    2% (1)
  • E
    9% (5)

Topics

#column aliases#reserved words#SELECT syntax#alias quoting

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice