Database Quiz

What is a database?

• A type of software

• A collection of data

• A programming language

• A hardware device

Which one of these is NOT a database?

• Book

• Catalogue

• Yellow Pages

Explain why your answer to the previous question is NOT a database.

• It lacks structured data storage.

• It does not support SQL queries.

• It is not a software application.

• It does not have a schema.

What is a record?

• A collection of related data fields

• A type of music album

• A method of storing video

• A type of sports achievement

A field is:

• A region of space characterized by a physical property

• A type of plant

• A mathematical term for a set of numbers

• A type of sports ground

Can you name three advantages of a computerized database over a paper-based version?

• Faster data retrieval, easier data management, and better data security

• Requires more physical storage space, slower data retrieval, and less secure

• More prone to data loss, difficult to update, and requires manual sorting

• Limited access, higher costs, and increased error rates

Name two different data types used in databases.

• Integer and String

• Boolean and Date

• Float and Character

• Array and Object

What kind of data type would the field "Telephone Number" be and why?

• String, because telephone numbers can contain special characters like '+' and '-'

• Integer, because telephone numbers are numeric

• Float, because telephone numbers can have decimal points

• Boolean, because telephone numbers are either true or false

What is the primary purpose of a database management system (DBMS)?

• To create and manage databases

• To design websites

• To develop mobile applications

• To perform data analysis

Which of the following is a common operation performed on a database?

• Data insertion

• Data deletion

• Data update

• All of the above