JDBC, Java Server Pages, and MySQL Questions and Answers

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

Correct answer: FalseThe two languages differ in memory management, in object model and in calling conventions, so Java cannot call a C library directly and a driver or a native interface layer is required. This is exactly why the JDBC driver types exist: Types 1 and 2 bridge to native code, and Types 3 and 4 avoid it altogether.

Q: Java programs are compiled into bytecode.

Correct answer: TrueThe Java compiler produces bytecode, the instruction set of the virtual machine, rather than machine code for a particular processor. That intermediate form is what a JVM reads and executes, and it is why one compiled file runs on any platform with a JVM.

Q: Java bytecode is machine-specific code.

Correct answer: FalseBytecode is machine-independent: it is the instruction set of the virtual machine rather than of any processor, which is what allows one compiled file to run wherever a JVM exists. Machine-specific code is what the JVM produces internally, or what a conventional compiler emits.

Q: MySQL maintains metadata in the database meta_sql.

Correct answer: FalseThe database is called mysql, not meta_sql. It holds the server’s own catalogue - users, privileges and configuration - and can be queried like any other database, though privileges are normally changed through GRANT rather than by writing to its tables.

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

Correct answer: MySQLMySQL is the open source relational DBMS that runs on Unix, Linux and Windows alike, and it is the database half of the LAMP stack. Its portability comes from the same source as Java’s: the server is built for each platform while the SQL and the client protocol stay the same.

Q: How many JDBC driver types does Sun define?

Correct answer: FourSun defines four types. Type 1 is the JDBC-ODBC bridge; Type 2 calls the DBMS’s own native API through a client library; Type 3 talks to a middleware server in a network protocol; and Type 4 is pure Java speaking the DBMS protocol directly. The numbering runs from most dependent on native code to least.

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

Correct answer: TrueThis is what the virtual machine is for. The compiler produces bytecode, which no processor can execute, and the JVM reads and executes it at run time. Modern implementations compile hot paths to native code as they run, but the essential arrangement is unchanged: the bytecode is portable and the JVM is what makes it executable.

Q: 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?

Correct answer: A Java appletAn applet is bytecode downloaded to the browser over HTTP and executed on the user’s machine within the JVM the browser provides. A servlet is the counterpart running on the server, and an ordinary Java application is launched locally and involves no HTTP at all.

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

Correct answer: FalseJSPs are as portable as anything else in Java. They are translated into servlets, compiled to bytecode and run on the JVM, so a page written for one container on one platform will run on another. The machine independence of Java extends to everything built on it.

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

Correct answer: Java onlyA JSP page mixes HTML with Java, and Java is the only language its scriptlets and expressions may be written in. This is one of the real differences from ASP, which supports VBScript and JScript - the two look alike on the page but rest on quite different technology underneath.

31.

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: B

Correct answer: False

The two languages differ in memory management, in object model and in calling conventions, so Java cannot call a C library directly and a driver or a native interface layer is required. This is exactly why the JDBC driver types exist: Types 1 and 2 bridge to native code, and Types 3 and 4 avoid it altogether.

Discuss in Forum

32.

Java programs are compiled into bytecode.

A.True
B.False

Answer: A

Correct answer: True

The Java compiler produces bytecode, the instruction set of the virtual machine, rather than machine code for a particular processor. That intermediate form is what a JVM reads and executes, and it is why one compiled file runs on any platform with a JVM.

Discuss in Forum

33.

Java bytecode is machine-specific code.

A.True
B.False

Answer: B

Correct answer: False

Bytecode is machine-independent: it is the instruction set of the virtual machine rather than of any processor, which is what allows one compiled file to run wherever a JVM exists. Machine-specific code is what the JVM produces internally, or what a conventional compiler emits.

Discuss in Forum

34.

MySQL maintains metadata in the database meta_sql.

A.True
B.False

Answer: B

Correct answer: False

The database is called mysql, not meta_sql. It holds the server’s own catalogue - users, privileges and configuration - and can be queried like any other database, though privileges are normally changed through GRANT rather than by writing to its tables.

Discuss in Forum

35.

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

A.MySQL
B.JSP/SQL
C.JDBC/SQL
D.Sun ACCESS

Answer: A

Correct answer: MySQL

MySQL is the open source relational DBMS that runs on Unix, Linux and Windows alike, and it is the database half of the LAMP stack. Its portability comes from the same source as Java’s: the server is built for each platform while the SQL and the client protocol stay the same.

Discuss in Forum

36.

How many JDBC driver types does Sun define?

A.One
B.Two
C.Three
D.Four

Answer: D

Correct answer: Four

Sun defines four types. Type 1 is the JDBC-ODBC bridge; Type 2 calls the DBMS’s own native API through a client library; Type 3 talks to a middleware server in a network protocol; and Type 4 is pure Java speaking the DBMS protocol directly. The numbering runs from most dependent on native code to least.

Discuss in Forum

37.

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

A.True
B.False

Answer: B

Correct answer: True

This is what the virtual machine is for. The compiler produces bytecode, which no processor can execute, and the JVM reads and executes it at run time. Modern implementations compile hot paths to native code as they run, but the essential arrangement is unchanged: the bytecode is portable and the JVM is what makes it executable.

Discuss in Forum

38.

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.A Java application
B.A Java applet
C.A Java servlet
D.None of the above is correct.

Answer: B

Correct answer: A Java applet

An applet is bytecode downloaded to the browser over HTTP and executed on the user’s machine within the JVM the browser provides. A servlet is the counterpart running on the server, and an ordinary Java application is launched locally and involves no HTTP at all.

Discuss in Forum

39.

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

A.True
B.False

Answer: B

Correct answer: False

JSPs are as portable as anything else in Java. They are translated into servlets, compiled to bytecode and run on the JVM, so a page written for one container on one platform will run on another. The machine independence of Java extends to everything built on it.

Discuss in Forum

40.

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

A.VBScript only
B.Jscript only
C.Java only
D.All of the above are supported

Answer: C

Correct answer: Java only

A JSP page mixes HTML with Java, and Java is the only language its scriptlets and expressions may be written in. This is one of the real differences from ASP, which supports VBScript and JScript - the two look alike on the page but rest on quite different technology underneath.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: JDBC, Java Server Pages, and MySQL Questions and Answers || JDBC, Java Server Pages, and MySQL MCQ Questions and Answers || JDBC, Java Server Pages, and MySQL GK Questions and Answers || JDBC, Java Server Pages, and MySQL GK MCQ Questions || JDBC, Java Server Pages, and MySQL Multiple Choice Questions and Answers || JDBC, Java Server Pages, and MySQL GK || GK on JDBC, Java Server Pages, and MySQL || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

JDBC, Java Server Pages, and MySQL Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications