Database Concept 2

Statements in Figure 1 refer to __________________.

• Bit

• Byte

• Boolean

• Character

Which one of the statements below does NOT describe the information?

• Information is an organized, meaningful, and useful data

• Information can be displayed on screen or printed on paper.

• Information is a collection of data that allows access from the user.

• Results of calculation such as students’ result slip, income tax, and phone bill are examples of an information.

Large collection of digital structured data is called ___________________.

• file

• storage

• database

• DBMS

All listed below are limitations of file-based system EXCEPT _____________.

• data isolation

• data duplication

• data dependence

• compatible file format

Which of the statements is FALSE about traditional filing approach?

• Files are stored in cabinet.

• Searching process in file-based system can be done randomly.

• For security, they may lock or be located in secured areas of building.

• As organization grows, files become more simplified and keeping track of data becomes easier.

To delete record in a database table you would use ________________.

• data dictionary

• data definition language

• data manipulation language

• data management language

Statement in Figure 2 refers to __________________.

• data integrity

• data isolation

• data consistency

• data dependency

Data dictionary is ________________.

• a single piece of information from a record

• a set of data that describes and gives information about other data

• a file that stores definitions of data elements and data characteristics for a database

• A software package designed to define, manipulate, retrieve, and manage data in a database

Listed below are the advantages of DBMS except ___________.

• improve data security

• higher impact of system failure

• increase data sharing among authorized users

• more information from the same amount of data

Several related fields can be used to compose a ______________.

• bit

• field

• record

• character