Question 1

How many ARCn processes can be associated with an instance

technology databases

five
four
three
ten

Answer

Correct Option: D

Question 2

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

technology databases

mounted
not mounted
restricted
open

Answer

Correct Option: B

Question 3

do you get return code GE in GN call in IMS call ?

technology databases

True
False

Answer

Correct Option: B

Question 4

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

technology databases

True
False

Answer

Correct Option: B

Question 5

How many files can be declared in a RPG program?

technology databases

48
42
50
None of these

Answer

Correct Option: C

Question 6

In which Spec, arrays can be declared in RPG400?

technology databases

E
I
F
C

Answer

Correct Option: A

Question 7

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

technology databases

127
194
254
Unlimited

Answer

Correct Option: C

Question 8

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

technology databases

6
8
10
12

Answer

Correct Option: B

Question 9

Which opcode is used to add a new field to a Physical file without deleting its records?

technology databases

CRTPF
CHGPFM
CHGPF
Can't be done so

Answer

Correct Option: C

Question 10

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

technology databases

True
False

Answer

Correct Option: A

Question 11

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

technology databases

50
100
150
200

Answer

Correct Option: D

Question 12

Which opcode is used as a pointer in RPG400 programming?

technology databases

SETLL
SETGT
Both 1 & 2
Neither 1 nor 2

Answer

Correct Option: C

Question 13

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

technology databases

SETLL + READP
SETGT + READP
SETLL + READE
SETGT + READE

Answer

Correct Option: C

Question 14

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

technology databases

True
False

Answer

Correct Option: A

Question 15

An operational system is which of the following?

technology databases

A system that is used to run the business in real time and is based on historical data.
A system that is used to run the business in real time and is based on current data.
A system that is used to support decision making and is based on current data.
system that is used to support decision making and is based on historical data.

Answer

Correct Option: B

Question 16

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

technology databases

Many-to-many
One-to-one
One-to-many
All of the above

Answer

Correct Option: C

Question 17

Fact tables are which of the following?

technology databases

Completely normalized
Partially normalized
Completely denormalized
Partially denormalized

Answer

Correct Option: A

Question 18

Reconciled data is which of the following?

technology databases

Data stored in the various operational systems throughout the organization.
Current data intended to be the single source for all decision support systems.
Data stored in one operational system in the organization.
Data that has been selected and formatted for end-user support applications.

Answer

Correct Option: B

Question 19

A data warehouse is which of the following?

technology databases

Can be updated by end users
Contains numerous naming conventions and formats
Organized around important subject areas.
Contains only current data.

Answer

Correct Option: C

Question 20

The __________ attribute is used to declare variables based on definitions of columns in table.

technology databases

%ROWTYPE
%TYPE
AS_COLUMN
None of the above

Answer

Correct Option: B

Description: databases Online Quiz - 66
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 66

Find more quizzes from top tags