More on database objects

Which software is used to store and manage database?

• OpenOffice Writer

• OpenOffice Calc

• OpenOffice Database

• None of the above

In a database, Multiple _________ can be created.

• Tables

• Documents

• Primary Key

• All of these

___________________ Key uniquely identifies each record in table.

• Fields

• Record

• Row

• Primary

What is a field in a related database table that refers to the primary key in the primary table?

• Secondary key

• Table key

• Foreign key

• Common key

How many characters are allowed in the Text field?

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

You have to enter Sam's DOB, What datatype would you use for this field.

To find pupils who scored more than 50%

Search to find pupils' who attained a mark of 45% and above and 65% and below

Given below relationships:

Adam learn Computer Science

Ai Ling learn Geography

Anatasia learn History

State related entities for statements above.

• Subject

• Subject & Student

• Subject, Student & Learn

• Student