MIS-Quiz 3 chapter 5,6
Relational databases represent relationships using ________. Correct Response A) foreign keys B) file systems C) primary keys D) metadata
A) foreign keys
Which of the following features distinguishes a LAN from a WAN? A) A WAN has low bandwidth. Correct Response B) A LAN connects computers in a single location. C) A WAN has a limit on the number of users. D) A LAN has stringent hardware requirements.
B) A LAN connects computers in a single location.
Metadata are ________. A) error logs of databases B) data that are encrypted Correct Response C) data that describe data D) codes used for server-side processing
C) data that describe data
The rows in a database are called ________. A) fields B) files Correct Response C) records D) tables
C) records
columns that are keys to different tables than the ones in which they reside are called ________. A) attributes B) internal records C) primary keys Correct Response D) foreign keys
D) foreign keys
Each table in a database must have two or more primary keys. True Correct Response False
False
The purpose of a database is to keep track of lists of data that involve a single theme. True Correct Response False
False
An intranet is a private internet that is used exclusively within an organization. Correct Response True False
True
Tristom Technologies, based in New York, opens branches in Chicago and Detroit. Which of the following networks will the company use to connect computers in the three offices? A) XML B) URL Correct Response C) WAN D) LAN
WAN
Which of the following is the smallest element in a database? A) field B) record Correct Response C) byte D) metadata
byte
A primary key in a database is a ________. A) group of fields or columns that represent metadata B) group of tables or files formed to identify a unique field or row C) group of rows that identifies a unique table or file Correct Response D) column or group of columns that identifies a unique row in a table
column or group of columns that identifies a unique row in a table
A(n) ________ is a program used to create, process, and administer a database. A) operating system B) database system Correct Response C) database management system D) information system
database management system
Which of the following is a developmental task of database administration? A) monitoring backup procedures B) managing configuration changes in systems Correct Response C) evaluating an application design D) conducting training for users
evaluating an application design
The columns in a database are called ________. A) files Correct Response B) fields C) records D) tables
fields
Which of the following is a characteristic of in-house hosting? Correct Response A) in-depth visibility of disaster preparedness B) small capital requirements C) known cost structure D) industry-wide economies of scale
in-depth visibility of disaster preparedness
A computer ________ is a collection of computers that communicate with one another over transmission lines or wirelessly. A) database Correct Response B) network C) application D) server
network
Which of the following is a characteristic of cloud-based hosting? A) unknown cost structure B) in-depth visibility of security Correct Response C) no obsolescence D) full control of data location
no obsolescence
Cloud resources are ________ because many different organizations use the same physical hardware. A) programmatic Correct Response B) pooled C) portable D) elastic
pooled
The modification or deletion of data in a database is an example of ________ operations of a database management system. A) analytical Correct Response B) processing C) administrative D) statistical
processing
A ________ is a set of rules that programs on two communicating devices follow. A) cloud B) packet Correct Response C) protocol D) codec
protocol
Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database. A) report Correct Response B) query C) data model D) database administrative function
query
The cloud is defined as the elastic leasing of pooled computer resources over the Internet. Correct Response True False
true