Topic: 1z0-082 topic 1 question 70

Examine this description of the TRANSACTIONS table:

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;

Re: 1z0-082 topic 1 question 70

B,D is correct answers.

Re: 1z0-082 topic 1 question 70

The correct answers are B, D.
A is not correct because the DATE alias uses a reserved word and is not double-quoted.

Re: 1z0-082 topic 1 question 70

c is not because of the middle dash in CUSTOMER-ID

Re: 1z0-082 topic 1 question 70

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;

Re: 1z0-082 topic 1 question 70

Yes BD is okay

Re: 1z0-082 topic 1 question 70

BD - Correct