Question 1

What is data redundancy?

Accepted Answer

A)  There is no primary key to distinguish records. 
B)  Each department has its own files, so the same data might be stored in multiple files. 
C)  Data is linked to multiple records in a database. 
D)  In the same database, each department enters data without checking to ensure it has not already been entered. 
A)  There is no primary key to distinguish records. 
B)  Each department has its own files, so the same data might be stored in multiple files. 
C)  Data is linked to multiple records in a database. 
D)  In the same database, each department enters data without checking to ensure it has not already been entered. B

Question 2

A data dictionary contains details about data. What term is used to describe this characteristic?

Accepted Answer

A)  omnidata 
B)  maxidata 
C)  metadata 
D)  duplidata 
A)  omnidata 
B)  maxidata 
C)  metadata 
D)  duplidata C

Question 3

A web database for an organization usually resides on a(n) ____________________.

Accepted Answer

database server

Question 4

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Accepted Answer

A)  data stockyard 
B)  data warehouse 
C)  data storehouse 
D)  data storage unit 
A)  data stockyard 
B)  data warehouse 
C)  data storehouse 
D)  data storage unit

Question 5

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Accepted Answer

A)  database 
B)  server 
C)  spreadsheet 
D)  webbase 
A)  database 
B)  server 
C)  spreadsheet 
D)  webbase

Question 6

Each higher level of data consists of one or more items from the lower level.

Accepted Answer

A) True 
 B)False

Question 7

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Accepted Answer

A) True 
 B)False

Question 8

Machine language is the only language the computer directly recognizes.

Accepted Answer

A) True 
 B)False

Question 9

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following statements best describes a form?

Accepted Answer

A)  a window on the screen that provides areas for entering or modifying data in a database 
B)  a formatted, printable retrieval of specific data 
C)  a screen that enables a database user to add or delete tables 
D)  the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data 
A)  a window on the screen that provides areas for entering or modifying data in a database 
B)  a formatted, printable retrieval of specific data 
C)  a screen that enables a database user to add or delete tables 
D)  the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data

Question 11

Which of the following consists of rules and standards that define how a database organizes data?

Accepted Answer

A)  data standard 
B)  data model 
C)  rules-based integration 
D)  object-relation 
A)  data standard 
B)  data model 
C)  rules-based integration 
D)  object-relation

Question 12

In a database which of the following is a connection within the data?

Accepted Answer

A)  table 
B)  column 
C)  row 
D)  relationship 
A)  table 
B)  column 
C)  row 
D)  relationship

Question 13

Which of the following is true about the database approach?

Accepted Answer

A)  Data in a database is less vulnerable than data in file processing systems. 
B)  Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data. 
C)  Business and home users often work with databases because of their numerous advantages. 
D)  A database is never more complex than a file processing system. 
A)  Data in a database is less vulnerable than data in file processing systems. 
B)  Unauthorized users are unable under any circumstances to gain access to a single database file that contains personal and confidential data. 
C)  Business and home users often work with databases because of their numerous advantages. 
D)  A database is never more complex than a file processing system.

Question 14

All DBMSs have built-in backup utilities.

Accepted Answer

A) True 
 B)False

Question 15

A compiler is a separate program that converts the entire source program into machine language before executing it.

Accepted Answer

A) True 
 B)False

Question 16

Most data items are stored in only one file, which greatly reduces _____.

Accepted Answer

A)  duplicate redundancy 
B)  duplicate data 
C)  hypertext redundancy 
D)  data relationships 
A)  duplicate redundancy 
B)  duplicate data 
C)  hypertext redundancy 
D)  data relationships

Question 17

Which of the following is a request for specific data from a database?

Accepted Answer

A)  query 
B)  index 
C)  ask 
D)  inquiry 
A)  query 
B)  index 
C)  ask 
D)  inquiry

Question 18

Which term does a user of a relational database use to refer to a record?

Accepted Answer

A)  row 
B)  table 
C)  column 
D)  attribute 
A)  row 
B)  table 
C)  column 
D)  attribute

Question 19

A DBMS uses which of the following to perform validation checks?

Accepted Answer

A)  data server 
B)  data mart 
C)  data warehouse 
D)  data dictionary 
A)  data server 
B)  data mart 
C)  data warehouse 
D)  data dictionary

Question 20

A relational database typically processes and summarizes large numbers of records efficiently.

Accepted Answer

A) True 
 B)False

What is data redundancy?

A data dictionary contains details about data. What term is used to describe this characteristic?

A web database for an organization usually resides on a(n) ____________________.

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Each higher level of data consists of one or more items from the lower level.

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Machine language is the only language the computer directly recognizes.

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

Which of the following statements best describes a form?

Which of the following consists of rules and standards that define how a database organizes data?

In a database which of the following is a connection within the data?

Which of the following is true about the database approach?

All DBMSs have built-in backup utilities.

A compiler is a separate program that converts the entire source program into machine language before executing it.

Most data items are stored in only one file, which greatly reduces _____.

Which of the following is a request for specific data from a database?

Which term does a user of a relational database use to refer to a record?

A DBMS uses which of the following to perform validation checks?

A relational database typically processes and summarizes large numbers of records efficiently.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security Ethics and Privacy

Computing Components

Input and Output

Digital Storage

Operating Systems

Communicating Digital Content

Working in the Enterprise

Focus on Web Development

Practice Test for Mindtap

Filters

Exam 11: Building Solutions

What is data redundancy?

A data dictionary contains details about data. What term is used to describe this characteristic?

A web database for an organization usually resides on a(n) ____________________.

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Each higher level of data consists of one or more items from the lower level.

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

Machine language is the only language the computer directly recognizes.

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

Which of the following statements best describes a form?

Which of the following consists of rules and standards that define how a database organizes data?

In a database which of the following is a connection within the data?

Which of the following is true about the database approach?

All DBMSs have built-in backup utilities.

A compiler is a separate program that converts the entire source program into machine language before executing it.

Most data items are stored in only one file, which greatly reduces _____.

Which of the following is a request for specific data from a database?

Which term does a user of a relational database use to refer to a record?

A DBMS uses which of the following to perform validation checks?

A relational database typically processes and summarizes large numbers of records efficiently.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security Ethics and Privacy

Computing Components

Input and Output

Digital Storage

Operating Systems

Communicating Digital Content

Working in the Enterprise

Focus on Web Development

Practice Test for Mindtap

Filters