New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle Database Administration I 1z0-082 Question # 17 Topic 2 Discussion

Oracle Database Administration I 1z0-082 Question # 17 Topic 2 Discussion

1z0-082 Exam Topic 2 Question 17 Discussion:
Question #: 17
Topic #: 2

Examine this description of the TRANSACTIONS table:

1z0-082 Question 17

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


A.

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;


B.

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;


C.

SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;


D.

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


E.

SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;


Get Premium 1z0-082 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.