Deck 3: Database Systems,data Warehouses,and Data Marts

Question 1

Although a database can consist of only a single file,it is usually a group of files.

Answer 1

True

Question 2

Disks are sequential access devices,whereas tapes are random access devices.

Answer 2

False

Question 3

The network model is similar to the hierarchical model because records are organized in the same way.

Answer 3

False

Question 4

The sequential access file structure method is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

Question 5

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the DBMS.

Question 6

One advantage a database has over a flat file system is that more information can be generated from the same data.

Question 7

In a relational model,the rows are called attributes and the columns are called tuples.

Question 8

The database component of an information system accesses only internal data.

Question 9

For each database,there can be more than one physical view of data.

Question 10

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Question 11

Flat file organization tends to take up unnecessary storage space.

Question 12

A select operation pares down a table by eliminating columns according to certain criteria.

Question 13

The "integrity rules" component of a data model defines the boundaries of a database,constraints,and access methods.

Question 14

The use of OR operator means that only one of the conditions must be met.

Question 15

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Question 16

Redundant data is eliminated by a process called normalization.

Question 17

In a hierarchical data model,nodes with the same parents are called siblings.

Question 18

Data redundancy is eliminated or minimized in a flat file system.

Question 19

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

Question 20

The indexed sequential access method (ISAM)is slow and becomes increasingly useful as the number of records becomes larger.

Question 21

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods.

Question 22

Which of the following is a source of external data?

A)Tax records
B)Sales records
C)Transaction records
D)Personnel records

Question 23

Metadata is extraneous data generated from an SQL join command.

Question 24

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Question 25

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

Question 26

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

Question 27

The structure and organization of data in a database is called a data ____.

A)mart
B)dictionary
C)warehouse
D)hierarchy

Question 28

An e-commerce site that needs frequent updates would benefit from the use of a static Web site.

Question 29

The ____ view involves how data is stored on and retrieved from storage media.

A)physical
B)logical
C)rational
D)analytical

Question 30

The term CRUD stands for copy,revise,undo,and define.

Question 31

The ____ in a database model describes methods,calculations,and so forth that can be performed on data,such as updating and querying data.

A)data structure
B)set of operation rules
C)set of integrity rules
D)file structure

Question 32

In well-designed data-driven Web sites,changes are made to the HTML code.

Question 33

In the ____ model,each record can have multiple parent and child records.

A)network
B)hierarchical
C)operations
D)relational

Question 34

The ____ in a database model defines the boundaries of a database,such as maximum and minimum values allowed for a field.

A)data structure
B)set of operation rules
C)set of integrity rules
D)file structure

Question 35

A distributed database is not limited by the data's physical location.

Question 36

The ____ view involves how information appears to users and how it can be organized and retrieved.

A)physical
B)logical
C)rational
D)analytical

Question 37

The database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

Question 38

Which of the following is true of a flat file system?

A)Data redundancy is eliminated or minimized.
B)Data management is improved.
C)More sophisticated security measures cannot be used.
D)A variety of relationships among data can be easily maintained.

Question 39

Which of the following is a source of internal data?

A)Tax records
B)Sales records
C)Distribution networks
D)Economic indicators

Question 40

Which of the following is true of a database?

A)Complex requests can be difficult to handle.
B)More storage space is required.
C)Programs and data are interdependent.
D)More information can be generated from the same data.

Question 41

We use the ____ operator when all conditions are required to be met.

A)NOT
B)AND
C)OR
D)MIS

Question 42

In a data warehouse,____ means collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

A)extraction
B)transformation
C)loading
D)aggregation

Question 43

A data ____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

A)dictionary
B)mine
C)warehouse
D)mart

Question 44

To begin designing a relational database,you must define the ____ structure by defining each table and the fields in it.

A)physical
B)logical
C)operations
D)integral

Question 45

A database ____ is responsible for data storage,manipulation,and retrieval.

A)program
B)index
C)system
D)engine

Question 46

