BUSI 335 - Management Information Systems Quiz #2

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.

 

 

 

 

q2_files/i0130000.jpg

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. 

The ____ property setting for number fields stores whole numbers from -32,768 to 32,767 in two bytes.

a.

Decimal

b.

Byte

c.

Long Integer

d.

Integer

 

 

 

 20. 

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

                  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