Filters
Question type
Study Flashcards

Which kind of database stores data in dimensions?


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

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

A relational database developer refers to a record as a relation.

A) True
B) False

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
Information that can be proven as correct or incorrect.
Eight bits grouped together in a unit comprise this.
The more errors the data contains, the lower this is.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
What each byte represents in ASCII.
Information that has an age suited to its use.
Phrase that points out the accuracy of a computer's output depends on the accuracy of the input.
This type of information can lead to incorrect decisions.
Information that has meaning to the person who receives it.
Has special keywords and rules that users include in SQL statements.
Information that is arranged to suit the needs and requirements of the decision maker.
What is done to a record so the DBMS will not process it again.
Information that should give more value than it costs to produce.
A group of related fields.
Information that is error free.
In addition to storing data, a relational database also stores these.
While a user is working with the database, this resides in the memory of the computer.
This database capability is one of the more powerful database features.
Whether designed for a small or large computer, most DBMSs perform common ones.
A field that uniquely identifies each record in a file.
Responses
accurate
relationships
useful
functions
flagged
DBMS
verifiable
cost-effective
inaccurate
timely
character
byte
record
organized
integrity
GIGO
primary key
SQL
validation
querying

Correct Answer

Information that can be proven as correct or incorrect.
Eight bits grouped together in a unit comprise this.
The more errors the data contains, the lower this is.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
What each byte represents in ASCII.
Information that has an age suited to its use.
Phrase that points out the accuracy of a computer's output depends on the accuracy of the input.
This type of information can lead to incorrect decisions.
Information that has meaning to the person who receives it.
Has special keywords and rules that users include in SQL statements.
Information that is arranged to suit the needs and requirements of the decision maker.
What is done to a record so the DBMS will not process it again.
Information that should give more value than it costs to produce.
A group of related fields.
Information that is error free.
In addition to storing data, a relational database also stores these.
While a user is working with the database, this resides in the memory of the computer.
This database capability is one of the more powerful database features.
Whether designed for a small or large computer, most DBMSs perform common ones.
A field that uniquely identifies each record in a file.

The data in a database is independent of programs that access that data.

A) True
B) False

Correct Answer

verifed

verified

The data modeler creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.

A) True
B) False

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Which of the following does not improve with the database approach?


A) data integrity
B) data sharing
C) access
D) data security

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

A form that sends entered data across a network or the Internet is called which of the following terms?


A) i-form
B) e-form
C) webform
D) server form

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT You store all of your photographs on a website that uses a database to store the photos users post. What is this type of database called?


A) collaborative database
B) group database
C) social database
D) visual database

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

Critical Thinking Questions Case 11-2 In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?


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

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

A larger version of a data warehouse is the data mart.

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?


A) make the field a maximum of size characters
B) make it the default value
C) use AutoComplete
D) add a drop-down box

E) B) and C)
F) A) and C)

Correct Answer

verifed

verified

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


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

E) None of the above
F) A) and D)

Correct Answer

verifed

verified

Accurate information is error free.

A) True
B) False

Correct Answer

verifed

verified

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.

A) True
B) False

Correct Answer

verifed

verified

A user cannot override the default value.

A) True
B) False

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT What does the S in SQL stand for?


A) Server
B) System
C) Structured
D) Serial

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

COGNITIVE ASSESSMENT Which of the following integrates MRP II with the information flow across an organization to manage and coordinate the ongoing activities of the enterprise, including product planning, manufacturing and distribution, accounting and finance, sales, human resources, and customer support?


A) CMS
B) DMS
C) ERP
D) CAE

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

Showing 121 - 140 of 181

Related Exams

Exam 1

Digital Literacy: Introducing a World of Technology

181 Questions

Exam 2

The Internet: Accessing, Searching, Sharing, and Communicating

181 Questions

Exam 3

Computers and Mobile Devices: Evaluating the Possibilities

181 Questions

Exam 4

Programs and Apps: Using Software at Work, School, and Home

181 Questions

Exam 5

Digital Safety and Security: Identifying Threats, Issues, and Defenses

181 Questions

Exam 6

Inside Computers and Mobile Devices: Exploring the Components

181 Questions

Exam 7

Input and Output: Examining Popular Devices

181 Questions

Exam 8

Digital Storage: Preserving on Media and on the Cloud

181 Questions

Exam 9

Operating Systems: Managing, Coordinating, and Monitoring Resources

181 Questions

Exam 10

Communications and Networks: Sending and Receiving Digital Content

181 Questions

Exam 12

Information Systems and Program Development: Designing and Building Solutions

181 Questions

Show Answer