databases Online Quiz - 66 Online Test

Back

databases Online Quiz - 66

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

Start the Quiz

How many ARCn processes can be associated with an instance

technology databases

five
four
three
ten

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

technology databases

mounted
not mounted
restricted
open

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

technology databases

True
False

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

technology databases

True
False

How many files can be declared in a RPG program?

technology databases

48
42
50
None of these

In which Spec, arrays can be declared in RPG400?

technology databases

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

technology databases

127
194
254
Unlimited

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

technology databases

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

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

technology databases

True
False

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

technology databases

Which opcode is used as a pointer in RPG400 programming?

technology databases

SETLL
SETGT
Both 1 & 2
Neither 1 nor 2

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

technology databases

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

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

technology databases

True
False

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.

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

Fact tables are which of the following?

technology databases

Completely normalized
Partially normalized
Completely denormalized
Partially denormalized

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.

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.

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

technology databases

%ROWTYPE
%TYPE
AS_COLUMN
None of the above

- Hide questions

databases Online Quiz - 66

AI Explanation

Find more quizzes from top tags