COSC: Final Exam with All Correct & 100% Verified
Answers |Actual Complete Exam |Already Graded A+
Which view of data deals with how the data is actually formatted and located? ✔Correct
Answer-physical view
If all the data in a database is not physically located in one place, it would be a(n) _______
database. ✔Correct Answer-distributed
Querying the database and generating reports is assisted by the application generation
subsystem. ✔Correct Answer-false
The ATM works on the principle of real-time processing. ✔Correct Answer-true
Data consists of only numbers, letters, and symbols. ✔Correct Answer-false
A commercial database is generally an enormous database that an organization develops to
cover particular subjects. ✔Correct Answer-true
The logical arrangement of data in a database is called the database model. ✔Correct Answer-
true
Information collected by an organization from a variety of external and internal databases is
stored in this special type of database. ✔Correct Answer-data warehouse
The company database may be stored on a central database server and managed by a database
administrator. ✔Correct Answer-true
In this subsystem, a user can create data entry forms. ✔Correct Answer-application
generation
Which of the following is not an advantage of using a database? ✔Correct Answer-reliability
Database tables can be related or connected to other tables by common key fields. ✔Correct
Answer-true
This commercial database offers news and information on legal, public records, and business
issues. ✔Correct Answer-LexisNexis
The database in which data elements are organized using classes, objects, attributes, and
methods is called the object-oriented database. ✔Correct Answer-true
, In the object-oriented database model, this term is the equivalent to a field in a relational
model. ✔Correct Answer-attribute
In order to create, modify, and gain access to a database, special software, called the database
management system, is required. ✔Correct Answer-true
Access to these databases is offered to the public or selected outside individuals, for a fee.
✔Correct Answer-commercial database
Data redundancy can occur due to lack of data integrity. ✔Correct Answer-true
A hierarchical database uses many-to-many relationships. ✔Correct 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 _______. ✔Correct Answer-SQL
DO WHILE is an example of a sequential structure. ✔Correct Answer-false
Top-down program design is used to identify the program's processing steps after the outputs
and inputs have been determined. ✔Correct Answer-true
A 5GL language incorporates the concepts of artificial intelligence to allow a person to provide a
system with a problem and some constraints, and then request a solution. ✔Correct Answer-
true
These second generation languages use abbreviations or mnemonics that make it easier for
humans to understand. ✔Correct Answer-Assembly
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. ✔Correct Answer-false
This is an outline of the logic of the program you will write. ✔Correct Answer-pseudocode
These first generation languages are hard to use, with one of the reasons being that they are
different depending on the make of the computer. ✔Correct Answer-machine
C++ is an example of a machine language. ✔Correct Answer-false
Identify the programming tool that uses symbols to show the sequence of steps needed to solve
a programming problem. ✔Correct Answer-flowcharts
A condition must be met before a sequential structure can proceed to the next statement.
✔Correct Answer-false
Answers |Actual Complete Exam |Already Graded A+
Which view of data deals with how the data is actually formatted and located? ✔Correct
Answer-physical view
If all the data in a database is not physically located in one place, it would be a(n) _______
database. ✔Correct Answer-distributed
Querying the database and generating reports is assisted by the application generation
subsystem. ✔Correct Answer-false
The ATM works on the principle of real-time processing. ✔Correct Answer-true
Data consists of only numbers, letters, and symbols. ✔Correct Answer-false
A commercial database is generally an enormous database that an organization develops to
cover particular subjects. ✔Correct Answer-true
The logical arrangement of data in a database is called the database model. ✔Correct Answer-
true
Information collected by an organization from a variety of external and internal databases is
stored in this special type of database. ✔Correct Answer-data warehouse
The company database may be stored on a central database server and managed by a database
administrator. ✔Correct Answer-true
In this subsystem, a user can create data entry forms. ✔Correct Answer-application
generation
Which of the following is not an advantage of using a database? ✔Correct Answer-reliability
Database tables can be related or connected to other tables by common key fields. ✔Correct
Answer-true
This commercial database offers news and information on legal, public records, and business
issues. ✔Correct Answer-LexisNexis
The database in which data elements are organized using classes, objects, attributes, and
methods is called the object-oriented database. ✔Correct Answer-true
, In the object-oriented database model, this term is the equivalent to a field in a relational
model. ✔Correct Answer-attribute
In order to create, modify, and gain access to a database, special software, called the database
management system, is required. ✔Correct Answer-true
Access to these databases is offered to the public or selected outside individuals, for a fee.
✔Correct Answer-commercial database
Data redundancy can occur due to lack of data integrity. ✔Correct Answer-true
A hierarchical database uses many-to-many relationships. ✔Correct 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 _______. ✔Correct Answer-SQL
DO WHILE is an example of a sequential structure. ✔Correct Answer-false
Top-down program design is used to identify the program's processing steps after the outputs
and inputs have been determined. ✔Correct Answer-true
A 5GL language incorporates the concepts of artificial intelligence to allow a person to provide a
system with a problem and some constraints, and then request a solution. ✔Correct Answer-
true
These second generation languages use abbreviations or mnemonics that make it easier for
humans to understand. ✔Correct Answer-Assembly
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. ✔Correct Answer-false
This is an outline of the logic of the program you will write. ✔Correct Answer-pseudocode
These first generation languages are hard to use, with one of the reasons being that they are
different depending on the make of the computer. ✔Correct Answer-machine
C++ is an example of a machine language. ✔Correct Answer-false
Identify the programming tool that uses symbols to show the sequence of steps needed to solve
a programming problem. ✔Correct Answer-flowcharts
A condition must be met before a sequential structure can proceed to the next statement.
✔Correct Answer-false
