0

databases Online Quiz - 51

Description: databases Online Quiz - 51
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. GenericServlet

  2. HttpServlet

  3. Both (A) and (B)

  4. None of the Above


Correct Option: C
  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.


Correct Option: A
  1. TCP

  2. Http

  3. MSMQ

  4. All of the Above


Correct Option: D
  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


Correct Option: A
  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.


Correct Option: C

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

  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.


Correct Option: D
  1. cookies

  2. hidden form fields

  3. SSL sessions

  4. All of the above


Correct Option: D
  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


Correct Option: B

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

  1. PSBLIB

  2. DBDLIB

  3. ACBLIB

  4. USERLIB


Correct Option: D

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

  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


Correct Option: D
  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


Correct Option: B
  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.


Correct Option: B

What best describes the relationship between indexes and SQL performance?

  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.


Correct Option: D
- Hide questions