Question 1

Match between columns
                        Premises: Verifies that all programs in an application work together properly.

Accepted Answer

The Answer of DBMS and acceptance test and unit test is...

Question 2

In a file processing system, each department or area in an organization shares files collectively.

Accepted Answer

A) True 
 B)False

Question 3

The purpose of the ____________________ phase is to provide ongoing assistance for an information system and its users after the system is implemented.

Accepted Answer

support an

Question 4

Match between columns
                        Premises: Performed by end users and checks the new system to ensure that it works 
with actual data.

Accepted Answer

The Answer of proof of concept and primary key and is...

Question 5

Match between columns
                        Premises: Verifies that an application works with other applications.

Accepted Answer

The Answer of integrity and byte and useful and proof is...

Question 6

COGNITIVE ASSESSMENT 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.

Question 7

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

Accepted Answer

A)  backward 
B)  restorative 
C)  undo 
D)  model 
A)  backward 
B)  restorative 
C)  undo 
D)  model

Question 8

Big Data refers to large-scale data sets that require advanced technologies.

Accepted Answer

A) True 
 B)False

Question 9

The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is an item that contains data, as well as the actions that read or process the data?

Accepted Answer

A)  object 
B)  hyperlink 
C)  action link 
D)  event 
A)  object 
B)  hyperlink 
C)  action link 
D)  event

Question 11

Match between columns
                        Premises: A field that uniquely identifies each record in a file.

Accepted Answer

The Answer of useful and integration test and primary key is...

Question 12

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 13

Data integrity is important because computers and people use information to make decisions and take actions.

Accepted Answer

A) True 
 B)False

Question 14

Which kind of database stores data in dimensions?

Accepted Answer

A)  hypermedia 
B)  hypercube 
C)  multidimensional 
D)  integrated 
A)  hypermedia 
B)  hypercube 
C)  multidimensional 
D)  integrated

Question 15

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Accepted Answer

A)  restoration principle 
B)  forward recovery 
C)  continuous backup 
D)  rollback 
A)  restoration principle 
B)  forward recovery 
C)  continuous backup 
D)  rollback

Question 16

Which of the following is a query language that allows users to manage, update, and retrieve data?

Accepted Answer

A)  XML 
B)  DBMS 
C)  SQL 
D)  QBE 
A)  XML 
B)  DBMS 
C)  SQL 
D)  QBE

Question 17

COGNITIVE ASSESSMENT 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 18

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

Accepted Answer

The answer of In a database, the data ____________________ specifies...

Question 19

Match between columns
                        Premises: In addition to storing data, a relational database also stores these.

Accepted Answer

The Answer of functions and documentation and data relationships and is...

Question 20

Query by example uses a graphical user interface that assists users with retrieving data.

Accepted Answer

A) True 
 B)False

In a file processing system, each department or area in an organization shares files collectively.

The purpose of the ____________________ phase is to provide ongoing assistance for an information system and its users after the system is implemented.

COGNITIVE ASSESSMENT What is data redundancy?

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

Big Data refers to large-scale data sets that require advanced technologies.

The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps.

Which of the following is an item that contains data, as well as the actions that read or process the data?

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

Data integrity is important because computers and people use information to make decisions and take actions.

Which kind of database stores data in dimensions?

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Which of the following is a query language that allows users to manage, update, and retrieve data?

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

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

Query by example uses a graphical user interface that assists users with retrieving data.

Introducing Today S 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

In a file processing system, each department or area in an organization shares files collectively.

The purpose of the ____________________ phase is to provide ongoing assistance for an information system and its users after the system is implemented.

COGNITIVE ASSESSMENT What is data redundancy?

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

Big Data refers to large-scale data sets that require advanced technologies.

The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps.

Which of the following is an item that contains data, as well as the actions that read or process the data?

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

Data integrity is important because computers and people use information to make decisions and take actions.

Which kind of database stores data in dimensions?

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

Which of the following is a query language that allows users to manage, update, and retrieve data?

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

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

Query by example uses a graphical user interface that assists users with retrieving data.

Introducing Today S 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