COSC FINAL PRACTICE EXAM WITH QUESTIONS AND ANSWERS
LATEST UPDATE 2026
Which view of data deals with how the data is actually formatted and located? - (answer)physical view
If all the data in a database is not physically located in one place, it would be a(n) _______ database. -
(answer)distributed
Querying the database and generating reports is assisted by the application generation subsystem. -
(answer)false
The ATM works on the principle of real-time processing. - (answer)true
Data consists of only numbers, letters, and symbols. - (answer)false
A commercial database is generally an enormous database that an organization develops to cover
particular subjects. - (answer)true
The logical arrangement of data in a database is called the database model. - (answer)true
Information collected by an organization from a variety of external and internal databases is stored in
this special type of database. - (answer)data warehouse
The company database may be stored on a central database server and managed by a database
administrator. - (answer)true
In this subsystem, a user can create data entry forms. - (answer)application generation
Which of the following is not an advantage of using a database? - (answer)reliability
, COSC FINAL PRACTICE EXAM WITH QUESTIONS AND ANSWERS
LATEST UPDATE 2026
Database tables can be related or connected to other tables by common key fields. - (answer)true
This commercial database offers news and information on legal, public records, and business issues. -
(answer)LexisNexis
The database in which data elements are organized using classes, objects, attributes, and methods is
called the object-oriented database. - (answer)true
In the object-oriented database model, this term is the equivalent to a field in a relational model. -
(answer)attribute
In order to create, modify, and gain access to a database, special software, called the database
management system, is required. - (answer)true
Access to these databases is offered to the public or selected outside individuals, for a fee. -
(answer)commercial database
Data redundancy can occur due to lack of data integrity. - (answer)true
A hierarchical database uses many-to-many relationships. - (answer)false
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
DO WHILE is an example of a sequential structure. - (answer)false
LATEST UPDATE 2026
Which view of data deals with how the data is actually formatted and located? - (answer)physical view
If all the data in a database is not physically located in one place, it would be a(n) _______ database. -
(answer)distributed
Querying the database and generating reports is assisted by the application generation subsystem. -
(answer)false
The ATM works on the principle of real-time processing. - (answer)true
Data consists of only numbers, letters, and symbols. - (answer)false
A commercial database is generally an enormous database that an organization develops to cover
particular subjects. - (answer)true
The logical arrangement of data in a database is called the database model. - (answer)true
Information collected by an organization from a variety of external and internal databases is stored in
this special type of database. - (answer)data warehouse
The company database may be stored on a central database server and managed by a database
administrator. - (answer)true
In this subsystem, a user can create data entry forms. - (answer)application generation
Which of the following is not an advantage of using a database? - (answer)reliability
, COSC FINAL PRACTICE EXAM WITH QUESTIONS AND ANSWERS
LATEST UPDATE 2026
Database tables can be related or connected to other tables by common key fields. - (answer)true
This commercial database offers news and information on legal, public records, and business issues. -
(answer)LexisNexis
The database in which data elements are organized using classes, objects, attributes, and methods is
called the object-oriented database. - (answer)true
In the object-oriented database model, this term is the equivalent to a field in a relational model. -
(answer)attribute
In order to create, modify, and gain access to a database, special software, called the database
management system, is required. - (answer)true
Access to these databases is offered to the public or selected outside individuals, for a fee. -
(answer)commercial database
Data redundancy can occur due to lack of data integrity. - (answer)true
A hierarchical database uses many-to-many relationships. - (answer)false
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
DO WHILE is an example of a sequential structure. - (answer)false
