COSC 1301 Exam 4 Study Guide with
Complete Solutions
A collection of related fields such as a person's name, address, and age. - ANSWER-
Record
A condition must be met before a sequential structure can proceed to the next
statement. - ANSWER-False
A field that uniquely identifies each record. - ANSWER-Primary key
A programming language uses symbols, words, and phrases to instruct a computer to
perform specific operations. - ANSWER-True
An information system is a collection of hardware, software, people, procedures, and: -
ANSWER-data
Analysis tools that support viewing all or selected parts of data, querying the database,
and generating reports include query-by-example as well as specialized programming
language called _______. - ANSWER-SQL
C++ is a procedural language that is widely used by today's programmers. - ANSWER-
True
Data consists of only numbers, letters, and symbols. - ANSWER-False
Data redundancy can occur due to lack of data integrity. - ANSWER-True
Database tables can be related or connected to other tables by common key fields. -
ANSWER-True
For an attempt at translation to work as a form of the testing process, the program must
be free of logic errors to be able to run. - ANSWER-False
Having several instances of the same data is called data _______. - ANSWER-
redundancy
How many phases are there in the systems life cycle? - ANSWER-six
If all the data in a database is not physically located in one place, it would be a(n)
_______ database. - ANSWER-distributed
If Mr. Smith's bike has been sent to his new address, but the bill to his old one, it can
most likely be attributed to a lack of data _______. - ANSWER-integrity
Complete Solutions
A collection of related fields such as a person's name, address, and age. - ANSWER-
Record
A condition must be met before a sequential structure can proceed to the next
statement. - ANSWER-False
A field that uniquely identifies each record. - ANSWER-Primary key
A programming language uses symbols, words, and phrases to instruct a computer to
perform specific operations. - ANSWER-True
An information system is a collection of hardware, software, people, procedures, and: -
ANSWER-data
Analysis tools that support viewing all or selected parts of data, querying the database,
and generating reports include query-by-example as well as specialized programming
language called _______. - ANSWER-SQL
C++ is a procedural language that is widely used by today's programmers. - ANSWER-
True
Data consists of only numbers, letters, and symbols. - ANSWER-False
Data redundancy can occur due to lack of data integrity. - ANSWER-True
Database tables can be related or connected to other tables by common key fields. -
ANSWER-True
For an attempt at translation to work as a form of the testing process, the program must
be free of logic errors to be able to run. - ANSWER-False
Having several instances of the same data is called data _______. - ANSWER-
redundancy
How many phases are there in the systems life cycle? - ANSWER-six
If all the data in a database is not physically located in one place, it would be a(n)
_______ database. - ANSWER-distributed
If Mr. Smith's bike has been sent to his new address, but the bill to his old one, it can
most likely be attributed to a lack of data _______. - ANSWER-integrity