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

Which of the following is not a level of data abstraction?

• Physical Level

• Critical Level

• Logical Level

• View Level

Disadvantages of File systems to store data is:

• Data redundancy and inconsistency

• Difficulty in accessing data

• Data isolation

• All of the above

Which of the following is not a Storage Manager Component?

• Transaction Manager

• Logical Manager

• Buffer Manager

• File Manager

Data Manipulation Language enables 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 a Data Model?

• Entity-Relationship model

• Relational data model

• Object-Based data model

• All of the above

Which of the following is not involved in DBMS?

• End Users

• Data

• Application Request

• HTML

The attribute refers to a _____ of a table

• Record

• Foreign key

• Primary key

• Field

Consider attributes ID, CITY and NAME. which one of these can be considered as a primary key?

• NAME

• ID

• CITY

• ID, NAME

Which one of these cannot be taken as a primary key?

• ID

• registration no

• Department ID

• Street