JDBC  «Prev  Next»

JDBC Database Concepts and SQL - Quiz

 
Each question is worth one point. Select the best answer or answers for each question.
1. What is the main advantage of using JDBC to access a database?
Please select the best answer.
  A. Your code needs to know nothing about the structure of the database
  B. Your servlet will be faster
  C. Your code will use fewer database connections
  D. It is the only way to get information from a database when you write in Java


2. What does the SQL statement “SELECT NAME FROM PEOPLE WHERE AGE=25” return?
Please select the best answer.
  A. The NAME and AGE field on every record in the PEOPLE table
  B. The NAME field on every record in the PEOPLE table with 25 in the AGE field
  C. A count of how many records in the PEOPLE table have 25 in the AGE field
  D. A count of how many different NAME values in the PEOPLE table are on records with 25 in the AGE field


3. Which of the following is a good reason to use the JDBC-ODBC bridge?
Please select the best answer.
  A. More of the users who load your Web pages are likely to have ODBC drivers installed than pure JDBC drivers
  B. ODBC code is faster than the equivalent JDBC code
  C. More database vendors have implemented ODBC drivers than JDBC drivers
  D. You write simpler coding using the bridge than using a pure JDBC driver


Your score is 0.0