Question 1

In a relational database, information is organized into tables in which each row represents a(n) ________.

Accepted Answer

A)  record 
B)  field 
C)  attribute 
D)  primary key

Question 2

In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

Accepted Answer

A) True 
 B)False

Question 3

While creating a relational database for an organization, "Employees" would constitute one attribute with employee ID number, last name, first name, birth date, email address, and phone number as entities.

Accepted Answer

A) True 
 B)False

Question 4

The process by which users are directed to a copy of the database when the main one fails is called ________.

Accepted Answer

A)  mirroring 
B)  threading 
C)  tuning 
D)  scaling

Question 5

A company maintains a centralized repository of information from internal sources, competitor information, census reports, and metadata from documents and multimedia. This is known as a ________.

Accepted Answer

A)  data dictionary 
B)  data model 
C)  data warehouse 
D)  database shard

Question 6

Describe the most common strategy for creating a data warehouse.

Accepted Answer

The answer of Describe the most common strategy for creating...

Question 7

The data collected by online pop-up surveys can be considered to be high-quality data.

Accepted Answer

A) True 
 B)False

Question 8

________ is a prepackaged data warehouse solution offered by vendors that includes the hardware and software, maintenance, and support.

Accepted Answer

A)  Virtual federated appliance 
B)  Shadow systems 
C)  Relational database 
D)  Data warehouse appliance

Question 9

Structured query language is a standard query language ________.

Accepted Answer

A)  used to manipulate information in relational databases 
B)  that uses the signals transmitted via the phone to access databases 
C)  that offers voice commands as a means to access a database 
D)  used to enhance security, plan capacity requirements, and design backup

Question 10

What is SQL?

Accepted Answer

The answer of What is SQL?...

Question 11

In comparison with unstructured information, semi-structured information ________.

Accepted Answer

A)  is more difficult to break down 
B)  has no inherent order 
C)  is easier to query and aggregate 
D)  is more difficult to link together

Question 12

White and Brown, a legal firm, stores details of each case in physical files and folders. The firm has a back room stacked with boxes containing hundreds of files. White and Brown's storage structure resembles ________.

Accepted Answer

A)  semi-structured information 
B)  unstructured information 
C)  meta data 
D)  relational data

Question 13

When a user clicks "SUBMIT" on a web-based survey, the record is inserted into the database through an SQL command.

Accepted Answer

A) True 
 B)False

Question 14

A blog with a title, subtitle, content with date of creation, and a few images exemplifies semi-structured information.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is a function of normalization?

Accepted Answer

A)  assigning primary keys 
B)  assigning incremental numbers to records 
C)  minimizing duplication of information 
D)  decreasing the functional dependency of data

Question 16

Database developers should use meaningful information for primary keys.

Accepted Answer

A) True 
 B)False

Question 17

The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________.

Accepted Answer

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

Question 18

Which of the following is the best way to handle complex relationships, such as the data for a company where employees can be assigned to more than one project, and each project can have more than one employee assigned to it?

Accepted Answer

A)  creating two or more records for the employee, each of which lists a different project 
B)  including multiple project fields, such as project 1, project 2, and so on, for the employee 
C)  normalizing the relationship between "employees" records and "projects" records 
D)  making the relationship between "employees" records and "projects" records hierarchically dependent

Question 19

________ specifies the characteristics of a field, such as the type of data it will hold.

Accepted Answer

A)  Data definition 
B)  A record 
C)  Database architecture 
D)  An entity

Question 20

When building a warehouse, the process of reformatting data so that it conforms to set standards is called ________.

Accepted Answer

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

Exam 4: Databases and DataWarehouses

In a relational database, information is organized into tables in which each row represents a(n) ________.

In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

While creating a relational database for an organization, "Employees" would constitute one attribute with employee ID number, last name, first name, birth date, email address, and phone number as entities.

The process by which users are directed to a copy of the database when the main one fails is called ________.

A company maintains a centralized repository of information from internal sources, competitor information, census reports, and metadata from documents and multimedia. This is known as a ________.

Describe the most common strategy for creating a data warehouse.

The data collected by online pop-up surveys can be considered to be high-quality data.

________ is a prepackaged data warehouse solution offered by vendors that includes the hardware and software, maintenance, and support.

Structured query language is a standard query language ________.

What is SQL?

In comparison with unstructured information, semi-structured information ________.

White and Brown, a legal firm, stores details of each case in physical files and folders. The firm has a back room stacked with boxes containing hundreds of files. White and Brown's storage structure resembles ________.

When a user clicks "SUBMIT" on a web-based survey, the record is inserted into the database through an SQL command.

A blog with a title, subtitle, content with date of creation, and a few images exemplifies semi-structured information.

Which of the following is a function of normalization?

Database developers should use meaningful information for primary keys.

The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________.

Which of the following is the best way to handle complex relationships, such as the data for a company where employees can be assigned to more than one project, and each project can have more than one employee assigned to it?

________ specifies the characteristics of a field, such as the type of data it will hold.

When building a warehouse, the process of reformatting data so that it conforms to set standards is called ________.