Introduction to Databases

What is the primary function of a database?

• To store backup
• To analyse data
• To store and organise information
• To store code

Which of the following is TRUE about flat-file databases?

• A flat-file database has only one table.
• A flat-file database has many tables that are not related to each other.
• A flat-file database has many tables connected to each other with a relation.
• A flat-file database has only no tables.

Which of the following is a programming language that customises and interacts with a database?

• Microsoft Access
• Microsoft Visual Basic
• Structured Query Language
• None of the above

Which of the following is a software that is used to create and manage database?

• My SQL
• Oracle
• Microsoft Access
• All of the above

What is structured data?

• Data that is stored in pre-defined format
• Data that is not stored in pre-defined format
• A unique identifier for record in a table
• A type of database

What is another name for a row in a database table?

• Record
• Field
• Data
• Column

Employee Number, Name, Gender etc are all what?

• Records
• Fields
• Data
• Columns

Which column in this table is best suited for a primary key?

• Employee Number
• Employee Name
• Date of Birth
• Salary

What is the function of a primary key?

• It uniquely identifies a record.
• It uniquely identifies a field.
• It uniquely identifies a table.
• It uniquely identifies a database.

Which of the following is true about a relational database?

• A database with one large table.
• A database with unique tables that are related to each other.
• A set of unique databases related to each other.
• A database with no tables.