WorksheetsNormalisation 2
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
What is the primary purpose of a database?
a)
To create spreadsheets for calculations
b)
To manage email communications
c)
To display information in a graphical format
d)
To store data in an organized way
2.
Which of the following is a key advantage of using databases over spreadsheets?
a)
Databases allow for more complex data manipulation.
b)
Databases are less organized than spreadsheets.
c)
Databases can only store text data.
d)
Spreadsheets are better for large data sets.
3.
Which of the following statements is true regarding database tables?
a)
Tables can only contain text data.
b)
Each table must have a unique name.
c)
Tables do not need to be linked.
d)
Each table can have the same name.
4.
What does a primary key do in a database table?
a)
It stores multiple values in one field.
b)
It is used to sort data alphabetically.
c)
It uniquely identifies each record in the table.
d)
It links two tables together.
5.
What is a composite key in a database?
a)
A key that is not unique.
b)
A key that is made up of two or more columns.
c)
A key that is made up of one column.
d)
A key that is used to sort data.
6.
Which statement best describes a Database Management System (DBMS)?
a)
A DBMS is a programming language.
b)
A DBMS is used to manage data in a database.
c)
A DBMS is a type of spreadsheet software.
d)
A DBMS is only for small databases.
7.
Why is a DBMS important for a database?
a)
It is only used for small databases.
b)
It eliminates the need for data.
c)
It organizes and manages data effectively.
d)
It makes data meaningless.
8.
How does normalization help in database design?
a)
It increases the size of the database.
b)
It prevents duplicate or unreliable data.
c)
It eliminates the need for tables.
d)
It combines all data into a single table.
9.
What problem does normalization aim to prevent in databases?
a)
Data redundancy and inconsistency.
b)
Data loss during storage.
c)
Slow data retrieval times.
d)
Inability to link tables.
10.
What is the main goal of normalization in database design?
a)
To store data in a single format.
b)
To create larger tables.
c)
To divide larger tables into smaller ones.
d)
To link unrelated data.
100 %
