Make your own free website on Tripod.com

 

True/False :   Indicate whether the sentence or statement is true or false.

____       1.      Every table defined in Access must have a primary key.

 

____       2.      A primary key that consists of more than one field is called a composite key.

 

____       3.      A common field is a field that is defined as a primary key in one table and is defined as a

                        foreign key in a second table.

 

____       4.      A field name must be unique within a database.

 

____       5.      A field name can begin with any character, including spaces and special characters.

 

____       6.      Access processes smaller data sizes faster than larger ones, using less memory, so you

                        can optimize your database's performance and its storage space by selecting the correct

                        field size for each field.

 

____       7.      You may specify a duplicate value for a primary key if the field is also defined as a

                        foreign key in another table.

 

____       8.      Records in a table are stored on disk in the order they are entered but are displayed in

                        primary key sequence.

 

____       9.      A primary key is allowed to have a null value.

 

____       10.     Certain Access data types have a predefined field size that cannot be changed.

 

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

Figure 2-3

 

____          11.  Given a relationship between the two tables in Figure 2-3, in the Position table shown, the ____ field is a redundant field.

a.

PositionID

b.

EmployerID

c.

PositionTitle

d.

EmployerName

 

 

____          12.  A field name ____.

a.

must be unique within a table

b.

can be up to 128 characters long

c.

must start with a space

d.

All of the above

 

 

____          13.  Which option from the New Table dialog box would you select if you wanted to define a table yourself from start to finish?

a.

Design View

b.

Link Table

c.

Table Wizard

d.

Datasheet View

 

 

____          14.  To begin creating a new table, click the ____ button in the Database window.

a.

Open

b.

New

c.

Help

d.

Design

 

 

____          15.  If you make a mistake when entering data in a field, you can erase the characters to the left of the insertion point by pressing the ____ key.

a.

left arrow

b.

Tab

c.

Delete

d.

Backspace

 

 

____          16.  A field defined as a yes/no field type will be displayed as a ____.

a.

radio button

b.

Y or N

c.

check box

d.

null value

 

 

____          17.  To delete a record from a table, click the ____.

a.

field selector for any field

b.

Cancel button after selecting the row

c.

row selector for the record to be deleted and then click the Delete Record button on the Table Datasheet toolbar

d.

row selector for the Field Name row

 

 

____          18.  In navigation mode, anything you type in a field ____.

a.

adds or deletes characters depending on the location of the insertion point

b.

is added to the end of the current field value

c.

replaces the previous value

d.

repositions the record within the database

 

 

 

 

____          19.  You move from text box to text box when designing a table in Design view by pressing the ____ key.

a.

F1

b.

Esc

c.

Tab

d.

Alt

____    20.        Which sequence represents the hierarchy of terms from smallest to largest?

a.

Database, table, record, field.

b.

Field, record, database table

c.

Record, field, table, database

d.

Field, record, table, database

____          21.  The 3 major models of logical data structures discussed in Chapter 12 are the following

                                                EXCEPT ____________.

a.

Hierarchical, Network  &  Relational models

b.

Network, Tree & Branch models

c.

Network, Relational & Tree models

d.

(a) and (c) only

____          22.  The main reasons why database management systems are needed are the following

                                                EXCEPT __________.

a.

Integrate various applications within the system.

b.

Standardize various applications within the system.

c.

Provide security for the system

d.

All the above are reasons.

____          23.  ____________________ is used both alone and with DBMS s to centralize, document, control, and co-ordinate the use of data within an organization

a.

Data Independence

b.

Data Documentation

c.

Data Dictionaries

d.

Data Redundancy Report

____          24.  The elements of database environment in database management systems include the following EXCEPT ____________.

a.

Data Administration & Users

b.

Database Technology & Management

c.

Data Planning & Modeling Methodology

d.

All of the above are elements.

____          25.  When creating a brand new database model, you used abstract and business perspective

                                                to design through understanding & establishing users’ needs.  This form of database

                                                design is known as _________________.

a.

Physical Design

b.

Conceptual Design

c.

Detailed Design

d.

Entity-Relationship Design