Database Basics v2 N5

Which field type can only be one of two possibilities?

• Boolean (Yes/No)

• Graphic (OLE Object)

• Date

• Time

Which field type can hold a picture?

• Boolean (Yes/No)

• Graphic (OLE Object)

• Date

• Time

How many fields are shown here?

• 5

• 7

• 11

• 35

How many records are shown here?

• 5

• 7

• 11

• 35

How have the results shown been sorted?

• On the 'Id' field in Descending order

• On the 'Id' field in Ascending order

• On the 'City' field in Descending order

• On the 'City' field in Ascending order

At which Stage of the Database Development Process would you identify the User Requirements and Functional Requirements?

• Analysis Stage

• Design Stage

• Implementation Stage

• Testing Stage

• Evaluation Stage

At which Stage of the Database Development Process would you create an Entity Relationship Diagram?

• Analysis Stage

• Design Stage

• Implementation Stage

• Testing Stage

• Evaluation Stage

At which Stage of the Database Development Process would you create a Data Dictionary?

• Analysis Stage

• Design Stage

• Implementation Stage

• Testing Stage

• Evaluation Stage

At which Stage of the Database Development Process would you plan what your queries will be by stating Tables, Fields, Search Criteria and Sort Order?

• Analysis Stage

• Design Stage

• Implementation Stage

• Testing Stage

• Evaluation Stage

At which Stage of the Database Development Process would you create database tables including fields and validation?

• Analysis Stage

• Design Stage

• Implementation Stage

• Testing Stage

• Evaluation Stage