JDBC, Java Server Pages, and MySQL Questions and Answers

Practice Mode
Showing 10 of 20 questions
Q1
How many JDBC driver types does Sun define?
  • A One
  • B Two
  • C Three
  • D Four
Answer: Option D
Q2
Where is metadata stored in MySQL?
  • A In the MySQL database metadata
  • B In the MySQL database metasql
  • C In the MySQL database mysql
  • D None of the above is correct.
Answer: Option C
Q3
 Who invented Java?
  • A Netscape
  • B Microsoft
  • C Sun
  • D None of the above is correct.
Answer: Option C
Q4
To run a compiled Java program, the machine must have what loaded and running?
  • A Java virtual machine
  • B Java compiler
  • C Java bytecode
  • D A Web browser
Answer: Option A
Q5
Which JDBC driver Type(s) can be used in either applet or servlet code?
  • A Both Type 1 and Type 2
  • B Both Type 1 and Type 3
  • C Both Type 3 and Type 4
  • D Type 4 only
Answer: Option C
Q6
 ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
  • A MySQL
  • B JSP/SQL
  • C JDBC/SQL
  • D Sun ACCESS
Answer: Option A
Q7
What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
  • A A Java application
  • B A Java applet
  • C A Java servlet
  • D None of the above is correct.
Answer: Option B
Q8
What MySQL property is used to create a surrogate key in MySQL?
  • A UNIQUE
  • B SEQUENCE
  • C AUTO_INCREMENT
  • D None of the above -- Surrogate keys are not implemented in MySQL.
Answer: Option C
Q9
What is not true of a Java bean?
  • A There are no public instance variables.
  • B All persistent values are accessed using getxxx and setxxx methods.
  • C It may have many constructors as necessary.
  • D All of the above are true of a Java bean.
Answer: Option C
Q10
A JSP is transformed into a(n):
  • A Java applet.
  • B Java servlet.
  • C Either 1 or 2 above.
  • D Neither 1 nor 2 above.
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test