Activity 2

"The activities that focus on the design of the database structure that will be used to store and manage end-user data."

This statement refers to

Database system

Database design

Data anomaly

Data inconsistency

Listed below are the importance of Database Management Systems (DBMSs) EXCEPT:

DBMS helps create an environment for end users to have better access to more and better managed data.

DBMS contains a query language that makes it possible to produce ad hoc queries.

Improved data access makes it possible to generate lower quality information.

DBMS provides a framework for better enforcement of data privacy and security policies.

A ___________ refers to an organization of components that defines and regulates the collection, storage, management and use of data within a database environment.

Database system

Database management system

Database design

Data dictionary

“Adding a student email attribute to the STUDENT file requires the file
system programs to be modified to conform to the new file structure.”

The above statement refers to __________.

Structural dependence

Structural independence

Data dependence

Data independence

Below are the problems with the file system data processing EXCEPT __________.

Lengthy development times

Easily of getting quick answers

Complex system administration

Extensive programming

The Database System Environment consist of the following elements EXCEPT:

Data

Metadata

People

Procedures

DBMS stores definitions of data elements and relationships in a ____________.

Data Dictionary

Metadata

Data Storage

Data Management

Which of the following is the disadvantages of database systems?

Lower costs

Vendor independence

Management complexity

No maintenance

Which of the DBMS function that ensure the data safety and integrity?

Data storage management

Security management

Backup and recovery management

Data integrity management

What is the common database access languages that used by many vendors?

Software Query Language

Structured Query Language

Structured Database Language

System Database Language

Activity 2

More Quizzes