COSC FINAL PRACTICE EXAM
QUESTIONS AND ANSWERS7
A field that uniquely identifies each record. - ANSWERS-primary key
This subsystem defines the logical structure of the database by using a data dictionary or
schema. - ANSWERS-data definition
The combined information presented on this type of database can be used to change the whole
merchandising strategy of a store. - ANSWERS-company
C++ is a procedural language that is widely used by today's programmers. - ANSWERS-true
Which of the following refers to tools that are used to provide some assistance in designing,
coding, and testing software? - ANSWERS-CASE
CASE tools are used to compile programs to test for logic errors. - ANSWERS-false
Coding is only one of the six steps of programming. - ANSWERS-true
The program's objectives, outputs, inputs, and processing requirements are determined during
in this step. - ANSWERS-Program specification
Which view of data deals with how the data is actually formatted and located? - ANSWERS-
physical view
, If all the data in a database is not physically located in one place, it would be a(n) _______
database. - ANSWERS-distributed
Querying the database and generating reports is assisted by the application generation
subsystem. - ANSWERS-false
The ATM works on the principle of real-time processing. - ANSWERS-true
Data consists of only numbers, letters, and symbols. - ANSWERS-false
A commercial database is generally an enormous database that an organization develops to
cover particular subjects. - ANSWERS-true
The logical arrangement of data in a database is called the database model. - ANSWERS-true
Information collected by an organization from a variety of external and internal databases is
stored in this special type of database. - ANSWERS-data warehouse
The company database may be stored on a central database server and managed by a database
administrator. - ANSWERS-true
In this subsystem, a user can create data entry forms. - ANSWERS-application generation
Which of the following is not an advantage of using a database? - ANSWERS-reliability
Database tables can be related or connected to other tables by common key fields. - ANSWERS-
true
QUESTIONS AND ANSWERS7
A field that uniquely identifies each record. - ANSWERS-primary key
This subsystem defines the logical structure of the database by using a data dictionary or
schema. - ANSWERS-data definition
The combined information presented on this type of database can be used to change the whole
merchandising strategy of a store. - ANSWERS-company
C++ is a procedural language that is widely used by today's programmers. - ANSWERS-true
Which of the following refers to tools that are used to provide some assistance in designing,
coding, and testing software? - ANSWERS-CASE
CASE tools are used to compile programs to test for logic errors. - ANSWERS-false
Coding is only one of the six steps of programming. - ANSWERS-true
The program's objectives, outputs, inputs, and processing requirements are determined during
in this step. - ANSWERS-Program specification
Which view of data deals with how the data is actually formatted and located? - ANSWERS-
physical view
, If all the data in a database is not physically located in one place, it would be a(n) _______
database. - ANSWERS-distributed
Querying the database and generating reports is assisted by the application generation
subsystem. - ANSWERS-false
The ATM works on the principle of real-time processing. - ANSWERS-true
Data consists of only numbers, letters, and symbols. - ANSWERS-false
A commercial database is generally an enormous database that an organization develops to
cover particular subjects. - ANSWERS-true
The logical arrangement of data in a database is called the database model. - ANSWERS-true
Information collected by an organization from a variety of external and internal databases is
stored in this special type of database. - ANSWERS-data warehouse
The company database may be stored on a central database server and managed by a database
administrator. - ANSWERS-true
In this subsystem, a user can create data entry forms. - ANSWERS-application generation
Which of the following is not an advantage of using a database? - ANSWERS-reliability
Database tables can be related or connected to other tables by common key fields. - ANSWERS-
true
