• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Tim Cooke
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Frank Carver
  • Henry Wong
  • Ron McLeod
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Himai Minh

A jdiscuss.com question

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It's the question # 28 from the very first mock exam -
Given an Employee bean that has a corresponding Employee table in the database. Form a query that selects all employees with grades not equal to 'B'.
The table has the following fields - EID, FIRSTNAME, LASTNAME, DEPT AND GRADE

Why is my answer wrong?
SELECT object(e) FROM
Employee e WHERE
e.Grade <> 'B'
 
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Your answer looks right to me ...
 
Author & Gold Digger
Posts: 7617
6
IntelliJ IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I suppose it's somehow related to the problem discussed at http://www.jdiscuss.com/Enthuse/jsp/ViewPosts.jsp?forumid=31&topicid=61
 
Gayatri Aryan
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Valentin! I'm relieved now...
I've my exam on the 8th...didn't want to go in with a doubt.
 
Ranch Hand
Posts: 3178
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Gayatri Aryan:
Thanks Valentin! I'm relieved now...
I've my exam on the 8th...didn't want to go in with a doubt.


I also have mine on May 17... Don't forget to share your exam experience here also... I read every single posts about the exam experience in the Certification Result forum... I feel I'm really eager to others' exam experience and try to get lessons from them...
 
Gayatri Aryan
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Definitely I'll...that's the least I can do for Javaranch...
 
Hey, I'm supposed to be the guide! Wait up! No fair! You have the tiny ad!
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic