MIS305 (Ch-6.1)

Record in database means a set of _____

• files

• fields

• bits

• bytes

Same attribute has different values in database means _______

• Data inconsistency

• Data redundancy

• Program-data dependence

• Data inflexibility

Which one is NOT true for Database management system (DBMS)?

• Solves problems of traditional file environment

• Separates logical and physical views of data

• Interfaces between applications and physical data files

• Creates good relationship between top level and low level management

Which operation does create subset of data of all records from a table?

• Select

• Join

• Project

• Partition

_____  is used to add, change, delete data from database.

• Data definition capability

• Data dictionary

• Data manipulation language

• Generation capabilities

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the  ____

• data dictionary

• data definition diagram

• entity-relationship diagram

• structured query language

Which of the following is not one of the main problems with a traditional file environment?

• data inconsistency

• program-data independence

• lack of flexibility in creating reports

• poor security

Which one is NOT correct for Database?

• Hardware

• Software

• Place

• Secured

Which one is NOT correct for DBMS?

• Software

• Hardware

• Tools

• Secured

We store information about ____

• a record

• an attribute

• an entity

• a field