Exam 1z0-071 Topic 11 Question 12 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 12
Topic #: 11

Examine the description of the TRANSACTIONStable:

Which two SQL statements execute successfully?
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100

A. transactions;
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 B. DUES FROM transactions;
SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 C. 100 "DUES AMOUNT" FROM transactions;
SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount +100 DUES FROM D. "DUES" FROM transactions;
SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + E. 'DUES' FROM transactions;

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business