Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Java Beat Question

 
Amirr Rafique
Ranch Hand
Posts: 324
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
34) Which of the following 'SELECT' statements can be used for selecting the
customer object from the 'CUSTOMER' table?
a. SELECT OBJECT(CUST) FROM CUSTOMER AS CUST
b. SELECT CUST FROM CUSTOMER AS CUST
c. SELECT * FROM CUSTOMER AS CUST
d. SELECT CUST FROM CUSTOMER CUST
e. All the above


Why option d is incorrect in answer explanation ....isn't the 'AS' optional in SELECT query
 
Mihai Radulescu
Ranch Hand
Posts: 918
IntelliJ IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi

A, B, D

Regards Mihai
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!