Skip to main content

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
Question 1 of 39
★ PPSC ★ FPSC

How many JDBC driver types does Sun define?

Question 2 of 39
★ PPSC ★ FPSC

Where is metadata stored in MySQL?

Question 3 of 39
★ PPSC ★ FPSC

Who invented Java?

Question 4 of 39
★ PPSC ★ FPSC

To run a compiled Java program, the machine must have what loaded and running?

Question 5 of 39
★ PPSC ★ FPSC

Which JDBC driver Type(s) can be used in either applet or servlet code?

Question 6 of 39
★ PPSC ★ FPSC

________ is an open source DBMS product that runs on UNIX, Linux and Windows.

Question 7 of 39
★ 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

What MySQL property is used to create a surrogate key in MySQL?

Question 9 of 39
★ PPSC ★ FPSC

What is not true of a Java bean?

Question 10 of 39
★ PPSC ★ FPSC

A JSP is transformed into a(n):

Question 11 of 39
★ 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

What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?

Question 13 of 39
★ PPSC ★ FPSC

What servlet processor was developed by Apache Foundation and Sun?

Question 14 of 39
★ PPSC ★ FPSC

What is bytecode?

Question 15 of 39
★ 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

Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

Question 17 of 39
★ PPSC ★ FPSC

How many copies of a JSP page can be in memory at a time?

Question 18 of 39
★ PPSC ★ FPSC

Which JDBC driver Types are for use over communications networks?

Question 19 of 39
★ PPSC ★ FPSC

How does Tomcat execute a JSP?

Question 20 of 39
★ PPSC ★ FPSC

MySQL is just as powerful as Oracle and is half the price.

Question 21 of 39
★ PPSC ★ FPSC

Java programs are compiled into bytecode.

Question 22 of 39
★ PPSC ★ FPSC

JDBC Type 2 drivers connect to the native API of the DBMS.

Question 23 of 39
★ PPSC ★ FPSC

MySQL surrogate keys are given the property AUTO_INCREMENT.

Question 24 of 39
★ PPSC ★ FPSC

A servlet is a Java program that is invoked via HTTP on the Web server.

Question 25 of 39
★ PPSC ★ FPSC

Apache Web server does not support servlets.

Question 26 of 39
★ PPSC ★ FPSC

MySQL maintains metadata in the database meta_sql .

Question 27 of 39
★ PPSC ★ FPSC

The JVM (Java virtual machine) interprets Java bytecode at run time.

Question 28 of 39
★ 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

MySQL is pronounced "my See-quel."

Question 30 of 39
★ PPSC ★ FPSC

Java bytecode is machine-specific code.

Question 31 of 39
★ PPSC ★ FPSC

Even though Java is machine-independent, JSPs are not.

Question 32 of 39
★ 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

With JSP, the coding is done in Java and only in Java.

Question 34 of 39
★ PPSC ★ FPSC

Sun defines four JDBC driver types.

Question 35 of 39
★ 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

JSP and ASP not only look alike but their underlying technology is quite similar.

Question 37 of 39
★ PPSC ★ FPSC

Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.

Question 38 of 39
★ PPSC ★ FPSC

JDBC Type 1 drivers are JDBC-ODBC bridge drivers.

Question 39 of 39
★ PPSC ★ FPSC

JDBC stands for Java Database Connectivity

✓ Link copied to clipboard
Continue Your Practice

Advanced Mapreduce Concepts — Part 1

Master the next curriculum module with 40 exam-standard MCQs.

Next Practice Set →

💡 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 →
📚

Study Guides

Topic summaries and syllabus breakdown

Explore Guides →
🎯

Complete Library

Search through 78,000+ verified MCQs

Browse Library →
📱

Mobile App

Offline mock tests and instant bookmarks

Get Mobile App →