Oracle Exam 1Z0-082 Topic 18 Question 16 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 16
Topic #: 18

Examine this description of the TRANSACTIONS table:

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

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

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

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

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

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

Show Suggested Answer

Suggested Answer: B, D

by Stephen at May 09, 2022, 03:18 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!