Question 1

Which of the following is Data Definition Language?

technology architecture

INSERT
CREATE
UPDATE
DELETE

Answer

Correct Option: B

Question 2

Which type of Statement can execute parameterized queries?

technology architecture

PreparedStatement
ParameterizedStatement
ParameterizedStatement and CallableStatement
All kinds of Statements (i.e. which implement a sub interface of Statement)

AI Explanation

AI 1

To answer this question, we need to understand the different types of statements used in SQL or database programming.

A parameterized query is a query that includes parameters, which are placeholders for values that will be provided at runtime. These parameters help in preventing SQL injection attacks and improve query performance.

Let's go through each option to understand which one can execute parameterized queries:

A) PreparedStatement - This option is correct because a PreparedStatement in Java is a type of statement that can execute parameterized queries. It allows you to create a query with placeholders for parameters and then set the values of the parameters at runtime before executing the query. This helps in reusing the same query with different parameter values.

B) ParameterizedStatement - This option is incorrect because there is no ParameterizedStatement in Java. It is not a valid type of statement.

C) ParameterizedStatement and CallableStatement - This option is incorrect because although CallableStatement is a type of statement that can execute parameterized queries, ParameterizedStatement is not a valid type of statement in Java.

D) All kinds of Statements (i.e. which implement a sub interface of Statement) - This option is incorrect because not all types of statements in Java can execute parameterized queries. Only the PreparedStatement can execute parameterized queries, while other types of statements like Statement and CallableStatement do not support parameterized queries by default.

The correct answer is option A) PreparedStatement. This option is correct because a PreparedStatement is specifically designed to execute parameterized queries.

Answer

Correct Option: A

Question 3

Which packages contain the JDBC classes?

technology architecture

java.jdbc and javax.jdbc
java.jdbc and java.jdbc.sql
java.sql and javax.sql
java.rdb and javax.rdb

Answer

Correct Option: C

Question 4

Which of the following are true ?

technology architecture

The executeUpdate method returns all the rows that were affected
The executeUpdate method returns the no. of rows that were affected
Depends , as there is more than one version of this method with different return types
None

Answer

Correct Option: B

Question 5

Which of the following is false wrt Transactions ?

technology architecture

A transaction is a set of sql statements
Auto commit to be set off before Transaction
Auto commit to be set off after transaction
Commit permanently records to database all changes waiting with current Connection
Rollback is used in case of any error to undo transaction

Answer

Correct Option: C

Question 6

public class NumbPlay { int x=5; public static void main(String[] args) { new NumbPlay().doPlay(); } void doPlay() { int x; System.out.println(++x); } } The output is

technology architecture

5
6
Compile error
Runtime error

Answer

Correct Option: C

Question 7

try {int x = Integer.parseInt(“one”);} Which of the following could be used to create appropriate catch block ?

technology architecture

ClassCastException
IllegalStateException
NumberFormatException
None

Answer

Correct Option: C

Question 8

Which of the following method names follow the JavaBeans standard ?

technology architecture

addSize
getCust
deleteRep
putDimensions

Answer

Correct Option: B

Question 9

What are the life-cycle methods of JSP?

technology architecture

jspInit(), _jspService() & jspDestroy()
init(), service(), destroy()
doPost()
none of the above

Answer

Correct Option: A

Question 10

What do you understand by JSP translation?

technology architecture

Parsing JSP using an XML Parser.
Converting JSP into static Html content.
Generating Servlet Code for the Jsp
None

Answer

Correct Option: C

Question 11

What are the J2EE clients from the below list?

technology architecture

Applets
Web Browsers
Wireless clients.
All the above

Answer

Correct Option: D

Question 12

Can we have pure java code inside JSP

technology architecture

True
False

Answer

Correct Option: A

Question 13

Every Custom Servlet extends javax.servlet.http.HttpServlet class

technology architecture

True
False

Answer

Correct Option: A

Question 14

Web container translates JSP to Servlet for every request of the JSP

technology architecture

True
False

Answer

Correct Option: B

Question 15

A JSP page can include another JSP page but not an HTML page

technology architecture

True
False

Answer

Correct Option: B

Question 16

What are the different scopes available?

technology architecture

page, request & session
page, request & application.
page, request, session & application
request, session & application.

Answer

Correct Option: C

Question 17

Which are implicit objects in a JSP?

technology architecture

only request, response
only request, response & application
request, response, session & application
None

Answer

Correct Option: C

Question 18

Difference between GET & POST method. (Choose the right answer)

technology architecture

Query length is limited in POST, not limited in GET.
POST is secured whereas data is been submitted as part of URL in GET (not secured).
By using POST method, we cannot submit the form.
None

Answer

Correct Option: B

Question 19

A servlet instance (object) is created during the execution of JSP.

technology architecture

True
False

Answer

Correct Option: A

Question 20

A servlet can handle multiple requests concurrently.

technology architecture

True
False

Answer

Correct Option: A

Description: architecture Online Quiz - 16
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: architecture

architecture Online Quiz - 16

AI Explanation

Find more quizzes from top tags