Database Concepts Quiz

Which of the following best describes the difference between a field and a record?

• A field stores all information about one item, while a record stores one type of information.

• A field is a column of one type of data, while a record is a row about one item.

• A record is a collection of tables, while a field is a table name.

• A record and a field mean the same thing.

A database table has a field called “Grade” set as Number. Which of these values would cause an error?

• 95

• 100

• A+

• 67

Which of the following is the BEST example of symbolic data?

• January

• 24567

• @#$%

• A12345

In Excel, what is the MAIN advantage of converting a list of student marks into a formatted table?

• It prevents users from editing data

• It automatically makes data alphabetic

• It allows easier sorting, filtering, and analysis

• It assigns ASCII codes to the marks

ASCII codes are important because they allow computers to:

• Store numbers more quickly

• Display characters by linking binary codes to letters, digits, and symbols

• Format tables into readable reports

• Translate data into databases

Which of these is an example of an entire record in a “Students” table?

• Name, Age, Class, Grade

• StudentID

• Date of Birth

• FirstName

Which of the following best describes the role of a database compared to a spreadsheet?

• Databases are only for numbers, while spreadsheets store all data types

• Databases manage large amounts of structured data more efficiently

• Spreadsheets can search faster than databases

• Spreadsheets are better for organizing student records

A field set as “Boolean (Yes/No)” would be BEST for storing:

• The student’s grade

• Whether tuition is paid or not

• The student’s name

• The student’s date of birth

In a school database, which of the following would be the MOST suitable primary key?

• First Name

• Student ID Number

• Grade

• Date of Birth

If a database designer accidentally stores “Phone Number” as Number instead of Text, what problem could occur?

• It may remove leading zeros from phone numbers

• It will prevent saving any numbers at all

• It will turn numbers into ASCII codes

• It will make the field act like a Boolean