• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

SCEA mock question from Whizlabs

 
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Dear all,
here is the question :
Q. As part of your new application, you need to connect to a database. You do not have any access to the database serverso you cannot change the ODBC driver that's currently installed. How do you connect?
A. CORBA
B. JMS-JNI
C. JDBC-ODBC bridge
D. JDBC
Please put your answer, and I will give you answer after the next reply.

thanks
Benson
 
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Q. As part of your new application, you need to connect to a database. You do not have any access to the database serverso you cannot change the ODBC driver that's currently installed. How do you connect?
Then Answer should be JDBC, In the question they have specified about ODBC driver just to deviate the candidates.
 
Benson Fung
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
YUP! JDBC is correct. But why ?
I still don't understand. Please help.
Thanks
Benson
 
Ranch Hand
Posts: 1066
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok. I am influenced by the "ODBC" bit. If you want to use a Type-4 thin driver. You need to know the details of the database server and have access to it.
In the above scenario, Type-I JDBC-ODBC bridge can also be used.Isn't it?
So both options are correct?
 
Benson Fung
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
According to the suggested answer, it is only JDBC.
But I answered JDBC-ODBC bridge. If I didn't interpret the English wrongly, the question how to connect to the database if the ODBC cannot be changed.
Am I correct? That's why I answered JDBC-ODBC bridge.
What do you think?
 
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, I encountered this question at
Jaworski's Test and the correct answer is JDBC-ODBC. FYI
Best Regards
 
Benson Fung
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oh! My god, man......
Then what is the correct answer???
 
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes, the correct answer is JDBC-ODBC bridge. It is mensioned in the question that you do not have access to the database server except thru ODBC and also you can not modify ODBC Driver. Then the obvious answer is JDBC-ODBC bridge driver. You create a DSN for the database using the ODBC driver and connect using JDBC-ODBC bridge driver.
 
Xie Ruchang
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The question also states that

You do not have any access to the database server.


That means, you do not have an userid or password to the database or no direct network connection. So using JDBC Type 4 driver will not do the job. The only answer would be JDBC-ODBC bridge. The ODBC driver setup will provide the security and connectivity to the database.
 
Xie Ruchang
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry about the graemlin, it shouldn't be there
 
reply
    Bookmark Topic Watch Topic
  • New Topic