Question 1

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 2

One goal of normalization is to ________.

Accepted Answer

A) duplicate essential information 
B) assign primary keys to every table 
C) reduce the number of foreign keys 
D) make data functionally dependent

Question 3

Describe performance tuning and the trade-offs associated with it.

Accepted Answer

The answer of Describe performance tuning and the trade-offs associated...

Question 4

Which product allows voice commands, sequenced like a natural conversation, as a means to access a database?

Accepted Answer

A) Yelp 
B) MySQL 
C) Oracle 
D) Siri

Question 5

Describe the most common strategy for creating a data warehouse.

Accepted Answer

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

Question 6

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 7

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

Question 8

A representation of an entity in a meaningful way, which includes the attributes of the entity, is called a ________.

Accepted Answer

A) field 
B) primary key 
C) data definition 
D) record

Question 9

While using a word processor to create a project report, Ashley includes the subject, title, and the author's name in the report's properties. What type of information is Ashley adding to her report?

Accepted Answer

A) metadata 
B) count data 
C) boolean data 
D) binary data

Question 10

________ 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 11

What are the database ownership issues faced by management at a typical company?

Accepted Answer

The answer of What are the database ownership issues faced...

Question 12

One of the uses of databases without boundaries is in ________.

Accepted Answer

A) handling online transactions of e-commerce websites 
B) hunting for hidden patterns and relationships in large amounts of data 
C) handling unstructured data during emergency disaster relief situations 
D) forming bridging databases between data warehouses and operational databases

Question 13

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 14

What is SQL?

Accepted Answer

The answer of What is SQL?...

Question 15

Which process assigns incremental numbers to records as they are created to ensure that each record has a unique primary key?

Accepted Answer

A) normalization 
B) scaling 
C) standardization 
D) autonumbering

Question 16

A foreign key is ________.

Accepted Answer

A) an attribute that is present in only one table 
B) a primary key which appears as an attribute in a different table 
C) a unique value or attribute that determines a primary key 
D) a field, or a group of fields, that makes each record unique in a table

Question 17

A person who ensures that people adhere to the definitions for the master data in their organizational units is called a(n)________.

Accepted Answer

A) data steward 
B) database administrator 
C) information systems educator 
D) management analyst

Question 18

Pieces of information that cannot be linked together are called ________.

Accepted Answer

A) unstructured information 
B) semi-structured information 
C) structured information 
D) secure information

Question 19

________ takes advantage of signals transmitted via the phone to access a database, retrieve account information, and enter data.

Accepted Answer

A) Structured query language 
B) Interactive voice response 
C) Electronic reported outcome 
D) Dialog system

Question 20

Roman Jade, an interior decorations company, stores employee details in its employee information system. The birth date of each employee is stored along with other details, including employee names. The relationship between the employee names and employee birth dates is a ________.

Accepted Answer

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

Exam 4: Databases and Datawarehouses