Introduction To Database Grade 7

The following are functions of a DBMS except

• Creating database
• Processing data
• Creating and processing forms
• Administrating database

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

A database application can perform which of the following activities?

• Add records
• Display / read records
• Update records
• All of the above

A relational database consists of a collection of

• Field
• Record
• Table
• Keys

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

Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?

• NAME
• ID
• CITY
• ID, NAME

Which one of the following should be taken as a primary key?

• Name
• DepartmentID
• Department
• Street

which one of the following cannot be taken as a primary key?

• ID
• RegistrationNo
• DepartmentID
• Street

A attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.

• Record
• Foreign key
• Primary key
• Field