logo image

CIS*1200 Chapter 11 (Final Exam Questions)

Which of the following is a reason for creating a list instead of creating a database?
1) to organize data for simple tasks
2) to prevent data inconsistency
3) to prevent data redundancy
4) to make it easier to share data in a central location
1) to organize data for simple tasks
If a business keeps two lists, one for employee payroll and one for employee benefit information, both
containing name and address information, this is an example of data ________.
1) integrity
2) redundancy
3) completeness
4) normalization
2) redundancy
Data ________ means that the data contained in a database is accurate and reliable.
1) efficiency
2) integrity
3) redundancy
4) consistency
2) integrity
________ helps to ensure data integrity by maintaining information in only one place.
1) Data flexibility
2) Data redundancy
3) Data mapping
4) Data centralization
4) Data centralization
Which of the following is NOT a typical disadvantage associated with databases?
1) Databases can be expensive to set up.
2) Databases are usually more complex to administer.
3) Databases are more complex to construct.
4) Database information cannot be changed once it is entered.
4) Database information cannot be changed once it is entered.
An individual trained in the design and building of databases is called a database ________.
1) master
2) technician
3) administrator
4) analyst
3) administrator
In a database, a ________ is synonymous with a category of information.
1) field
2) record
3) row
4) table
1) field
Which of the following is NOT a database component?
1) field
2) list
3) record
4) table
2) list
Which of the following is NOT a common data type in a database?
1) hyperlink
2) memo
3) object
4) figure
4) figure
In a database, ________ fields store numbers used to perform calculations.
1) date
2) numeric
3) computational
4) alphanumeric
2) numeric
In a database, a video clip would be stored in a(n) ________ field.
1) text
2) object
3) memo
4) hyperlink
2) object
To store a Web address, use a(n) ________ field in a database.
1) hyperlink
2) object
3) address
4) memo
1) hyperlink
________ defines the maximum number of characters or numbers that a particular field can hold.
1) Type size
2) Max size
3) Field size
4) Text size
3) Field size
In a database, a record is a:
1) group of related fields.
2) category of information.
3) cluster of adjacent cells.
4) collection of tables.
1) group of related fields
Which of the following is NOT a likely primary key?
1) driver’s license number
2) street address
3) student ID number
4) Social Security number
2) street address
A unique field is called a primary key or a ________ field.
1) key
2) data
3) validation
4) referential
1) key
________ databases have the largest market share among the primary types of electronic databases.
1) Relational
2) Flat-file
3) Multidimensional
4) Object-oriented
1) Relational
Which of the following is NOT a type of electronic database?
1) object-oriented
2) flat-file
3) multidimensional
4) relational
2) flat-file
In a relational database, what is a relationship?
1) a table that contains related data
2) the primary key in the database
3) the links among databases
4) the array of tables in a database
1) a table that contains related data
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________
data.
1) enterprise
2) structured
3) unstructured
4) multidimensional
3) unstructured
Unstructured data such as video clips and pictures are known as ________ because of the way they are
encoded.
1) hyperlink fields
2) multidimensional data
3) binary large objects (BLOBs)
4) metadata
3) binary large objects (BLOBs)
Which of the following statements about object-oriented databases is FALSE?
1) They are more complex than relational databases.
2) They use a query language to access and manage data.
3) They are good at handling unstructured data.
4) They store data in table format.
4) They store data in table format.
Which type of database excels in the storage of structured, analytical data?
1) relational
2) hierarchical
3) multidimensional
4) object-oriented
1) relational
Data in a multidimensional database is organized in a ________ format.
1) linear
2) table
3) cube
4) cellular
3) cube
________ databases can easily be customized to provide information to a variety of users (based on their
need) and can process data much faster than pure relational databases.
1) Hierarchical
2) Multidimensional
3) Object-oriented
4) Structured
2) Multidimensional
What does the acronym DBMS stand for?
1) database modeling system
2) database management system
3) data building and modeling system
4) data browsing and management system
2) database management system
Microsoft ________ is a database management system.
1) Visio
2) Publisher
3) Access
4) Project
3) Access
Which of the following is NOT a standard DBMS operation?
1) sorting data
2) querying data
3) outputting data
4) graphing data
4) graphing data
A data dictionary is also called a(n) ________.
1) information system
2) summary report
3) relation
4) database schema
4) database schema
When creating a database with a DBMS, you must create a description of the data called the ________.
1) data type
2) data dictionary
3) data mine
4) data warehouse
2) data dictionary
When a user sees a field in a database with a value prior to changing the value (if needed), the user sees a
________.
1) default value
2) relation
3) field type
4) numeric check
1) default value
A ________ check allows you to set credits allowed for students during one quarter from 0 to 21.
1) completeness
2) range
3) consistency
4) numeric
2) range
A ________ check determines if all required fields were entered with appropriate data.
1) completeness
2) range
3) consistency
4) numeric
1) completeness
A ________ displays a subset of data from a table (or tables) based on the criteria specified.
1) database query
2) join query
3) select query
4) criteria query
3) select query
SQL uses ________ to extract records from a database by using English-like expressions that have
variables and operations.
1) Boolean algebra
2) relational algebra
3) primary keys
4) foreign keys
2) relational algebra
When you want to extract data from two or more tables, you use a(n) ________ query.
1) select
2) join
3) relational
4) object
2) join
In Access, the Simple Query Wizard uses ________ to create a query.
1) ICQ
2) OQL
3) SQL
4) DQL
3) SQL
________ is reordering records in a database.
1) Filtering
2) Alphabetizing
3) Querying
4) Sorting
4) Sorting
A database ________ instructs a database to search for particular pieces of data.
1) query
2) template
3) formula
4) function
1) query
Data from a database that, in electronic form, is formatted for another application is known as ________.
1) exporting
2) importing
3) batch processing
4) data mining
1) exporting
A ________ relationship indicates that for a record in one table, there can be many related records in
another table.
1) many-to-one
2) one-to-many
3) one-to-one
4) single-to-many
2) one-to-many
________ means that for each value in the foreign key of one table, there is a corresponding value in the
primary key of another table.
1) Referential integrity
2) Normalization
3) Database consistency
4) Record integrity
1) Referential integrity
________ is the process of reducing data redundancy by recording data only once.
1) Consistency checking
2) Validation
3) Normalization
4) Range checking
3) Normalization
A data ________ is a large-scale electronic repository of data that contains and organizes all of an
organization’s data in one place.
1) mart
2) chain
3) warehouse
4) storehouse
3) warehouse
Data staging consists of all of the following steps EXCEPT:
1) transformation of data.
2) mining of data.
3) storage of data in a warehouse.
4) extraction of data.
2) mining of data.
A(n) ________ is designed to improve communications and assist employees in accomplishing their daily
tasks.
1) office support system
2) transaction-processing system
3) management information system
4) decision support system
1) office support system
In a transaction-processing system (TPS), if the TPS database is queried and updated while the transaction
is taking place, this is called ________ processing.
1) direct
2) batch
3) real-time
4) immediate
3) real-time
In a transaction-processing system, if transaction data is accumulated until a certain point and then many
transactions are processed all at once, this is called ________ processing.
1) delayed
2) batch
3) real-time
4) group
2) batch
Exception reports and summary reports are part of a(n) ________.
1) transaction-processing system
2) office support system
3) management information system
4) decision support system
3) management information system
Management information systems provide reports called ________, that show conditions that are unusual or
need attention from users of the system.
1) detail reports
2) summary reports
3) exception reports
4) expert reports
3) exception reports
The speech-recognition feature of Microsoft Windows is an example of a ________.
1) natural language processing (NLP) system
2) decision support system (DSS)
3) management information system (MIS)
4) database management system (DBMS)
1) natural language processing (NLP) system
An example of ________ would be customer demographic data purchased from third parties or statistics compiled by the federal government.
1) internal data
2) external data
3) imported data
4) metadata
2) external data
In a data warehouse, data gathered from sales, billing, and inventory departments are examples of
________ sources.
1) internal data
2) external data
3) metadata
4) exported data
1) internal data
The type of information system that uses model management systems is a(n) ________.
1) transaction-processing system
2) management information system
3) decision support system
4) office support system
3) decision support system
An expert system and a natural language processing system are both ________.
1) transaction-processing systems
2) knowledge-based systems
3) office support systems
4) database management systems
2) knowledge-based systems
Classification, affinity grouping, and estimation are ________ methods used by managers to make their data
more meaningful.
1) modeling
2) staging
3) artificial intelligence
4) data mining
4) data mining
________ is the branch of computer science that deals with the attempt to create computers that think like
humans.
1) Natural language processing
2) Expert system
3) Artificial intelligence
4) Enterprise resource planning
3) Artificial intelligence
If a numeric field has a size of 7, which is the highest number it can hold?
1) 7
2) 9999999
3) 7777777
4) 700,000
2) 9999999
Oracle Database 11g is an example of which type of database?
1) primary database
2) multidimensional database
3) object-oriented database
4) flat-file database
2) multidimensional database
Data redundancy results when duplicate information is entered into a database.
1) True
2) False
1) True
A database is a collection of related data that can be easily stored, sorted, organized, and queried.
1) True
2) False
1) True
A pressing problem of lists is the inability of the listed data to be easily shared.
1) True
2) False
1) True
Data centralization is a common feature of databases.
1) True
2) False
1) True
A common disadvantage of databases is that databases are often flexibly organized.
1) True
2) False
2) False
A numeric data field type can hold a dollar sign ($).
1) True
2) False
1) True
A group of related fields is known as a table.
1) True
2) False
2) False
An employee’s ID number, name, company position, address, city, state, and zip makes up a record.
1) True
2) False
1) True
Primary key fields must contain a unique value for each record.
1) True
2) False
1) True
Employees’ last name would usually make an appropriate key field.
1) True
2) False
2) False
Primary keys have to be numbers that are entered by the user.
1) True
2) False
2) False
Relational databases store more types of data than object-oriented databases.
1) True
2) False
2) False
An advantage of multidimensional databases is that they can easily be customized for a variety of users.
1) True
2) False
1) True
Feature attributes describe the measure attribute of a multidimensional database in some meaningful way.
1) True
2) False
1) True
A data dictionary defines the name, data type, and length of each field in the database.
1) True
2) False
1) True
A first name field should have a default value.
1) True
2) False
2) False
Most databases cannot import data from other software applications.
1) True
2) False
2) False
Alphabetic as well as numeric data can be entered in an alphabetic field.
1) True
2) False
2) False
Viewing records of a database can also be referred to as browsing.
1) True
2) False
1) True
Only Microsoft Access and MySQL use Structured Query Language.
1) True
2) False
2) False
A database query is a question that a user asks of a database.
1) True
2) False
1) True
All current DBMSs contain a query language that the software uses to retrieve and display requested
records.
1) True
2) False
1) True
Database query output can be imported into Microsoft Word.
1) True
2) False
1) True
In a many-to-many relationship, a single record in one table can have many corresponding records in a
related table.
1) True
2) False
2) False
In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.
1) True
2) False
2) False
A foreign key in one table is the primary key of another table and is used to establish relationships with that
other table.
1) True
2) False
1) True
A record is a category of information in a database.
1) True
2) False
2) False
Normalization reduces data redundancy by recording data only once.
1) True
2) False
1) True
For a relationship to be established between two tables, fields with common data must be present.
1) True
2) False
1) True
There does not necessarily have to be a common field between two tables to establish a relationship.
1) True
2) False
2) False
Knowledge-based systems support the concept of normal logic.
1) True
2) False
2) False
The text of the Gettysburg Address would be stored in a text field.
1) True
2) False
2) False
Artificial intelligence (AI) is the branch of computer science that deals with the attempt to create computers
that think like humans.
1) True
2) False
1) True
Data integrity means that the data contained in the database is accurate and reliable.
1) True
2) False
1) True
Normalization means that there are no data entry errors in a database.
1) True
2) False
2) False
A data warehouse must include data that pertains only to one time period.
1) True
2) False
2) False
A data warehouse can be populated with external sources such as suppliers and vendors.
1) True
2) False
1) True
A transaction-processing system (TPS) keeps track of everyday business activities.
1) True
2) False
1) True
Real-time processing means that transactions are accumulated and then a number of transactions are
processed at once.
1) True
2) False
2) False
In data mining, classification involves organizing data into similar subgroups of data.
1) True
2) False
2) False
A summary report shows unusual conditions or conditions that need system users’ attention.
1) True
2) False
2) False
Data warehousing is the process by which great amounts of data are analyzed and investigated with the
purpose of spotting significant patterns or trends.
1) True
2) False
2) False
Data mining is the process by which great amounts of data are analyzed and examined.
1) True
2) False
1) True
The information in a data mart spans an entire enterprise.
1) True
2) False
2) False

Need essay sample on "CIS*1200 Chapter 11 (Final Exam Questions)"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy