0

databases Online Quiz - 66

Description: databases Online Quiz - 66
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

for secondary index data bases do we no need to have separate PSB

  1. True

  2. False


Correct Option: B

How many files can be declared in a RPG program?

  1. 48

  2. 42

  3. 50

  4. None of these


Correct Option: C

How many printer files can be declared in a RPG program to the maximum?

  1. 6

  2. 8

  3. 10

  4. 12


Correct Option: B

How many arrays can be declared to the maximum in a RPG program?

  1. 50

  2. 100

  3. 150

  4. 200


Correct Option: D
  1. SETLL

  2. SETGT

  3. Both 1 & 2

  4. Neither 1 nor 2


Correct Option: C

CHAIN operation does the same function of which of the following combination?

  1. SETLL + READP

  2. SETGT + READP

  3. SETLL + READE

  4. SETGT + READE


Correct Option: C
  1. A system that is used to run the business in real time and is based on historical data.

  2. A system that is used to run the business in real time and is based on current data.

  3. A system that is used to support decision making and is based on current data.

  4. system that is used to support decision making and is based on historical data.


Correct Option: B

A star schema has what type of relationship between a dimension and fact table?

  1. Many-to-many

  2. One-to-one

  3. One-to-many

  4. All of the above


Correct Option: C
  1. Completely normalized

  2. Partially normalized

  3. Completely denormalized

  4. Partially denormalized


Correct Option: A

Reconciled data is which of the following?

  1. Data stored in the various operational systems throughout the organization.

  2. Current data intended to be the single source for all decision support systems.

  3. Data stored in one operational system in the organization.

  4. Data that has been selected and formatted for end-user support applications.


Correct Option: B

A data warehouse is which of the following?

  1. Can be updated by end users

  2. Contains numerous naming conventions and formats

  3. Organized around important subject areas.

  4. Contains only current data.


Correct Option: C
- Hide questions