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
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 + 100DUES
How the community answered
(55 responses)- A5% (3)
- B84% (46)
- C2% (1)
- E9% (5)
Topics
#column aliases#reserved words#SELECT syntax#alias quoting
Community Discussion
No community discussion yet for this question.
