Question 1

In the context of relational database model,selecting involves combining two or more tables.

Accepted Answer

A) True 
 B)False  False

Question 2

Differentiate between the traditional and database approach to data management.

Accepted Answer

At one time,information systems referenced specific files containing relevant data.For example,a payroll system would use a payroll file.Each distinct operational system used data files dedicated to that system.This approach to data management is called the traditional approach to data management.Today,most organizations use the database approach to data management,where multiple information systems share a pool of related data.For example,the Human Resources database contains lots of data about employees,and it is accessed for use by many different functions including payroll,personnel,training,etc.

Question 3

______ use basic graphical symbols to show an organization of and relationships between data.

Accepted Answer

Entity-relationship (ER)diagrams
Entity-relationship diagrams
ER diagrams

Question 4

_____ is an approach to data management whereby each distinct operational system uses data files dedicated to that system.

Accepted Answer

A)   Company approach to data management
B)   Database approach to data management
C)   Enterprise approach to data management
D)   Traditional approach to data management

Question 5

Several records can share the same primary key.

Accepted Answer

A) True 
 B)False

Question 6

A(n)_____ is s field or set of fields in a record that uniquely defines the record.

Accepted Answer

A)   attribute
B)   entity
C)   primary key
D)   data item

Question 7

When organizing a database,one of the key considerations include determining who will have access to the collected data.

Accepted Answer

A) True 
 B)False

Question 8

_____ is the term used to describe enormous and complex data collections that traditional data management software,hardware,and analysis processes are incapable of dealing with them.

Accepted Answer

A)   Data warehouse
B)   Datamart
C)   Big data
D)   Knowledge base

Question 9

The role of a data administrator is to plan,design,create,operate,secure,monitor,and maintain databases.

Accepted Answer

A) True 
 B)False

Question 10

In the relational database model,each row in a table represents a(n)_____.

Accepted Answer

The answer of In the relational database model,each row in...

Question 11

With _____,the database is stored on a service provider's server and accessed by the client over a network,typically the Internet.

Accepted Answer

A)   Internet access
B)   Database as a Service
C)   Software as a Service
D)   Oracle

Question 12

Together,bits,characters,fields,records,files,and databases form the _____.

Accepted Answer

The answer of Together,bits,characters,fields,records,files,and databases form the _____....

Question 13

One of the most effective counterintelligence measures is to define _____ information relevant to a company and control its dissemination.

Accepted Answer

A)   grapevine
B)   trade secret
C)   public
D)   data loss

Question 14

Briefly describe the relational database model.

Accepted Answer

The answer of Briefly describe the relational database model....

Question 15

One data cleansing solution is to identify and correct the data by cross-checking it against a validated data set.

Accepted Answer

A) True 
 B)False

Question 16

A(n)_____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions associated with the relational database model in order to provide faster performance and greater scalability.

Accepted Answer

The answer of A(n)_____ is designed to store and retrieve...

Question 17

Some databases use ______,which is a visual approach to developing queries and requests.

Accepted Answer

A)   Query by Example (QB
E)  
B)   user views
C)   structured query language (SQL) 
D)   data manipulation language (DML)

Question 18

_____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events.

Accepted Answer

A)   Business intelligence
B)   Social graph analysis
C)   Online analytical processing
D)   Predictive analysis

Question 19

One of the best ways to gain insights into data is through _____ techniques that can help quickly draw conclusions and see relationships among the data.

Accepted Answer

The answer of One of the best ways to gain...

Question 20

A database should be designed to store all data relevant to a business and provide quick access and easy modification.

Accepted Answer

A) True 
 B)False

Exam 3: Database Systems,data Centers,and Business Intelligence

In the context of relational database model,selecting involves combining two or more tables.

Differentiate between the traditional and database approach to data management.

______ use basic graphical symbols to show an organization of and relationships between data.

_____ is an approach to data management whereby each distinct operational system uses data files dedicated to that system.

Several records can share the same primary key.

A(n) _____ is s field or set of fields in a record that uniquely defines the record.

When organizing a database,one of the key considerations include determining who will have access to the collected data.

_____ is the term used to describe enormous and complex data collections that traditional data management software,hardware,and analysis processes are incapable of dealing with them.

The role of a data administrator is to plan,design,create,operate,secure,monitor,and maintain databases.

In the relational database model,each row in a table represents a(n)_____.

With _____,the database is stored on a service provider's server and accessed by the client over a network,typically the Internet.

Together,bits,characters,fields,records,files,and databases form the _____.

One of the most effective counterintelligence measures is to define _____ information relevant to a company and control its dissemination.

Briefly describe the relational database model.

One data cleansing solution is to identify and correct the data by cross-checking it against a validated data set.

A(n)_____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions associated with the relational database model in order to provide faster performance and greater scalability.

Some databases use ______,which is a visual approach to developing queries and requests.

_____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events.

One of the best ways to gain insights into data is through _____ techniques that can help quickly draw conclusions and see relationships among the data.

A database should be designed to store all data relevant to a business and provide quick access and easy modification.