Database Management System

The following are the functions of a DBMS except

• Creating database

• Processing data

• Creating and processing forms

• Administrating database

The term _____ is used to refer a row

• Record

• Primary key

• Foreign 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 the following is NOT an advantage of DBMS

• Increased data consistency

• Reduced data redundancy

• Improved data security

• Increase data isolation

Which of the following gives a logical structure of the database graphically?

• Entity - relationship diagram

• Entity diagram

• Database diagram

• Architectural representation

If you were collecting and storing information about your music collection, an album would be considered a/an _______

• Relation

• Instance

• Entity

• Attribute

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

The term attribute refers to a ________ of a table

• Record
• Foreign key
• Primary key
• Field

The term _______ is used to refer a row

• Record
• Foreign key
• Primary key
• Field

Disadvantages of File systems to store data is:

• Data redundancy and inconsistency

• Difficulty in accessing data

• Data isolation

• All of the above