• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SCEA mock question from Whizlabs

 
Benson Fung
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
  • 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
 
Sujatha Kumar
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
YUP! JDBC is correct. But why ?
I still don't understand. Please help.
Thanks
Benson
 
Vishwa Kumba
Ranch Hand
Posts: 1066
  • Mark post as helpful
  • send pies
  • 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
  • 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?
 
Xie Ruchang
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Oh! My god, man......
Then what is the correct answer???
 
Srinivas Bitla
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • Quote
  • Report post to moderator
Sorry about the graemlin, it shouldn't be there
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic