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
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 + 100DUES'
How the community answered
(47 responses)- A11% (5)
- B2% (1)
- C83% (39)
- E4% (2)
Community Discussion
No community discussion yet for this question.
