Weekly Assesment on Databases and Pseudocode

Which data type in MS Access automatically assigns a unique number to each record?

• Text

• Currency

• Autonumber

• Lookup

What data type would be most appropriate for storing a student's age in a database?

• Text

• Autonumber

• Integer

• Yes/No

Why is it important to assign the correct data type to a field in a database?

• To make the database visually appealing

• To prevent users from editing data

• To ensure data can be processed correctly

• To reduce the size of the database

Which of the following is an example of a primary key field?

• Student's age

• Student's address

• StudentID (Autonumber)

• Student's grade

What is the purpose of validation rules in databases?

• To organize data into tables

• To ensure only valid data is entered into a database

• To sort data in ascending order

• To automatically assign primary keys

Which validation check ensures that an important data field is not omitted?

• Type check

• Format check

• Presence check

• Range check

What is an example of a range check?

• Ensuring a student's grade is between 1 and 8

• Ensuring a student's surname starts with an uppercase letter

• Ensuring all required fields are filled

• Ensuring data matches the assigned data type

What does a format check do?

• Ensures data is within an upper and lower limit

• Ensures data matches a fixed pattern

• Ensures important data fields are not omitted

• Ensures only numbers are entered

Which of the following describes a type check?

• Ensuring text starts with a capital letter

• Ensuring data matches the correct data type

• Ensuring values are within a specific range

• Ensuring no field is left blank

What is pseudocode?

• A programming language used for coding

• A simplified, plain-language way to describe algorithms

• A diagram that represents processes

• An error in the code