G10 Introduction to Database

File systems have better storage techniques that databases

• True

• False

A secondary key is used in the database to prevent duplication of records.

• True

• False

Answer explanation

It is PRIMARY Key

Data integrity is assured in a database by using validation techniques.

• True

• False

Answer explanation

It is PRIMARY Key

A record consists of various tables. Each record consists of several fields.

• True

• False

Answer explanation

A Table consist of records

Tick all the advantages of database

• Databases are better storage techniques compared to file systems.

• The data is only stored once and, hence, data duplication is avoided.

• The data is consistent as the changes need to be made only once. These changes are then reflected for all the users using the database.

• The data isn't consistent as the changes need to be made only once. These changes won't be reflected for all the users using the database.

• The data can be stored many times duplication is inevitable

Answer explanation

A Table consist of records

Tick all description of the Primary key

• To prevent data duplication of each record.

• may be just numbers or a combination of letters and numbers.

• It is unique among other data in the record

• It can be automatically generated

• The data can be stored many times duplication is inevitable

Answer explanation

A Table consist of records

Data integrity is assured in a database by using ______ ________.

What validation technique it is.

The must be 1 character only

• Length Check

• Format Check

• Presence Check

• Type Check

• Double - entry

What validation technique it is.

Only 'M' or 'F'

• Length Check

• Format Check

• Presence Check

• Type Check

• Double - entry

What validation technique it is.

The fields cannot be left blank

• Length Check

• Format Check

• Presence Check

• Type Check

• Double - entry