Database

A Database Management System (DBMS) is

• Collection of interrelated data

• Collection of programs to access data

• collection of data describing one particular enterprise

• all of the above

Disadvantages of file systems to store data is:

• Data redundancy and inconsistency

• difficulty in accessing the data

• data isolation

• all of the above

In an ERD diagram, rectangles represents

• Entity

• attributes

• database

• tables

Data manipulation language enable users to

• retrieval of information stored in database

• insertion of new information into the database

• deletion of information from the database

• all of the above

Which of the following is database language?

• Data definition language

• data manipulation language

• query language

• all of the above

which of the following represents a relationship among a set of values

• row

• table

• field

• column

Column header is refer as

• table

• relation

• attributes

• domain

Which of the following is not modification of the database

• deletion

• insertion

• sorting

• updating

Data Manipulation Language (DML) is not to

• Create information table in the Database

• Insertion of new information into the Database

• Deletion of information in the Database

• Modification of information in the Database

The minimal set of super key is called

• Primary key

• Secondary key

• Candidate key

• Foreign key