Jdbc_ Java Server Pages_ And Mysql MCQs with Explanations
Practice high-yield Computer Science & IT MCQs on Jdbc_ Java Server Pages_ And Mysql with worked academic solutions for PPSC, FPSC, CSS, PMS, NTS.
Questions
39
Difficulty Level
Exam-Level
Target Exams
PPSC, FPSC, CSS...
Estimated Time
47 mins
Exam-Level PPSC FPSC CSS PMS NTS
Verified for Commission Syllabus • Oct 14, 2026
39
Verified Practice Questions
Interactive test mode with detailed academic worked solutions
Live Progress | 0/39 answered
✓ 0 correct
✗ 0 wrong
0% score
🎉 Set complete! All 39 questions answered.
Question 1 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Question 2 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Where is metadata stored in MySQL?
Question 3 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Who invented Java?
Question 4 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
To run a compiled Java program, the machine must have what loaded and running?
Question 5 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Which JDBC driver Type(s) can be used in either applet or servlet code?
Question 6 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
________ is an open source DBMS product that runs on UNIX, Linux and Windows.
Question 7 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
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?
Question 8 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
What MySQL property is used to create a surrogate key in MySQL?
Question 9 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
What is not true of a Java bean?
Question 10 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
A JSP is transformed into a(n):
Question 11 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
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?
Question 12 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
Question 13 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
What servlet processor was developed by Apache Foundation and Sun?
Question 14 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
What is bytecode?
Question 15 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
Question 16 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Question 17 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
How many copies of a JSP page can be in memory at a time?
Question 18 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Which JDBC driver Types are for use over communications networks?
Question 19 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
How does Tomcat execute a JSP?
Question 20 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
MySQL is just as powerful as Oracle and is half the price.
Question 21 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Java programs are compiled into bytecode.
Question 22 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
JDBC Type 2 drivers connect to the native API of the DBMS.
Question 23 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
MySQL surrogate keys are given the property AUTO_INCREMENT.
Question 24 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
A servlet is a Java program that is invoked via HTTP on the Web server.
Question 25 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Apache Web server does not support servlets.
Question 26 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
MySQL maintains metadata in the database meta_sql .
Question 27 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
The JVM (Java virtual machine) interprets Java bytecode at run time.
Question 28 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.
Question 29 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
MySQL is pronounced "my See-quel."
Question 30 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Java bytecode is machine-specific code.
Question 31 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Even though Java is machine-independent, JSPs are not.
Question 32 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
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.
Question 33 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
With JSP, the coding is done in Java and only in Java.
Question 34 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Sun defines four JDBC driver types.
Question 35 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.
Question 36 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
JSP and ASP not only look alike but their underlying technology is quite similar.
Question 37 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.
Question 38 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
JDBC Type 1 drivers are JDBC-ODBC bridge drivers.
Question 39 of 39
★ PPSC
★ FPSC
★ PPSC
★ FPSC
JDBC stands for Java Database Connectivity
✓ Link copied to clipboard
Continue Your Practice
Next Practice Set → Advanced Mapreduce Concepts — Part 1
Master the next curriculum module with 40 exam-standard MCQs.
💡 Examiner's Advisory for Computer Science & IT
In competitive commission exams (FPSC, PPSC, KPPSC, SPSC, CSS, PMS), questions are frequently phrased with distractor options designed to catch rote learners. Whenever you answer an MCQ, read the Detailed Academic Explanation and Conceptual Anchor to understand why the remaining options are incorrect.
More Modules in Computer Science & IT
View All → Advanced Mapreduce Concepts — Part 1
40 MCQs
Practice →
Advanced Mapreduce Concepts — Part 2
40 MCQs
Practice →
Advanced Sql
29 MCQs
Practice →
Advanced Trees _Avl_ Redblack_ Btrees — Part 1
40 MCQs
Practice →
Advanced Trees _Avl_ Redblack_ Btrees — Part 2
40 MCQs
Practice →
Applications Of Data Structures — Part 1
40 MCQs
Practice →