Filters
Question type

Study Flashcards

In a traditional file processing approach,each business application is designed to use one or more specialized data files containing only specific types of data records.

A) True
B) False

Correct Answer

verifed

verified

A large database system is often distributed into smaller databases based on some logical relationship between the data and the location of the databases.

A) True
B) False

Correct Answer

verifed

verified

Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths?


A) Hierarchical
B) Network
C) Object-oriented
D) Relational

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

Correct Answer

verifed

verified

One drawback to the database duplication process is that no changes can ever be made to any database other than the master.Otherwise,local changes will be overwritten during the duplication process.

A) True
B) False

Correct Answer

verifed

verified

In a _______________ database structure,all of the relationships among records are one-to-many,because each data element is related to only one element above it.


A) hierarchical
B) relational
C) network
D) object-oriented

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

Correct Answer

verifed

verified

What type of database are employees using when they access online data banks,whether those data banks are free or paid for through subscriptions?


A) Common databases
B) Distributed databases
C) External databases
D) Local databases

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

Correct Answer

verifed

verified

According to the Real World Case,a well-run data center with reduced complexity _______________.


A) makes your firm a target for a predatory merger
B) actually makes a merger more difficult
C) makes a merger easier
D) is what Amazon.com is looking for in prospective associates

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

Correct Answer

verifed

verified

The _______________ model is the most widely used database structure today.


A) network
B) object-oriented
C) relational
D) hierarchical

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

Correct Answer

verifed

verified

According to the text,YouTube is an excellent example of _______________.


A) a social networking Web site
B) competition for Facebook
C) how simple it is to use and enjoy a database
D) an object-oriented database

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

Correct Answer

verifed

verified

In all information systems,data resources must be organized and structured in some logical manner,so that they can be:


A) Easily accessed
B) Processed efficiently
C) Retrieved quickly
D) All of the choices are correct.

E) A) and C)
F) A) and D)

Correct Answer

verifed

verified

Early mainframe DBMS packages used the _______________ structure,in which all records are dependent and arranged in multilevel structures,consisting of one root record and any number of subordinate levels.


A) network
B) relational
C) hierarchical
D) object-oriented

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

Correct Answer

verifed

verified

Database management packages based on the relational model can link data elements from various tables to provide information to users.

A) True
B) False

Correct Answer

verifed

verified

The primary challenge of a distributed database is:


A) Data accuracy
B) Data transmission speed
C) Storage costs
D) Data security

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

Correct Answer

verifed

verified

A database of data definitions and specifications is called a metadata repository,or a _______________.

Correct Answer

verifed

verified

_______________ is the most commonly used database application for the PC.


A) Oracle 10g
B) Microsoft Access
C) DB2
D) SQL Server

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

A record represents a collection of _______________ that describe an entity.


A) characters
B) fields
C) files
D) attributes

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

Correct Answer

verifed

verified

Entity Relationship Diagrams are _______________ of the various files and their relationships within a database system.

Correct Answer

verifed

verified

A website stores hyperlinked pages of multimedia (text,graphics,photographs,video,and audio)in a _______________ database.

Correct Answer

verifed

verified

In the relational database model,data are viewed as _______________.


A) DOS-like tree structures,also called branches
B) multidimensional combinations of data and their programs,also called encapsulations
C) three-dimensional tables,also called relatives
D) two-dimensional tables,also called relations

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

Correct Answer

verifed

verified

The project operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

A) True
B) False

Correct Answer

verifed

verified

Showing 81 - 100 of 108

Related Exams

Show Answer