File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB Certification (SCBCD/OCPJBCD) and the fly likes Java Beat Question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » EJB Certification (SCBCD/OCPJBCD)
Bookmark "Java Beat Question" Watch "Java Beat Question" New topic
Author

Java Beat Question

Amirr Rafique
Ranch Hand

Joined: Nov 14, 2005
Posts: 324
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


"Know where to find the solution and how to use it - that's the secret of success."
Mihai Radulescu
Ranch Hand

Joined: Sep 18, 2003
Posts: 916

hi

A, B, D

Regards Mihai


SCJP, SCJD, SCWCD, OCPJBCD
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Beat Question
 
Similar Threads
beginner
commandButton in dataTable doesn't work -method not found
Simple SQL joining 2 tables - 2 many rows being returned
getTransaction() on transaction-scoped persistence context.
Problem javax.persistence.NoResultException: No entity found for query