Question 1

A(n) ____________________ is performed by end users and checks the new system to ensure that it works with actual data.

Accepted Answer

The answer of A(n) ____________________ is performed by end users...

Question 2

Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Accepted Answer

A)  theory of restriction 
B)  principle of least privilege 
C)  hierarchy of administration 
D)  protocol of access 
A)  theory of restriction 
B)  principle of least privilege 
C)  hierarchy of administration 
D)  protocol of access

Question 3

A database eliminates redundant data.

Accepted Answer

A) True 
 B)False

Question 4

What is the process of presenting data graphically as charts, maps, or other pictorial formats in order to understand the resulting information easily?

Accepted Answer

A)  data visualization 
B)  data integrity 
C)  data velocity 
D)  data relationships 
A)  data visualization 
B)  data integrity 
C)  data velocity 
D)  data relationships

Question 5

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

Accepted Answer

A)  object-oriented 
B)  object-relational 
C)  relational 
D)  multidimensional 
A)  object-oriented 
B)  object-relational 
C)  relational 
D)  multidimensional

Question 6

Match between columns
                        Premises: A working model of the proposed system's essential functionality.
Verifies that an application works with other applications.
What is done to a record so the DBMS will not process it again.
This database capability is one of the more powerful database features.
What each byte represents in ASCII.
Eight bits grouped together in a unit comprise this.
In addition to storing data, a relational database also stores these.
A group of related fields.
Information that has meaning to the person who receives it.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
A field that uniquely identifies each record in a file.
Has special keywords and rules that users include in statements.
Verifies that all programs in an application work together properly.
The collection and summarization of data, information, and deliverables.
The more errors the data contains, the lower this is.
Performed by end users and checks the new system to ensure that it works 
with actual data.
This type of information can lead to incorrect decisions.
Verifies that each individual program or object works by itself.
Whether designed for a small or large computer, most DBMSs perform common ones.
While a user is working with the database, this resides in the memory of the computer.

Accepted Answer

The Answer of documentation and character and validation and inaccurate is...

Question 7

With a distributed database, the data is accessible through a variety of servers.

Accepted Answer

A) True 
 B)False

Question 8

What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Accepted Answer

A)  byte 
B)  ID 
C)  field 
D)  data 
A)  byte 
B)  ID 
C)  field 
D)  data

Question 9

Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

Accepted Answer

A)  recovery disk 
B)  backup 
C)  index 
D)  log 
A)  recovery disk 
B)  backup 
C)  index 
D)  log

Question 10

Which of the following contains data about each file in the database and each field in those files?

Accepted Answer

A)  data administrator 
B)  DBMS 
C)  DBA 
D)  data dictionary 
A)  data administrator 
B)  DBMS 
C)  DBA 
D)  data dictionary

Question 11

One application that uses multidimensional databases is a data warehouse.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following identifies the quality of data in a database?

Accepted Answer

A)  file resolution 
B)  authenticated access 
C)  information dimensionality 
D)  data integrity 
A)  file resolution 
B)  authenticated access 
C)  information dimensionality 
D)  data integrity

Question 13

Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.

Accepted Answer

A) True 
 B)False

Question 14

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 distribution 
B)  data marketing 
C)  data warehouse 
D)  data analysis 
A)  data distribution 
B)  data marketing 
C)  data warehouse 
D)  data analysis

Question 15

A(n) ____________________  is an interpreted language that typically is easy to learn and use.

Accepted Answer

The answer of A(n) ____________________  is an interpreted language that...

Question 16

Many database programs today have a webpage as their back end.

Accepted Answer

A) True 
 B)False

Question 17

What is another term for data dictionary?

Accepted Answer

A)  index 
B)  repository 
C)  file 
D)  table 
A)  index 
B)  repository 
C)  file 
D)  table

Question 18

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

Accepted Answer

A)  QBA 
B)  SQL 
C)  QBE 
D)  schema 
A)  QBA 
B)  SQL 
C)  QBE 
D)  schema

Question 19

What company did Larry Ellison help found?

Accepted Answer

A)  Oracle 
B)  Sun Microsystems 
C)  Sybase 
D)  Microsoft 
A)  Oracle 
B)  Sun Microsystems 
C)  Sybase 
D)  Microsoft

Question 20

An application that supports a front-end program sometimes is called which of the following?

Accepted Answer

A)  back end 
B)  RDBMS 
C)  GUI 
D)  collaborative database 
A)  back end 
B)  RDBMS 
C)  GUI 
D)  collaborative database

A(n) ____________________ is performed by end users and checks the new system to ensure that it works with actual data.

Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

A database eliminates redundant data.

What is the process of presenting data graphically as charts, maps, or other pictorial formats in order to understand the resulting information easily?

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

With a distributed database, the data is accessible through a variety of servers.

What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

Which of the following contains data about each file in the database and each field in those files?

One application that uses multidimensional databases is a data warehouse.

Which of the following identifies the quality of data in a database?

Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.

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

A(n) ____________________ is an interpreted language that typically is easy to learn and use.

Many database programs today have a webpage as their back end.

What is another term for data dictionary?

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

What company did Larry Ellison help found?

An application that supports a front-end program sometimes is called which of the following?

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

A(n) ____________________ is performed by end users and checks the new system to ensure that it works with actual data.

Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

A database eliminates redundant data.

What is the process of presenting data graphically as charts, maps, or other pictorial formats in order to understand the resulting information easily?

You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

With a distributed database, the data is accessible through a variety of servers.

What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

Which of the following contains data about each file in the database and each field in those files?

One application that uses multidimensional databases is a data warehouse.

Which of the following identifies the quality of data in a database?

Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.

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

A(n) ____________________ is an interpreted language that typically is easy to learn and use.

Many database programs today have a webpage as their back end.

What is another term for data dictionary?

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

What company did Larry Ellison help found?

An application that supports a front-end program sometimes is called which of the following?

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