Database Systems - Section 1

1.

If a calculation is embedded in a form

A.	the result of the calculations are stored with the form
B.	the calculations are stored with the form
C.	the result of the calculations are printed in report
D.	All of the above
E.	None of the above

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

2.

The Management Information system (MIS) structure with one main computer system is called a

A.	hierarchical MIS structure
B.	distributed MIS structure
C.	centralized MIS structure
D.	decentralized MIS structure
E.	None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

3.

If you want to group the records in the abc database, you could use the Jobcode as the _____.

A.	Delete
B.	Update
C.	Sort Key
D.	Index
E.	None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

4.

A number of related records that are treated as a unit is called

A.	file
B.	field
C.	data
D.	batch
E.	None of the above

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

5.

In SQL, which command is used to add new rows to a table?

A.	ALTER TABLE
B.	ADD ROW
C.	INSERT
D.	APPEND
E.	None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

6.

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

A.	the pin code
B.	the last name
C.	a compound key consisting of the first name and the last name
D.	All of the above
E.	None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

7.

The main idea behind computer files is that it is convenient to

A.	arrange them
B.	store information together
C.	create them
D.	access them
E.	None of the above

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

8.

When you have finished entering information into a form

A.	the template is written to the data file
B.	the contents of the form are written to the data file
C.	the contents of the form can be printed
D.	All of the above
E.	None of the above

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

1
2
3
4
5
6