Filters
Question type

Study Flashcards

Each member of a workgroup accesses data located on a database server.

Correct Answer

verifed

verified

Data that describe the properties of other data are:


A) relationships.
B) logical.
C) physical.
D) metadata.

Correct Answer

verifed

verified

E. F. Codd developed the relational data model during the 1970s.

Correct Answer

verifed

verified

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

Correct Answer

verifed

verified

A user view is how the user sees the data when it is produced.

Correct Answer

verifed

verified

A data warehouse derives its data from:


A) on-line transactions.
B) various operational data sources.
C) reports.
D) a datamart.

Correct Answer

verifed

verified

Metadata are data that describe the properties of other data.

Correct Answer

verifed

verified

Redundancy increases the risk of inconsistent data.

Correct Answer

verifed

verified

The term legacy system refers to a newly installed database management system.

Correct Answer

verifed

verified

Many of the disadvantages of file processing systems can also be limitations of databases.

Correct Answer

verifed

verified

The need for consensus on data definitions is an example of which type of risk in the database environment?


A) Specialized personnel needs
B) Organizational conflict
C) Conversion costs
D) Legacy systems

Correct Answer

verifed

verified

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.


A) planning
B) design
C) analysis
D) implementation

Correct Answer

verifed

verified

A workgroup database is stored on a central device called a:


A) client.
B) server.
C) remote PC.
D) network.

Correct Answer

verifed

verified

A constraint is a rule in a database system that can be violated by users.

Correct Answer

verifed

verified

The three-schema approach includes which of the following schemas?


A) Internal
B) Logical
C) Cross-functional
D) Dissecting

Correct Answer

verifed

verified

Personal databases are designed to support a small group of individuals working together on a project.

Correct Answer

verifed

verified

Which of the following is NOT an advantage of database systems?


A) Redundant data
B) Program-data independence
C) Better data quality
D) Reduced program maintenance

Correct Answer

verifed

verified

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

Correct Answer

verifed

verified

________ is the most popular RDMS data model notation.


A) ERD
B) END
C) DRE
D) RED

Correct Answer

verifed

verified

The most common source of database failures in organizations is:


A) lack of planning.
B) inadequate budget.
C) inadequate hardware.
D) failure to implement a strong database administration function.

Correct Answer

verifed

verified

Showing 61 - 80 of 116

Related Exams

Show Answer