CIS 105 FINAL EXAM QUESTIONS
AND ANSWERS
Which view of data deals with how the data is actually formatted and located - Answer-
Physical View
A data field that represents a description or characteristic of some entity - Answer-
Attribute
A collection of related fields such as a person's name, address, and age - Answer-
Record
a field that uniquely identifies each record - Answer- Primary key
In, ______ transactions are collected over time and then processed all at once -
Answer- Batch processing
In ________, Tara is processed at the same time the transaction occurs - Answer-
Real-time processing
Having several instances of the same data is called Data - Answer- Redundancy
Which system is a type of artificial intelligence that uses a database, containing facts
and rules, to provide assistance to users - Answer- Expert system
If mr. Smith this bike has been sent to his new address, but the bill is to his old, he can
most likely be attributed to the lack of data - Answer- Integrity
which of the following is not an advantage of using a database - Answer- Reliability
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
This system defines the logical structure of the database by using a data dictionary or
schema - Answer- Data definition
in this subsystem, user can create a data entry forms - Answer- Application generation
In this database model comma the fields or records are structured in nodes - Answer-
Hierarchical
, A network database utilizes these special connections between a parent nodes and
child nodes - Answer- Pointers
This type of database is organized into many tables with common data items kkey
fields) linking the tables to one another - Answer- Relational
Which of the following is an advantage of using multidimensional databases - Answer-
Conceptualization
These databases store not only data but also instructions to manipulate the data -
Answer- Object-oriented
In the object oriented database model, this term is the equivalent to a field in a relational
model - Answer- Attribute
In this type of database, the data and the DBMS are stored either on the user's hard
disk drive or on a lan file server - Answer- Individual
Which part of an information system consists of the rules or guidelines for people to
follow - Answer- Procedures
The equipment that processes data in order to create information is called the - Answer-
Hardware
In most cases the word software is interchangeable with the word - Answer- Program
What are the two major softwareTypes - Answer- System software and application
software
Which of the following is a collection of programs rather than a single program -
Answer- System software
Background software that helps the computer manage resources is called - Answer-
System software
Identify the program that coordinates Computer Resources, provides an interface
between users and the computer, and runs applications - Answer- Operating system
Antivirus programs protect your computer system from viruses or malicious programs.
This is an example of which type of software - Answer- Utilities
System software includes all of the following except - Answer- Browser
AND ANSWERS
Which view of data deals with how the data is actually formatted and located - Answer-
Physical View
A data field that represents a description or characteristic of some entity - Answer-
Attribute
A collection of related fields such as a person's name, address, and age - Answer-
Record
a field that uniquely identifies each record - Answer- Primary key
In, ______ transactions are collected over time and then processed all at once -
Answer- Batch processing
In ________, Tara is processed at the same time the transaction occurs - Answer-
Real-time processing
Having several instances of the same data is called Data - Answer- Redundancy
Which system is a type of artificial intelligence that uses a database, containing facts
and rules, to provide assistance to users - Answer- Expert system
If mr. Smith this bike has been sent to his new address, but the bill is to his old, he can
most likely be attributed to the lack of data - Answer- Integrity
which of the following is not an advantage of using a database - Answer- Reliability
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
This system defines the logical structure of the database by using a data dictionary or
schema - Answer- Data definition
in this subsystem, user can create a data entry forms - Answer- Application generation
In this database model comma the fields or records are structured in nodes - Answer-
Hierarchical
, A network database utilizes these special connections between a parent nodes and
child nodes - Answer- Pointers
This type of database is organized into many tables with common data items kkey
fields) linking the tables to one another - Answer- Relational
Which of the following is an advantage of using multidimensional databases - Answer-
Conceptualization
These databases store not only data but also instructions to manipulate the data -
Answer- Object-oriented
In the object oriented database model, this term is the equivalent to a field in a relational
model - Answer- Attribute
In this type of database, the data and the DBMS are stored either on the user's hard
disk drive or on a lan file server - Answer- Individual
Which part of an information system consists of the rules or guidelines for people to
follow - Answer- Procedures
The equipment that processes data in order to create information is called the - Answer-
Hardware
In most cases the word software is interchangeable with the word - Answer- Program
What are the two major softwareTypes - Answer- System software and application
software
Which of the following is a collection of programs rather than a single program -
Answer- System software
Background software that helps the computer manage resources is called - Answer-
System software
Identify the program that coordinates Computer Resources, provides an interface
between users and the computer, and runs applications - Answer- Operating system
Antivirus programs protect your computer system from viruses or malicious programs.
This is an example of which type of software - Answer- Utilities
System software includes all of the following except - Answer- Browser
