Filters
Question type
Study Flashcards

Discuss any three functions performed by the DBMS that guarantee the integrity and consistency of the data in the database.

Correct Answer

verifed

verified

(answers may vary)
*Data dictionary mana...

View Answer

The same data might be simultaneously structured and unstructured depending on the intended processing.

A) True
B) False

Correct Answer

verifed

verified

Raw data must be properly for storage, processing and presentation.

Correct Answer

verifed

verified

exists when different and conflicting versions of the same data appear in different places.

Correct Answer

verifed

verified

Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.

A) True
B) False

Correct Answer

verifed

verified

is the result of processing raw data to reveal its meaning.

Correct Answer

verifed

verified

What are the disadvantages of database systems?

Correct Answer

verifed

verified

Although the database system yields cons...

View Answer

Describe what metadata are and what value they provide to the database system.

Correct Answer

verifed

verified

The metadata describe the data character...

View Answer

Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

A) True
B) False

Correct Answer

verifed

verified

serve as the intermediary between the user and the database.


A) DBMSs
B) Metadata
C) End-user data
D) Programming languages

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

Correct Answer

verifed

verified

A

The database structure in a DBMS is stored as a .


A) single file
B) collection of files
C) set of key/value pairs
D) collection of queries

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

Correct Answer

verifed

verified

B

A workgroup database is a(n) database.


A) single-user
B) multiuser
C) desktop
D) distributed

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

Correct Answer

verifed

verified

The response of the DBMS to a query is the .


A) ad hoc query
B) ad hoc response
C) query result set
D) integrated view of the data

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

Correct Answer

verifed

verified

is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.


A) Data integrity
B) Data anomaly
C) Data ubiquity
D) Data quality

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

Correct Answer

verifed

verified

An operational database is sometimes referred to as an enterprise database.

A) True
B) False

Correct Answer

verifed

verified

The only way to access the data in a database is through the DBMS.

A) True
B) False

Correct Answer

verifed

verified

relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.


A) Performance tuning
B) Database design
C) Query access
D) Database management

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

Correct Answer

verifed

verified

An advantage of database systems is that you needn't perform frequent updates and apply latest patches.

A) True
B) False

Correct Answer

verifed

verified

Discuss some considerations when designing a database.

Correct Answer

verifed

verified

Proper database design requires the designer to identify precisely the database's expected use. Designing a transactional database emphasizes accurate and consistent data and operational speed. Designing a data warehouse database emphasizes the use of historical and aggregated data. Designing a database to be used in a centralized, single-user environment requires a different approach from that used in the design of a distributed, multiuser database. Designing appropriate data repositories of integrated information using the two-dimensional table structures found in most databases is a process of decomposition. The integrated data must be decomposed properly into its constituent parts, with each part stored in its own table. Further, the relationships between these tables must be carefully considered and implemented so the integrated view of the data can be re-created later as information for the end user. A well-designed database facilitates data management and generates accurate and valuable information. A poorly designed database is likely to become a breeding ground for difficult-to-trace errors that may lead to bad decision making-and bad decision making can lead to the failure of an organization. Database design is simply too important to be left to luck. That's why college students study database design, why organizations of all types and sizes send personnel to database design seminars, and why database design consultants often make an excellent living.

What are the advantages of having the DBMS between the end user's applications and the database?

Correct Answer

verifed

verified

Having a DBMS between the end user's app...

View Answer

Showing 1 - 20 of 76

Related Exams

Exam 2

Data Models

75 Questions

Exam 3

The Relational Database Model

75 Questions

Exam 4

Entity Relationship Er Modeling

75 Questions

Exam 5

Advanced Data Modeling

85 Questions

Exam 6

Normalization of Database Tables

110 Questions

Exam 7

Introduction to Structured Query Language Sql

111 Questions

Exam 8

Advanced Sql

109 Questions

Exam 9

Database Design

103 Questions

Exam 10

Transaction Management and Concurrency Control

85 Questions

Exam 11

Database Performance Tuning and Query Optimization

85 Questions

Exam 12

Distributed Database Management Systems

83 Questions

Exam 13

Business Intelligence and Data Warehouses

75 Questions

Exam 14

Database Connectivity and Web Technologies

85 Questions

Exam 15

Database Administration and Security

86 Questions

Show Answer