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