MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 36 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
MySQL maintains metadata in the database . |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
A servlet is a Java program that is invoked via HTTP on the Web server.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
JDBC stands for Java Database Connectivity%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Sun defines four JDBC driver types.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
MySQL is pronounced "my See-quel."%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 6. |
MySQL surrogate keys are given the property AUTO_INCREMENT.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
JDBC Type 1 drivers are JDBC-ODBC bridge drivers.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
With JSP, the coding is done in Java and only in Java.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
JDBC Type 2 drivers connect to the native API of the DBMS.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 12. |
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. | True |
| B. | False |
| Answer» B. False | |
| 13. |
The JVM (Java virtual machine) interprets Java bytecode at run time.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
Java programs are compiled into bytecode.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
JSP and ASP not only look alike but their underlying technology is quite similar.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 16. |
Even though Java is machine-independent, JSPs are not.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 17. |
MySQL maintains metadata in the database meta_sql.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 18. |
MySQL is just as powerful as Oracle and is half the price.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 19. |
Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 20. |
Java bytecode is machine-specific code.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 21. |
Apache Web server does not support servlets.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 22. |
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 | |
| 23. |
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 | |
| 24. |
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. | |
| 25. |
*/*_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 | |
| 26. |
*/*_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 | |
| 27. |
*/*_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 | |
| 28. |
*/*_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. | |
| 29. |
_ 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 | |
| 30. |
__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 | |
| 31. |
__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 | |
| 32. |
__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. | |
| 33. |
_Who invented Java?$? |
| A. | Netscape |
| B. | Microsoft |
| C. | Sun |
| D. | None of the above is correct |
| Answer» D. None of the above is correct | |
| 34. |
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 | |
| 35. |
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 | |
| 36. |
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 | |