The ____ approach to setting up a distributed DBMS combines fragmentation and replication.

A)optimization
B)allocation
C)encapsulation
D)normalization

Question 47

In a relational model,when a primary key for one table appears in another table it is called a ____ key.

A)secondary
B)foreign
C)surrogate
D)domain

Question 48

A ____ operation searches data in a table and retrieves records based on certain criteria.

A)project
B)join
C)find
D)select

Question 49

The ____ approach to setting up a distributed DBMS addresses how tables are divided among multiple locations.

A)normalization
B)encapsulation
C)fragmentation
D)replication

Question 50

Grouping objects along with their attributes and methods into a class is called ____.

A)replication
B)allocation
C)encapsulation
D)normalization

Question 51

A ____ operation pares down a table by eliminating columns according to certain criteria.

A)project
B)join
C)find
D)select

Question 52

The data ____ component is used for tasks such as backup and recovery,security,and change management.

A)manipulation
B)application
C)definition
D)administration

Question 53

A data ____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

A)dictionary
B)mart
C)mine
D)warehouse

Question 54

The data ____ component is used to add,delete,modify,and retrieve records from a database.

A)manipulation
B)application
C)definition
D)administration

Question 55

____ is information in its original form.

A)Summary data
B)Raw data
C)Open data
D)Metadata

Question 56

A ____ key uniquely identifies every record in a relational database.

A)secondary
B)foreign
C)primary
D)surrogate

Question 57

____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

A)optimization
B)fragmentation
C)normalization
D)encapsulation

Question 58

Data in a data warehouse can be differentiated from data in a database in that the former ____.

A)captures raw transaction data
B)is used for capturing and managing transactions
C)comes from a variety of sources
D)only keeps recent activity in memory

Question 59

The ____ approach to a distributed DBMS has each site store a copy of the data in the organization's database.

A)encapsulation
B)replication
C)normalization
D)fragmentation

Question 60

The data ____ component is used to create and maintain the data dictionary.

A)manipulation
B)application
C)definition
D)administration

Question 61

____ gives users subtotals of various categories.

A)Summary data
B)Raw data
C)Open data
D)Metadata

Question 62

____________________ refers to new objects being created faster and more easily by entering new data in attributes.

Question 63

In a(n)____________________ model,the relationships among records form a treelike structure.

Question 64

____ generally uses internal data and responds in real time.

A)OLAP
B)OLTP
C)SQL
D)QBE

Question 65

____ uses multiple sources of information and provides multidimensional analysis.

A)OLAP
B)OLTP
C)SQL
D)QBE

Question 66

With the ____________________ distributed DBMS approach,each site stores a copy of the data in the organization's database.

Question 67

In a(n)____________________ access file structure,records can be accessed in any order,regardless of their physical location in storage media.

Question 68

In large organizations,database design and management is handled by the database ____________________.

Question 69

Grouping objects along with their attributes and methods into a class is called ____________________.

Question 70

Business analytics uses ____ to support decision-making activities.

A)data mining tools
B)dashboards
C)query reports
D)OLAP

Question 71

A data ____ is usually a smaller version of a data warehouse,used by a single department or function.

A)domain
B)mine
C)dictionary
D)mart

Question 72

The ____________________ view of a database involves how information appears to users and how it can be organized and retrieved.

Question 73

In a(n)____________________ access file structure,records in files are organized and processed in numerical order.

Question 74

____________________ is a standard fourth-generation query language used by many DBMS packages,such as Oracle 11g and Microsoft SQL Server.

Question 75

A(n)____________________ is the structure and organization of data,which involves fields,records,and files.

Question 76

____________________ processing is done to make sure data meets the data warehouse's needs.

Question 77

In a relational database,every record must be uniquely identified by a(n)____________________ key.

Question 78

A(n)____________________ is software for creating,storing,maintaining,and accessing database files.

Question 79

A(n)____________________ is usually a smaller version of a data warehouse,used by a single department or function.

Question 80

____________________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.