MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 40 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Even though Java is machine-independent, JSPs are not. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
MySQL is pronounced "my See-quel." |
| A. | 1 |
| B. | |
| Answer» C. | |
| 3. |
An applet is a Java bytecode program that is sent to the user via HTTP and is invoked using the HTTP protocol on the user's computer. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 4. |
JSP and ASP not only look alike but their underlying technology is quite similar. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 5. |
JDBC Type 1 drivers are JDBC-ODBC bridge drivers. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
MySQL maintains metadata in the database meta_sql. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 7. |
JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 8. |
Sun defines four JDBC driver types. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 9. |
The JVM (Java virtual machine) interprets Java bytecode at run time. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 10. |
Type 3 and Type 4 JDBC drivers can be used for sevlets and applets. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 11. |
JDBC stands for Java Database Connectivity |
| A. | 1 |
| B. | |
| Answer» B. | |
| 12. |
With JSP, the coding is done in Java and only in Java. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 13. |
Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 14. |
A servlet is a Java program that is invoked via HTTP on the Web server. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 15. |
What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser? |
| A. | A Java application |
| B. | A Java applet |
| C. | A Java servlet |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 16. |
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» C. Either 1 or 2 above. | |
| 17. |
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» D. All of the above are true of a Java bean. | |
| 18. |
What is bytecode? |
| A. | Machine-specific code |
| B. | Java code |
| C. | Machine-independent code |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 19. |
Java bytecode is machine-specific code. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 20. |
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» D. None of the above -- Surrogate keys are not implemented in MySQL. | |
| 21. |
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» C. A Java servlet | |
| 22. |
What programming language(s) or scripting language(s) does Java Server Pages (JSP) support? |
| A. | VBScript only |
| B. | Jscript only |
| C. | Java only |
| D. | All of the above are supported |
| Answer» D. All of the above are supported | |
| 23. |
JDBC stands for: |
| A. | Java Database Connectivity |
| B. | Java Database Components |
| C. | Java Database Control |
| D. | None of the above is correct. |
| Answer» B. Java Database Components | |
| 24. |
Java programs are compiled into bytecode. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 25. |
How does Tomcat execute a JSP? |
| A. | As a CGI script |
| B. | As an independent process |
| C. | By one of Tomcat's threads |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 26. |
Which JDBC driver Types are for use over communications networks? |
| A. | Type 3 only |
| B. | Type 4 only |
| C. | Both Type 3 and Type 4 |
| D. | Neither Type 3 nor Type 4 |
| Answer» D. Neither Type 3 nor Type 4 | |
| 27. |
Apache Web server does not support servlets. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 28. |
JDBC Type 2 drivers connect to the native API of the DBMS. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 29. |
How many copies of a JSP page can be in memory at a time? |
| A. | One |
| B. | Two |
| C. | Three |
| D. | Unlimited |
| Answer» B. Two | |
| 30. |
MySQL surrogate keys are given the property AUTO_INCREMENT. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 31. |
What servlet processor was developed by Apache Foundation and Sun? |
| A. | Apache Tomcat |
| B. | Apache Web server |
| C. | Sun servlet processor |
| D. | None of the above is correct. |
| Answer» B. Apache Web server | |
| 32. |
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» B. Java compiler | |
| 33. |
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» D. None of the above is correct. | |
| 34. |
Who invented Java? |
| A. | Netscape |
| B. | Microsoft |
| C. | Sun |
| D. | None of the above is correct. |
| Answer» D. None of the above is correct. | |
| 35. |
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge? |
| A. | Type 1 |
| B. | Type 2 |
| C. | Type 3 |
| D. | Type 4 |
| Answer» B. Type 2 | |
| 36. |
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine? |
| A. | Type 1 only |
| B. | Type 2 only |
| C. | Both Type 3 and Type 4 |
| D. | All of Type 1, Type 2, Type 3 and Type 4 |
| Answer» E. | |
| 37. |
MySQL is just as powerful as Oracle and is half the price. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 38. |
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» D. Type 4 only | |
| 39. |
________ 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» B. JSP/SQL | |
| 40. |
How many JDBC driver types does Sun define? |
| A. | One |
| B. | Two |
| C. | Three |
| D. | Four |
| Answer» E. | |