Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which of the following statements is true of big data?

Accepted Answer

A) It is a consequence of geometric decay of data in data warehouses. 
B) It can be efficiently processed and managed by conventional computing methods. 
C) Its three dimensions are value,density,and uniformity. 
D) It is a result of exponential growth of data in both public and private organizations. 
A) It is a consequence of geometric decay of data in data warehouses. 
B) It can be efficiently processed and managed by conventional computing methods. 
C) Its three dimensions are value,density,and uniformity. 
D) It is a result of exponential growth of data in both public and private organizations.

Question 3

The _____ dimension of big data refers to the sheer quantity of transactions,measured in petabytes or exabytes.

Accepted Answer

A) viscosity 
B) volume 
C) area 
D) time 
A) viscosity 
B) volume 
C) area 
D) time

Question 4

What are the advantages of a data mart over a data warehouse?

Accepted Answer

A data mart has the following advantages

Question 5

_________,used in object-oriented databases,refers to new objects being created faster and more easily by entering new data in attributes.
A)Inheritance
B)Encapsulation
C)Fragmentation
D)Instance

Accepted Answer

The answer of _________,used in object-oriented databases,refers to new objects...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The popularity of social networks has contributed to the growth of big data.

Accepted Answer

A) True 
 B)False

Question 8

In a relational database,every record must be uniquely identified by a _________ key.

Accepted Answer

A) primary 
B) super 
C) foreign 
D) candidate​ 
A) primary 
B) super 
C) foreign 
D) candidate​

Question 9

The component that is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces,with other programming languages is the _____ component.

Accepted Answer

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

Question 10

In a database,which of the following is a source of internal data?

Accepted Answer

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

Question 11

The _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

Accepted Answer

A) data manipulation 
B) data generation 
C) data definition 
D) data administration 
A) data manipulation 
B) data generation 
C) data definition 
D) data administration

Question 12

In contrast to data in a database,discussed in data warehouses,the subject-oriented characteristic _____.

Accepted Answer

A) captures raw transaction data 
B) manages data transactions 
C) focuses on a specific area 
D) keeps recent activity in memory 
A) captures raw transaction data 
B) manages data transactions 
C) focuses on a specific area 
D) keeps recent activity in memory

Question 13

The database component of an information system can generate sufficient business intelligence by accessing the _____ data of an organization.

Accepted Answer

A) external and internal 
B) aggregated and disaggregated 
C) qualitative and quantitative 
D) slicing and dicing 
A) external and internal 
B) aggregated and disaggregated 
C) qualitative and quantitative 
D) slicing and dicing

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) logical 
B) physical 
C) catalog 
D) complex​ 
A) logical 
B) physical 
C) catalog 
D) complex​

Question 16

A data _________ is the structure and organization of data,which involves fields,records,and files.

Accepted Answer

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

Question 17

_________ analysis is used to discover patterns and relationships.

Accepted Answer

A) Data-mining 
B) Data mart 
C) Data pattern 
D) Data toggle​ 
A) Data-mining 
B) Data mart 
C) Data pattern 
D) Data toggle​

Question 18

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

Accepted Answer

A) Optimization 
B) Fragmentation 
C) Normalization 
D) Encapsulation 
A) Optimization 
B) Fragmentation 
C) Normalization 
D) Encapsulation

Question 19

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

Accepted Answer

A) sequential access file structure 
B) random access file structure 
C) indexed sequential access 
D) physical view access 
A) sequential access file structure 
B) random access file structure 
C) indexed sequential access 
D) physical view access

Question 20

The first step in database design is defining a _____,which defines how data is created,represented,organized,and maintained.

Accepted Answer

A) data warehouse 
B) data mart 
C) data dictionary 
D) data model 
A) data warehouse 
B) data mart 
C) data dictionary 
D) data model

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

Which of the following statements is true of big data?

The _____ dimension of big data refers to the sheer quantity of transactions,measured in petabytes or exabytes.

What are the advantages of a data mart over a data warehouse?

_________,used in object-oriented databases,refers to new objects being created faster and more easily by entering new data in attributes. A)Inheritance B)Encapsulation C)Fragmentation D)Instance

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

The popularity of social networks has contributed to the growth of big data.

In a relational database,every record must be uniquely identified by a _________ key.

The component that is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces,with other programming languages is the _____ component.

In a database,which of the following is a source of internal data?

The _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

In contrast to data in a database,discussed in data warehouses,the subject-oriented characteristic _____.

The database component of an information system can generate sufficient business intelligence by accessing the _____ data of an organization.

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

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

A data _________ is the structure and organization of data,which involves fields,records,and files.

_________ analysis is used to discover patterns and relationships.

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

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

The first step in database design is defining a _____,which defines how data is created,represented,organized,and maintained.

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal,Legal,Ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,Intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,Technologies,and Applications

Filters

Exam 3: Database Systems,Data Warehouses,and Data Marts

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

Which of the following statements is true of big data?

The _____ dimension of big data refers to the sheer quantity of transactions,measured in petabytes or exabytes.

What are the advantages of a data mart over a data warehouse?

_________,used in object-oriented databases,refers to new objects being created faster and more easily by entering new data in attributes. A)Inheritance B)Encapsulation C)Fragmentation D)Instance

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

The popularity of social networks has contributed to the growth of big data.

In a relational database,every record must be uniquely identified by a _________ key.

The component that is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces,with other programming languages is the _____ component.

In a database,which of the following is a source of internal data?

The _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

In contrast to data in a database,discussed in data warehouses,the subject-oriented characteristic _____.

The database component of an information system can generate sufficient business intelligence by accessing the _____ data of an organization.

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

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

A data _________ is the structure and organization of data,which involves fields,records,and files.

_________ analysis is used to discover patterns and relationships.

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

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

The first step in database design is defining a _____,which defines how data is created,represented,organized,and maintained.

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal,Legal,Ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,Intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,Technologies,and Applications

Filters