Database Lesson 1

Which of the following is NOT a data type commonly used in databases?

• Integer

• Float

• Char

• Image

What is a 'Primary key' in the context of databases?

• A unique identifier for a record

• A type of data

• A method of sorting data

• A type of database

Which of the following is a floating-point data type?

• Integer

• Real

• Char

• Text

Which data type is used to store dates and times in databases?

• Integer

• Date, Time, Datetime

• Char

• Text

Which of the following data types can store a number with a decimal component?

• Integer

• Char

• Real

• Varchar

What is the data type used for storing a person's age?

• Varchar

• Integer

• Date

• Datetime

What is the data type used for storing the time a message was sent?

• Varchar

• Integer

• Date

• Datetime

What is the typical format for storing flat file databases?

• CSV (comma separated values)

• XML (extensible markup language)

• JSON (JavaScript object notation)

• SQL (structured query language)

Which of the following fields is NOT suitable to be a primary key due to lack of uniqueness?

• MobileNumber

• FirstName

• Social Security Number

• Email Address

Which field would most likely contain a person's surname?

• FirstName

• LastName

• Nickname

• PhoneNumber