Question 1

In the relational model, each row of a table represents a data entity or record and each column of the table represents an attribute or field.

Accepted Answer

A) True 
 B)False  True

Question 2

Business intelligence turns data into useful information that is then kept closely guarded to prevent it falling into the hands of the wrong employees.

Accepted Answer

A) True 
 B)False  False

Question 3

What is the term for the steps an organization takes to protect information sought by unauthorized parties?

Accepted Answer

A)  data loss prevention
B)  security measures
C)  counterintelligence
D)  competitive intelligence C

Question 4

Reader's Digest Canada's use of data in order to gain a better understanding of its major market segments is an example of data mining.

Accepted Answer

A) True 
 B)False

Question 5

Public clouds are accessible to the ____________________ over the Internet.

Accepted Answer

The answer of Public clouds are accessible to the ____________________...

Question 6

In order to generate a report, Jane identifies the name of the database as well as the attributes.She then uses a set of commands and writes out a sentence to be executed.What is the term for this method of data manipulation?

Accepted Answer

A)  query by example
B)  direct command
C)  visual command
D)  structured query language

Question 7

The ____________________ is a collection of instructions and commands used to describe the logical and physical structure of the data and the relationships among the data for each user.

Accepted Answer

The answer of The ____________________ is a collection of instructions...

Question 8

The database administrator decides the contents of the database with little or no input from the users of the database.

Accepted Answer

A) True 
 B)False

Question 9

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Accepted Answer

A) True 
 B)False

Question 10

Competitive intelligence is gained through industrial espionage; the gathering of this information often includes illegal or unethical means.

Accepted Answer

A) True 
 B)False

Question 11

What type of database systems have companies such as IBM developed to allow different databases to work together as a unified system?

Accepted Answer

A)  relational
B)  distributed
C)  replicated
D)  virtual

Question 12

There are rules in Canada that require companies to report serious incidents related to their DBMS product once it is installed and used.Where would such a report, be sent?

Accepted Answer

A)  Statistics Canada
B)  Health Canada
C)  the provincial government
D)  the municipal government

Question 13

One of the rules at the university is that students are given an ID card bearing their names.The card is not transferable and if the student loses the card, it can be replaced for a fee.In data modelling, what is the relationship between student and ID card?

Accepted Answer

A)  one to one
B)  one to many
C)  many to one
D)  many to many

Question 14

Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data.

Accepted Answer

A) True 
 B)False

Question 15

Without a well-designed, accurate database, executives, managers, and others do not have access to the ____________________ they need to make good decisions.

Accepted Answer

The answer of Without a well-designed, accurate database, executives, managers,...

Question 16

Which of the following processes uses a database to store and access data according to the locations it describes, and permits related queries and analysis?

Accepted Answer

A)  data mining
B)  data modelling
C)  relational data extract
D)  spatial data technology

Question 17

A(n) ____________________ is typically a name, number, or combination of characters that describes an aspect of a business object.

Accepted Answer

The answer of A(n) ____________________ is typically a name, number,...

Question 18

What tool do database designers use to show the logical mapping among data?

Accepted Answer

A)  a framework
B)  a decision table
C)  a relational model
D)  a domain diagram

Question 19

Which of the following terms refers to the manipulation of data to gain increasing levels of detail about business conditions?

Accepted Answer

A)  aggregation
B)  drill down
C)  slicing
D)  extraction

Question 20

A(n) ____________________ is a field or set of fields that uniquely identifies a record.

Accepted Answer

The answer of A(n) ____________________ is a field or set...

Exam 5: Database Systems, Data Centres, and Business Intelligence

In the relational model, each row of a table represents a data entity or record and each column of the table represents an attribute or field.

Business intelligence turns data into useful information that is then kept closely guarded to prevent it falling into the hands of the wrong employees.

What is the term for the steps an organization takes to protect information sought by unauthorized parties?

Reader's Digest Canada's use of data in order to gain a better understanding of its major market segments is an example of data mining.

Public clouds are accessible to the ____________________ over the Internet.

In order to generate a report, Jane identifies the name of the database as well as the attributes.She then uses a set of commands and writes out a sentence to be executed.What is the term for this method of data manipulation?

The ____________________ is a collection of instructions and commands used to describe the logical and physical structure of the data and the relationships among the data for each user.

The database administrator decides the contents of the database with little or no input from the users of the database.

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Competitive intelligence is gained through industrial espionage; the gathering of this information often includes illegal or unethical means.

What type of database systems have companies such as IBM developed to allow different databases to work together as a unified system?

There are rules in Canada that require companies to report serious incidents related to their DBMS product once it is installed and used.Where would such a report, be sent?

One of the rules at the university is that students are given an ID card bearing their names.The card is not transferable and if the student loses the card, it can be replaced for a fee.In data modelling, what is the relationship between student and ID card?

Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data.

Without a well-designed, accurate database, executives, managers, and others do not have access to the ____________________ they need to make good decisions.

Which of the following processes uses a database to store and access data according to the locations it describes, and permits related queries and analysis?

A(n) ____________________ is typically a name, number, or combination of characters that describes an aspect of a business object.

What tool do database designers use to show the logical mapping among data?

Which of the following terms refers to the manipulation of data to gain increasing levels of detail about business conditions?

A(n) ____________________ is a field or set of fields that uniquely identifies a record.