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

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

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

When a record is deleted in a Logical file, it will affect its Physical file.

  1. True

  2. False


Correct Option: A

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

  1. 50

  2. 100

  3. 150

  4. 200


Correct Option: D

Which opcode is used as a pointer in RPG400 programming?

  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

For a CHAIN operation, when a record is found, the indicator would be set OFF.

  1. True

  2. False


Correct Option: A

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

Fact tables are which of the following?

  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