BEC - Data Structures, Software, and Databases

Question 1

Which of the following is not a category of computer software?
A. System software.
B. Programming languages.
C. Application software.
D. All of the above are categories of computer software.

Answer 1

A, B, and C are all categories of computer software. Because of this, the correct answer is D - all of the above.

Question 2

The following customer data is stored in the sales processing system to a regional produce distributor:

CustomerNumber, CustomerName, CustomerPhone, CustomerContact, CustomerCreditLimit

Which of the following is true?

A. 	CustomerNumber is an example of a field.
B. 	CustomerNumber is an example of a data value.
C. 	CustomerNumber is an example of a record
D. 	All of the above are true.

Answer 2

A. CustomerNumber is an example of a field.

CustomerNumber is an example of a field (also known as an attribute).

Question 3

Data value

Answer 3

a specific value found in a field, for example 8047 or 394837.

Question 4

Record

Answer 4

A record is a collection of fields that describe an individual instance of an entity.

The entire list of fields (e.g. CustomerNumber, CustomerName, CustomerPhone, CustomerContact, CustomerCreditLimit) could constitute a record.

Question 5

Which of the following components of a database is responsible for maintaining the referential integrity of the data in the system?

A. 	Database management system (DBMS)
B. 	Data query language (DQL).
C. 	Data manipulation language (DML).
D. 	Data definition language (DDL).

Answer 5

A. Database management system (DBMS)

The database management system (DBMS) controls the storage and retrieval of the information maintained in a database and is responsible for maintaining the referential integrity of the data.

Question 6

database management system (DBMS)

Answer 6

controls the storage and retrieval of the information maintained in a database and is responsible for maintaining the referential integrity of the data.

Question 7

Data query language (DQL)

Answer 7

used to extract information from the database

Question 8

Data manipulation language (DML)

Answer 8

used to add, update, and delete data.

Question 9

Data definition language (DDL)

Answer 9

used to create tables and fields of information within the fields.

Question 10

Structured query language

Answer 10

a specific, commonly used language that permits the user to extract information from the database

Question 11

Database management software is considered:
	A. 	Outerwear.
	B. 	Software.
	C. 	Middleware
	D. 	B and C.

Answer 11

D. B and C

Question 12

What is the correct ascending hierarchy of data in a system?

A. 	 Character, record, file, field.

B. 	 Field, character, file, record.

C. 	 Character, field, record, file.

D. 	 Field, record, file, character.

Answer 12

C. Character, field, record, file

Specifically, a character has fewer pieces of data than does a field. A field has fewer pieces of data than does a record. And a record has fewer pieces of data than does a file.

Question 13

Which of the following structures refers to the collection of data for all vendors in a relational data base?

A. 	Record.
B. 	Field.
C. 	File.
D. 	Byte.

Answer 13

C. File

A file would contain the collection of data for all vendors in a relational database. This would also be called a table in a relational database. Therefore, this is the best answer.

Question 14

Which of the following items would be most critical to include in a systems specification document for a financial report?

A. Cost-benefit analysis.

B.  Data elements needed.

C. Training requirements.

D. Communication change management considerations.

Answer 14

B. Data elements needed.

Specifying the required data elements would be a critical activity in determining the attributes of a document in a financial reporting system.