Database Quiz 1 introduction

What is the primary function of a database?

• To store backup

• To analyse data

• To store and organise information

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.

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

6.The highlighted row is called a ………………….

• Record

• Field

• Data

7.What is the column with title “Date of joining” called?

• Record

• Field

• Data

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

• Employee number

• Employee name

• Date of birth

What is the function of a primary key?

• It uniquely identifies a record.

• It uniquely identifies a field.

• It uniquely identifies a table.

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.