JDBC MCQ

Test your knowledge with important JDBC MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more JDBC MCQs at Bissoy

• JDBC stands for Java Database Connectivity
  ক

  True

  খ

  False
• JDBC Type 1 drivers are JDBC-ODBC bridge drivers.
  ক

  True

  খ

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

  True

  খ

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

  True

  খ

  False
• Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.
  ক

  True

  খ

  False
• Sun defines four JDBC driver types.
  ক

  True

  খ

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

  True

  খ

  False
• 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.
  ক

  True

  খ

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

  True

  খ

  False
• Java bytecode is machine-specific code.
  ক

  True

  খ

  False
• MySQL is pronounced "my See-quel."
  ক

  True

  খ

  False
• JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.
  ক

  True

  খ

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

  True

  খ

  False
• MySQL maintains metadata in the database <em>meta_sql</em>.
  ক

  True

  খ

  False
• Apache Web server does not support servlets.
  ক

  True

  খ

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

  True

  খ

  False
• MySQL surrogate keys are given the property AUTO_INCREMENT.
  ক

  True

  খ

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

  True

  খ

  False
• Java programs are compiled into bytecode.
  ক

  True

  খ

  False
• MySQL is just as powerful as Oracle and is half the price.
  ক

  True

  খ

  False
• How does Tomcat execute a JSP?
  ক

  As a CGI script

  খ

  As an independent process

  গ

  By one of Tomcat's threads

  ঘ

  None of the above is correct
• JDBC stands for:
  ক

  Java Database Connectivity

  খ

  Java Database Components

  গ

  Java Database Control

  ঘ

  None of the above is correct
• Which JDBC driver Types are for use over communications networks?
  ক

  Type 3 only

  খ

  Type 4 only

  গ

  Both Type 3 and Type 4

  ঘ

  Neither Type 3 nor Type 4
• How many copies of a JSP page can be in memory at a time?
  ক

  One

  খ

  Two

  গ

  Three

  ঘ

  Unlimited
• What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
  ক

  A Java application

  খ

  A Java applet

  গ

  A Java servlet

  ঘ

  None of the above is correct
• What servlet processor was developed by Apache Foundation and Sun?
  ক

  Apache Tomcat

  খ

  Apache Web server

  গ

  Sun servlet processor

  ঘ

  None of the above is correct
• 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?
  ক

  Type 1 only

  খ

  Type 2 only

  গ

  Both Type 3 and Type 4

  ঘ

  All of Type 1, Type 2, Type 3 and Type 4
• What is not true of a Java bean?
  ক

  There are no public instance variables.

  খ

  All persistent values are accessed using get<em>xxx</em> and set<em>xxx</em> methods.

  গ

  It may have many constructors as necessary.

  ঘ

  All of the above are true of a Java bean.
• 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 Java application

  খ

  A Java applet

  গ

  A Java servlet

  ঘ

  None of the above is correct
• To run a compiled Java program, the machine must have what loaded and running?
  ক

  Java virtual machine

  খ

  Java compiler

  গ

  Java bytecode

  ঘ

  A Web browser