Question 1

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 A

Question 2

Match between columns
                        Premises: What each byte represents in ASCII.

Accepted Answer

The Answer of systems test and useful and character and is...

Question 3

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Accepted Answer

A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit 
A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit A

Question 4

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

Accepted Answer

A) True 
 B)False

Question 5

Software developers sometimes use the languages to maintain legacy systems.

Accepted Answer

A) True 
 B)False

Question 6

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

Accepted Answer

A) True 
 B)False

Question 7

COGNITIVE ASSESSMENT What is the term for a feature that has a graphical user interface to assist users with retrieving data?

Accepted Answer

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

Question 8

COGNITIVE ASSESSMENT What involves showing users exactly how they will use the new hardware and software in the system?

Accepted Answer

A)  converting 
B)  training 
C)  testing 
D)  acceptance 
A)  converting 
B)  training 
C)  testing 
D)  acceptance

Question 9

COGNITIVE ASSESSMENT You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. 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 10

COGNITIVE ASSESSMENT Which of the following is NOT a way that a DBMS deals with deleting records from a database?

Accepted Answer

A)  remove the record from the file immediately 
B)  records cannot be deleted from a DBMS 
C)  flags the record so that the DBMS will not process it again 
D)  running a program to remove records that have been marked as deleted 
A)  remove the record from the file immediately 
B)  records cannot be deleted from a DBMS 
C)  flags the record so that the DBMS will not process it again 
D)  running a program to remove records that have been marked as deleted

Question 11

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Accepted Answer

A)  field 
B)  member 
C)  record 
D)  identifier 
A)  field 
B)  member 
C)  record 
D)  identifier

Question 12

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Accepted Answer

A)  rollforward 
B)  rollbackward 
C)  continuous backup 
D)  instant restoration 
A)  rollforward 
B)  rollbackward 
C)  continuous backup 
D)  instant restoration

Question 13

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 14

With a(n)____________________, only one location in the organization uses the new system - so that it can be tested.

Accepted Answer

The answer of With a(n)____________________, only one location in the...

Question 15

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

Match between columns
                        Premises: Information that has meaning to the person who receives it.

Accepted Answer

The Answer of useful and character and proof of concept is...

Question 17

It often is easier and faster to develop programs that use the database approach.

Accepted Answer

A) True 
 B)False

Question 18

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

COGNITIVE ASSESSMENT What is a feature that has a graphical user interface to assist users with retrieving data?

Accepted Answer

A)  QBE 
B)  DBE 
C)  SQL 
D)  NoSQL 
A)  QBE 
B)  DBE 
C)  SQL 
D)  NoSQL

Question 20

A data model defines how users view the organization of data.

Accepted Answer

A) True 
 B)False

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

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

Software developers sometimes use the languages to maintain legacy systems.

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

COGNITIVE ASSESSMENT What is the term for a feature that has a graphical user interface to assist users with retrieving data?

COGNITIVE ASSESSMENT What involves showing users exactly how they will use the new hardware and software in the system?

COGNITIVE ASSESSMENT You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

COGNITIVE ASSESSMENT Which of the following is NOT a way that a DBMS deals with deleting records from a database?

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

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

With a(n)____________________, only one location in the organization uses the new system - so that it can be tested.

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

It often is easier and faster to develop programs that use the database approach.

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

COGNITIVE ASSESSMENT What is a feature that has a graphical user interface to assist users with retrieving data?

A data model defines how users view the organization of 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

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

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

Software developers sometimes use the languages to maintain legacy systems.

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

COGNITIVE ASSESSMENT What is the term for a feature that has a graphical user interface to assist users with retrieving data?

COGNITIVE ASSESSMENT What involves showing users exactly how they will use the new hardware and software in the system?

COGNITIVE ASSESSMENT You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

COGNITIVE ASSESSMENT Which of the following is NOT a way that a DBMS deals with deleting records from a database?

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

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

With a(n)____________________, only one location in the organization uses the new system - so that it can be tested.

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

It often is easier and faster to develop programs that use the database approach.

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

COGNITIVE ASSESSMENT What is a feature that has a graphical user interface to assist users with retrieving data?

A data model defines how users view the organization of 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