Jdbc Java Server Pages And Mysql(Computer Science > Database ) Questions and Answers
Question 1. How many JDBC driver types does Sun define?
One
Two
Three
Four
Explanation:-
Answer: Option D. -> Four
Question 2. Where is metadata stored in MySQL?
In the MySQL database metadata
In the MySQL database metasql
In the MySQL database mysql
None of the above is correct
Explanation:-
Answer: Option C. -> In the MySQL database mysql
Question 3. To run a compiled Java program, the machine must have what loaded and running?
Java virtual machine
Java compiler
Java bytecode
A Web browser
Explanation:-
Answer: Option A. -> Java virtual machine
Question 4. Who invented Java?
Netscape
Microsoft
Sun
None of the above is correct
Explanation:-
Answer: Option C. -> Sun
Question 5. Which JDBC driver Type(s) can be used in either applet or servlet code?
Both Type 1 and Type 2
Both Type 1 and Type 3
Both Type 3 and Type 4
Type 4 only
Explanation:-
Answer: Option C. -> Both Type 3 and Type 4
Question 6. ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS
Explanation:-
Answer: Option A. -> MySQL
Question 7. What MySQL property is used to create a surrogate key in MySQL?
UNIQUE
SEQUENCE
AUTO_INCREMENT
None of the above -- Surrogate keys are not implemented in MySQL
Explanation:-
Answer: Option C. -> AUTO_INCREMENT
Question 8. 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 Java application
A Java applet
A Java servlet
None of the above is correct
Explanation:-
Answer: Option B. -> A Java applet
Question 9. What is not true of a Java bean?
There are no public instance variables.
All persistent values are accessed using getxxx and setxxx methods.
It may have many constructors as necessary.
All of the above are true of a Java bean.
Explanation:-
Answer: Option C. -> It may have many constructors as necessary.