Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Take Free Test
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Take Free Test
JDBC, Java Server Pages, and MySQL Questions
JSP execution model basics At runtime, a JavaServer Page (JSP) is first transformed by the container into which executable server-side artifact?
JDBC driver categories and networking: In Java Database Connectivity (JDBC), which driver Types are designed for use over communications networks (for example, connecting over TCP/IP to middleware or directly to a database server)? Select the most accurate option.
JDBC driver taxonomy: According to Sun/Oracle’s classic classification, how many JDBC driver Types are defined (Type 1 through Type N)?
MySQL surrogate keys: Which column property is used in MySQL to generate surrogate key values automatically for each inserted row (monotonic integers without manual assignment)?
JavaBeans basics: Which of the following statements correctly describe a standard JavaBean used in enterprise Java (intended for property introspection and tool support)? Choose the best answer.
JDBC-ODBC bridge identification: Which JDBC driver Type corresponds to the historical JDBC-ODBC bridge (now obsolete and removed from modern JDKs)?
MySQL system metadata location: In which built-in MySQL database are system tables and metadata (for example, user accounts and privileges) stored by default?
Java servlet container history: Which servlet processor (container) was jointly developed by the Apache Software Foundation with significant collaboration from Sun, and is widely used to host servlets and JSPs?
Running compiled Java programs: To execute a compiled Java application (class files), what must be installed and running on the machine at runtime?
Open-source DBMS identification: ________ is a well-known open-source relational DBMS product that runs on UNIX, Linux, and Windows platforms and is frequently used with web applications.
JSP execution model in Tomcat: How does Apache Tomcat execute a JSP (JavaServer Page) request in its servlet container architecture?
Java History — Who Created the Java Programming Language? In the context of software history, identify the organization credited with inventing the Java programming language.
JDBC Driver Types — Suitable for Both Applets and Servlets Which JDBC driver type(s) are appropriate for use in either Java applet code running on a client machine or Java servlet code running on a web server?
Acronym Expansion — What Does JDBC Stand For? Choose the correct expansion of the acronym JDBC as used in Java data access.
Client-Side Execution — What Is Downloaded via HTTP and Runs on the User’s Computer? Identify the Java technology that is sent to the user over HTTP, launched using the HTTP protocol by the user’s environment, and executed on the user’s computer within a Java-capable container.
JSP Lifecycle — Number of In-Memory Instances How many copies (instances) of a given JSP page's generated servlet are typically kept in memory by the servlet container at one time under normal configuration?
Java Compilation Output — What Is Bytecode? Choose the description that best defines Java bytecode produced by the Java compiler.
Server-Side Execution — What Handles HTTP Requests on the Web Server? Which Java component is invoked on the web server via HTTP to process requests coming from a user’s browser?
JSP Scripting Languages — What Does JSP Support? Identify which programming or scripting languages are supported directly within JavaServer Pages (JSP) for writing embedded code.
JDBC in Three-Tier Setups — Driver Types to Use In a three-tier architecture, and assuming the web server and DBMS run on the same machine, which JDBC driver type(s) are generally suitable choices?
1
2