Database Management

Which statement best describes a database?

• A collection of tables

• Tables that are in a sequence

• Tables of related information

• A collection of related tables

Possibility High School maintains a database containing tables related to its students and the subjects offered. Which of the following represents a table within that database?

• A student's name

• A student's record

• All the personal data on students

• The age of a student

Which is ONE difference between the alphanumeric and numeric data types?

• Alphanumeric represents quantities, unlike numeric, which represents labels only.

• Alphanumeric represents labels and quantities, unlike numeric, which represents labels only.

• Alphanumeric does not represent quantities, unlike numeric, which represents quantities.

• Alphanumeric represents labels, unlike numeric, which represents quantities only.

Questions 4-8 are based on the following table.

In what view is the table being displayed?

• Design

• Datasheet

• Normal

• Print preview

How many records are displayed in the table?

• 6;

• 7;

• 8;

• 9;

How many different field types are used to store the data?

• 2;

• 3;

• 4;

• 5;

Consider the following statements and state which are TRUE.

I The customerNo field type is Text.

II The customerNo field is Numeric

III Data in text fields is lift-aligned

IV Data in numeric fields is left-alighned

• I and III

• I and IV

• II and III

• II and IV

How many fields are in the table?

• 6;

• 7;

• 8;

• 9;

How many records would be selected if the query "Select* FROM customers WHERE CreditLimit>40000 is run?

• 6;

• 7;

• 8;

• 9;