JDBC, Java Server Pages, and MySQL problems
- 1. A JSP is transformed into a(n):
Options- A. Java applet.
- B. Java servlet.
- C. Either 1 or 2 above.
- D. Neither 1 nor 2 above. Discuss
Correct Answer: Java servlet.
- 2. Which JDBC driver Types are for use over communications networks?
Options- A. Type 3 only
- B. Type 4 only
- C. Both Type 3 and Type 4
- D. Neither Type 3 nor Type 4 Discuss
Correct Answer: Both Type 3 and Type 4
- 3. How many JDBC driver types does Sun define?
Options- A. One
- B. Two
- C. Three
- D. Four Discuss
Correct Answer: Four
- 4. What MySQL property is used to create a surrogate key in MySQL?
Options- A. UNIQUE
- B. SEQUENCE
- C. AUTO_INCREMENT
- D. None of the above -- Surrogate keys are not implemented in MySQL. Discuss
Correct Answer: AUTO_INCREMENT
- 5. What is not true of a Java bean?
Options- 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. Discuss
Correct Answer: It may have many constructors as necessary.
- 6. Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Options- A. Type 1
- B. Type 2
- C. Type 3
- D. Type 4 Discuss
Correct Answer: Type 1
- 7. Where is metadata stored in MySQL?
Options- 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. Discuss
Correct Answer: In the MySQL database mysql
- 8. What servlet processor was developed by Apache Foundation and Sun?
Options- A. Apache Tomcat
- B. Apache Web server
- C. Sun servlet processor
- D. None of the above is correct. Discuss
Correct Answer: Apache Tomcat
- 9. To run a compiled Java program, the machine must have what loaded and running?
Options- A. Java virtual machine
- B. Java compiler
- C. Java bytecode
- D. A Web browser Discuss
Correct Answer: Java virtual machine
- 10. ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
Options- A. MySQL
- B. JSP/SQL
- C. JDBC/SQL
- D. Sun ACCESS Discuss
Correct Answer: MySQL
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.