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

How many ARCn processes can be associated with an instance

  1. five

  2. four

  3. three

  4. ten


Correct Option: D

when the control file is to be created the database has to be in the

  1. mounted

  2. not mounted

  3. restricted

  4. open


Correct Option: B

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

  1. True

  2. False


Correct Option: B

In which Spec, arrays can be declared in RPG400?

  1. E

  2. I

  3. F

  4. C


Correct Option: A

How many sub-routines can be used in a RPG program?

  1. 127

  2. 194

  3. 254

  4. Unlimited


Correct Option: C
  1. SETLL

  2. SETGT

  3. Both 1 & 2

  4. Neither 1 nor 2


Correct Option: C
  1. SETLL + READP

  2. SETGT + READP

  3. SETLL + READE

  4. SETGT + READE


Correct Option: C

An operational system is which of the following?

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