ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam
Go to Exam

Exam 1z0-082 topic 1 question 70 discussion

Actual exam question from Oracle's 1z0-082
Question #: 70
Topic #: 1
[All 1z0-082 Questions]

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;
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
by Givin at Nov. 14, 2022, 3:30 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
8hyehye8
9 months ago
Selected Answer: BD
B,D is correct answers.
upvoted 2 times
...
Oracle2020
9 months, 1 week ago
The correct answers are B, D. A is not correct because the DATE alias uses a reserved word and is not double-quoted.
upvoted 1 times
Oracle2020
9 months ago
c is not because of the middle dash in CUSTOMER-ID
upvoted 1 times
...
...
zouve
1 year, 4 months ago
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;
upvoted 3 times
...
Darkseid1231
1 year, 5 months ago
Yes BD is okay
upvoted 1 times
...
Givin
2 years, 1 month ago
BD - Correct
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel