Question 1

In the third normal form (3NF), a table has no ____________________ dependencies; that is, two fields that are not primary keys and are dependent on one another.

Accepted Answer

The answer of In the third normal form (3NF), a...

Question 2

In a column database, column orientation allows for a higher level of data ____________________ because there are often many similar, if not identical, entries in a single column.

Accepted Answer

The answer of In a column database, column orientation allows...

Question 3

____________________ databases are also known as Database-as-a-Service (DBaaS).

Accepted Answer

The answer of ____________________ databases are also known as Database-as-a-Service...

Question 4

Describe a purpose of databases and the functions of a database management system (DBMS).

Accepted Answer

The answer of Describe a purpose of databases and the...

Question 5

When designing a new database, sketching a(n) ____________________ of the reports and other desired database output can be helpful in identifying the fields that need to be included in the database.

Accepted Answer

The answer of When designing a new database, sketching a(n)...

Question 6

With a(n) ____________________, the data is separated into several databases, each of which is stored on a different computer that may be in different physical locations from one another but that are connected via a network.

Accepted Answer

The answer of With a(n) ____________________, the data is separated...

Question 7

In ____________________ organization, the order of the records is physically based on the content of the key field.

Accepted Answer

The answer of In ____________________ organization, the order of the...

Question 8

With indexed organization, a(n) ____________________ is used to keep track of where data is stored in a database.

Accepted Answer

The answer of With indexed organization, a(n) ____________________ is used...

Question 9

What is a NoSQL database?

Accepted Answer

The answer of What is a NoSQL database?...

Question 10

The growth and importance of data warehousing has led to another type of database model-the ______________________________.

Accepted Answer

The answer of The growth and importance of data warehousing...

Question 11

What are the major roles and responsibilities of database administrators?

Accepted Answer

The answer of What are the major roles and responsibilities...

Question 12

Explain the concepts of database entities and attributes.

Accepted Answer

The answer of Explain the concepts of database entities and...

Question 13

Data about data, such as the data contained in a data dictionary, is called ____________________ .

Accepted Answer

The answer of Data about data, such as the data...

Question 14

A(n) ____________________ script is a set of instructions written in a programming language and designed to accept data from and return data to a Web page visitor.

Accepted Answer

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

Question 15

Discuss the advantages and disadvantages of the DBMS approach.

Accepted Answer

The answer of Discuss the advantages and disadvantages of the...

Question 16

____________________ databases are located on a single computer and are designed to be accessed by one user.

Accepted Answer

The answer of ____________________ databases are located on a single...

Question 17

____________________ usually includes the programs used with the database and the programs needed to connect the client and server components of the database system.

Accepted Answer

The answer of ____________________ usually includes the programs used with...

Question 18

In Microsoft Access, tables can be created in either Datasheet view or ____________________ view.

Accepted Answer

The answer of In Microsoft Access, tables can be created...

Question 19

Upgrading the database software as needed and installing security patches as they become available is a database ____________________ activity.

Accepted Answer

The answer of Upgrading the database software as needed and...

Question 20

What is an in-memory database?

Accepted Answer

The answer of What is an in-memory database?...

Quiz 12: Databases and Database Management Systems