Database

The following are functions of a DBMS except

• Creating database
• Processing data
• Creating and processing forms
• Administrating database

The DBMS that most difficult to use is ________

• Microsofts SQL Server
• Oracle Corporation Oracle
• Microsoft Access
• IBM DB2

Duplicate data often results in loss of data integrity because:

• A. Data formats may be inconsistent
• B. Data values may not agree
• Neither A & B
• Both A & B

A database management system (DBMS) is a:

• Software system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide uncontrolled access to a database
• Software system used to create, maintain, and provide uncontrolled access to a database

A database application can perform which of the following activities?

• Add records
• Display / read records
• Update records
• All of the above

Data administrator are responsible for ________

• Overall management of data resources in an organization
• Physical data design
• Managing technical issues in the database environment
• Writing application program

Some advantages of the database approach include all, but:

• Minimal data redundancy
• Program-data dependency
• Improved data consistency
• Improved data sharing

A relational database consists of a collection of

• Field
• Record
• Table
• Keys

A_______ in a table represents a relationship among a set of values

• Field
• Foreign key
• Record
• Primary key

The term attribute refers to a ________ of a table

• Record
• Foreign key
• Primary key
• Field