• databases Online Quiz - 51
Back
0

databases Online Quiz - 51

Description: databases Online Quiz - 51
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which of the following denote the type of servlet?
technology databases

  1. GenericServlet

  2. HttpServlet

  3. Both (A) and (B)

  4. None of the Above

Show answer
Correct Option: C

Consider the following piece of code byte x = 0; x += 1;
technology databases

  1. Results in x having the value 1.

  2. Causes a compiler error.

  3. Will require a cast (byte) before 1.

  4. Will give syntax error.

Show answer
Correct Option: A

What is the base type of the array given below? Color[] example = new Color[20];
technology databases

  1. Color

  2. example

  3. No base type

  4. Both (A) and (B)

Show answer
Correct Option: A

Protocols supported by WCF
technology databases

  1. TCP

  2. Http

  3. MSMQ

  4. All of the Above

Show answer
Correct Option: D

You are creating a method which returns a type that is compatible with the Foreach statement. Which criteria should the method meet?
technology databases

  1. The method must return a type of either IEnumerator or Ienumerable

  2. The method must return a type of IComparable

  3. The method must explicitly contain a collection

  4. A and B

Show answer
Correct Option: A

Which of the following setting deny anonymous access to a Web application?
technology databases

  1. A.

  2. B.

  3. C. < deny users=”*”/>

  4. D.

Show answer
Correct Option: B

What is the initial contact point for handling a web request in a Page-Centric architecture?
technology databases

  1. JSP Page

  2. Java bean

  3. Servlet

  4. Session manager

Show answer
Correct Option: A

Which one of the following function cannot be used with IMS database CALLs?
technology databases

  1. GHU

  2. DELT

  3. ISRT

  4. CHNG

Show answer
Correct Option: D

What is the maximum no. of PCBs that can be defined in a PSB?
technology databases

  1. 255

  2. 1000

  3. 256

  4. 15

Show answer
Correct Option: A

Which one of the following DLI call statements is incorrect?

technology databases

  1. CALL ‘CBLTDLI’ USING PARM-COUNT, FUNC-CODE, DB-PCB-MASK, IO-AREA, SSA-LIST.

  2. CALL ‘CBLTDLI’ USING FUNC-CODE, DB-PCB-MASK, IO-AREA.

  3. CALL ‘CBLTDLI’ USING FUNC-CODE, DB-PCB-MASK, SSA-LIST.

  4. CALL ‘CBLTDLI’ USING FUNC-CODE, DB-PCB-MASK, IO-AREA, SSA-LIST.

Show answer
Correct Option: C

Command to execute a compiled java programs is

technology databases

  1. run

  2. execute

  3. javac

  4. java

Show answer
Correct Option: D

How can you ensure that the memory allocated by an object is freed?

technology databases

  1. By invoking the free method on the object

  2. By calling system.gc() method

  3. By setting all references to the object to new values (say null).

  4. Garbage collection cannot be forced. The programmer cannot force the JVM to free the memory used by an object.

Show answer
Correct Option: D

In order to use a servlet for handling the submission of a web form, subclass HttpServlet() and put service code in service() method
technology databases

  1. doGet() or doPost() method

  2. getServletInfo() method

  3. All of the above

  4. none of the above

Show answer
Correct Option: A

Which of the following denote the Mechanism for Session Tracking?
technology databases

  1. cookies

  2. hidden form fields

  3. SSL sessions

  4. All of the above

Show answer
Correct Option: D

Which one of the following statements about a IMS-DB2 BATCH DLI program is False?
technology databases

  1. IMS act as the resource manager when DB2 program is invoked from IMS

  2. Commits and rollbacks are performed using COMMIT and ROLLBACK Commands

  3. DB2 can be invoked from IMS using IMS-DB2 attachment facility

  4. DB2 Subsystem and plan name are DSNMTV01 in DD

Show answer
Correct Option: B

Which one of the following library type is used in DLI jobs to dynamically allocate database clusters?

technology databases

  1. PSBLIB

  2. DBDLIB

  3. ACBLIB

  4. USERLIB

Show answer
Correct Option: D

Which of the following is an important consideration when tuning an SQL statement?

technology databases

  1. The number of CPUs on the server

  2. The degree of parallelism on the tables

  3. The use of bitmap indexes

  4. The quality of the SQL optimization

Show answer
Correct Option: D

Which of the following database design features is most important to SQL performance?

technology databases

  1. Removal of data redundancy

  2. The introduction of data redundancy

  3. The introduction of non-first normal form relations

  4. The introduction of SQL*Plus

Show answer
Correct Option: B

Why is searching for large-table full-table scans critical to SQL tuning?

technology databases

  1. They indicate an optimized execution plan.

  2. They may be able to be tuned to use an index

  3. The full-table scan should be normalized from the database design

  4. A full-table scan is always sub-optimal.

Show answer
Correct Option: B

What best describes the relationship between indexes and SQL performance?
technology databases

  1. Indexes are only used in special cases

  2. Indexes are used to make table storage more efficient

  3. Indexes rarely make a difference in SQL performance

  4. Indexes exist solely to improve query speed.

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions