wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

KS5 Databases mmd

Total questions: 101

Worksheet time: 47mins

Name
Class
Date
1.
What is a relational database?
a)
A database which recognises the difference between entities and uses different tables for each entity.
b)
A database that consists of a single file, usually about one entity
c)
A unique identifier for each record in a table.
d)
The attribute which links two tables together
e)
An index other than the primary key used to search and sort through the database with more convenience and speed.
2.
What is an entity?
a)
An item of interest about which information is stored.
b)
A unique identifier for each record in a table.
c)
The attribute which links two tables together
d)
An index other than the primary key used to search and sort through the database with more convenience and speed.
3.
What is a flat file?
a)
A database that consists of a single file, usually about one entity
b)
A database which recognises the difference between entities and uses different tables for each entity.
c)
A unique identifier for each record in a table.
d)
The attribute which links two tables together
e)
An index other than the primary key used to search and sort through the database with more convenience and speed.
4.
What is a primary key?
a)
A unique identifier for each record in a table.
b)
The attribute which links two tables together
c)
An index other than the primary key used to search and sort through the database with more convenience and speed.
d)
An item of interest about which information is stored.
5.
What is a foreign key?
a)
The attribute which links two tables together
b)
An index other than the primary key used to search and sort through the database with more convenience and speed.
c)
A unique identifier for each record in a table.
d)
An item of interest about which information is stored.
6.
What is a secondary key?
a)
An index other than the primary key used to search and sort through the database with more convenience and speed.
b)
A unique identifier for each record in a table.
c)
The attribute which links two tables together
d)
An item of interest about which information is stored.
7.
What does capturing data mean?
a)
The process of getting the information that will be stored in the database.
b)
the process of removing excess information to extract only the data you require.
c)
To manipulate the information collected in any type of way such as through sorting through it or selecting certain parts using SQL.
d)
finding the similarities or patterns among small, decomposed problems that can help us solve more complex problems more efficiently
e)
the process of filtering out – ignoring - the characteristics of patterns that we don't need in order to concentrate on those that we do
8.
What method do banks use to capture data from cheques?
a)
Magnetic Ink Character Recognition (MICR) is used for all of the details apart from the amount which must be entered manually.
b)
surveys, statistics about usage, and qualitative data collection techniques. While performing a research quantitative data is gathered first and then the qualitative strategies are used.
c)
Observation is a data collection technique that is performed by monitoring or viewing the subject.
d)
For collecting the data through this technique, interviews are performed in groups or on a one-on-one basis.
e)
Surveys are performed through questionnaires. A standard set of questions are used for performing the survey of any specific topic.
9.
What does selecting data mean?
a)
the process of removing excess information to extract only the data you require.
b)
breaking down a complex problem or system into smaller parts that are more manageable and easier to understand.
c)
finding the similarities or patterns among small, decomposed problems that can help us solve more complex problems more efficiently
d)
the process of filtering out – ignoring - the characteristics of patterns that we don't need in order to concentrate on those that we do
e)
The process of getting the information that will be stored in the database.
10.
What does managing the data mean?
a)
To manipulate the information collected in any type of way such as through sorting through it or selecting certain parts using SQL.
b)
finding the similarities or patterns among small, decomposed problems that can help us solve more complex problems more efficiently
c)
the process of filtering out – ignoring - the characteristics of patterns that we don't need in order to concentrate on those that we do
d)
breaking down a complex problem or system into smaller parts that are more manageable and easier to understand
e)
the process of removing excess information to extract only the data you require.
11.
What is the most common language used to manipulate data in databases?
a)
SQL
b)
php
c)
javascript
d)
access
12.
“Allows the user to specify information about multiple tables and the relationship between those tables”
a)
Redundancy
b)
Record Locking
c)
ACID
d)
Transaction Processing
e)
Relational Database
13.
“A database that allows the user to specify data attributes (columns, databases etc.) for only one table at a time, storing those attributes independently”
a)
Relational Database
b)
Redundancy
c)
Record Locking
d)
ACID
e)
Flat File
14.
“A field that uniquely identifies a record in a table”
a)
Flat File
b)
Relational Database
c)
Redundancy
d)
Record Locking
e)
Primary Key
15.
“The linking field in the foreign table formed when a relationship is made. The FK becomes by default the PK of the new table.”
a)
Primary Key
b)
Flat File
c)
Relational Database
d)
Redundancy
e)
Foreign Key
16.
“When more than one field is added together to form a unique primary key for a table.”
a)
Foreign Key
b)
Primary Key
c)
Flat File
d)
Relational Database
e)
Concatenated Primary Key
17.
“A key field which can be used to access a table in a different way”
a)
Concatenated Primary Key
b)
Foreign Key
c)
Primary Key
d)
Flat File
e)
Secondary Key
18.
Entity Relationship Modelling: “The process of producing a data model for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a data such as a relation database.”
a)
Secondary Key
b)
Concatenated Primary Key
c)
Foreign Key
d)
Primary Key
e)
ERM
19.
“The process of arranging data in tables and setting their relationships to move them through normal forms”
a)
ERM
b)
Secondary Key
c)
Concatenated Primary Key
d)
Foreign Key
e)
Normalisation
20.
“The process of creating a database index, which is a data structure that improves the speed of data retrieval operations on a dataset table at the cost of additional writes and storage space to maintain the index data structure.”
a)
Normalisation
b)
ERM
c)
Secondary Key
d)
Concatenated Primary Key
e)
Indexing
21.
“A table with no normalisation. All data and all fields in one table”
a)
Indexing
b)
Normalisation
c)
ERM
d)
Secondary Key
e)
0NF
22.
First Normal Form: “A relationship with repeating groups removed. That is a relation in which the intersection of each tuple and attribute contains one and only one value.”
a)
0NF
b)
Indexing
c)
Normalisation
d)
ERM
e)
1NF
23.
Second Normal Form: “A relation that is in 1NF and every non-primary key attribute is fully dependant on the primary key. That is, all the incomplete dependencies have been removed”
a)
1NF
b)
0NF
c)
Indexing
d)
Normalisation
e)
2NF
24.
Third Normal Form: “A relation that is in 1NF and 2NF, and in which no non-primary key attribute is transitively dependant on the primary key. That is, all non-key elements are fully dependant on the primary key”
a)
2NF
b)
1NF
c)
0NF
d)
Indexing
e)
3NF
25.
“A way of structuring the data in a relational database according to formal rules, in order to avoid problems of efficiency and security in accessing and maintain the data.”
a)
3NF
b)
2NF
c)
1NF
d)
0NF
e)
Normal Forms
26.
Structured Query Language: “The language and syntax used to write and run database queries”
a)
Normal Forms
b)
3NF
c)
2NF
d)
1NF
e)
SQL
27.
“A measure of the consistency of the data in a database. It is violated when the relation to which a foreign key refers to no longer exists.”
a)
SQL
b)
Normal Forms
c)
3NF
d)
2NF
e)
Referential Integrity
28.
“Information processing that is divided into individual, indivisible operations, called transactions. Each transaction must succeed or fail as a complete unit, it can never be only partially complete.”
a)
Referential Integrity
b)
SQL
c)
Normal Forms
d)
3NF
e)
Transaction Processing
29.
Atomicity, Consistency, Isolation, Durability: “A set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction.”
a)
Transaction Processing
b)
Referential Integrity
c)
SQL
d)
Normal Forms
e)
ACID
30.
“A technique of preventing simultaneous access to data in a database, to prevent inconsistent results. The classic example is demonstrated by two bank clerks attempting to update the same bank account for two different transactions.”
a)
ACID
b)
Transaction Processing
c)
Referential Integrity
d)
SQL
e)
Record Locking
31.
“Redundancy occurs in database systems which have a field that is repeated in two or more tables For instance, when customer data is duplicated and attached with each product bought, then redundancy of data is a known source of inconsistency since customer might appear with different values for given attributes.”
a)
Record Locking
b)
ACID
c)
Transaction Processing
d)
Referential Integrity
e)
Redundancy
32.

A database is...

a)

a structured system for holding records

b)

a spreadsheet of information

c)

reliant on good design, as poor structure can cause many problems

d)

simple and easy to create

33.

An entity is...

a)

A thing, about which data is stored in the database such as Student

b)

A property such as Name or Age

34.

An attribute is...

a)

A thing, about which data is stored in the database such as Student

b)

A property such as Name or Age

35.

Entity relationships can be:

a)

One-to-One

b)

Many-to-Many

c)

Many-to-One

d)

One-to-Many

36.

In a hospital system, the relationship between a consultant to a patient would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

37.

In a hospital system, the relationship between a nurse to a ward would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

38.

In a hospital system, the relationship between a patient to a surgeon would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

39.

In a hospital system, the relationship between a consultant to a student would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

40.

In a school system, the relationship between a teacher to a pupil would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

41.

In a school system, the relationship between a teacher to a department would be:

a)

One-to-One

b)

One-to-Many

c)

Many-to-Many

d)

Many-to-One

42.

A primary key is...

a)

A unique identifier for each record

b)

An identifier which can be shared between multiple records

c)

The first number in the record

d)

A way of looking up data in related tables

43.

A foreign key is...

a)

A unique identifier which links a record to a related record in another table

b)

A unique identifier for each record in a table

c)

A shared identifier for all records in one table

44.

What is the primary key?

a)

Sales ID

b)

Item ID

c)

Item Name

d)

Address

e)

Payment Complete?

45.

Which field is likely to be a foreign key?

a)

Sales ID

b)

Item ID

c)

Item Name

d)

Address

e)

Payment Complete?

46.

What will be returned by the SQL query:

SELECT * FROM Sales WHERE Sales ID = "00113"

a)

00112 1151213215 Keyring 123 Example Ln 1

b)

00112 65465654688 Pencil 123 Example Ln 1

c)

00112 87954121321 Bag 123 Example Ln 1

d)

00113 65465654688 Pencil 77 Bay St 0

e)

00114 65465654688 Pencil 999 Letsbey Ave 1

47.

Which of the following SQL statements will return the Sales ID of all sales which involve a pencil?

a)

SELECT * FROM Sales WHERE Item Name = "Pencil"

b)

SELECT * FROM Sales WHERE Item Name = Pencil

c)

SELECT Sales ID FROM Sales WHERE Item Name = "Pencil"

d)

SELECT Sales ID FROM Sales WHERE Item Name = Pencil

e)

SELECT "Sales ID" FROM Sales WHERE Item Name = "Pencil"

48.

Which of the following SQL statements will return the address of anyone who has ordered a pencil and has paid.

a)

SELECT Address FROM Sales WHERE Item Name = "Pencil" and Payment Complete? = TRUE

b)

SELECT Address FROM Sales WHERE Item Name = "Pencil" and Payment Complete? = "TRUE"

c)

SELECT Address FROM Sales WHERE Item Name = Pencil and Payment Complete? = TRUE

d)

SELECT Address FROM Sales WHERE Item Name = "Pencil" or Payment Complete? = TRUE

e)

SELECT Address FROM Sales WHERE "Item Name" = "Pencil" and "Payment Complete?" = TRUE

49.

Is this table in first normal form?

a)

Yes

b)

No

c)

Don't Know

50.

Is this table in first normal form?

a)

Yes

b)

No

c)

Don't Know

51.

Is this table in second normal form?

a)

Yes

b)

No

c)

Don't Know

52.

Is this table in second normal form?

a)

Yes

b)

No

c)

Don't Know

53.

Is this table in third normal form?

a)

Yes

b)

No

c)

Don't Know

54.

Select the things which are true for a database in 1NF:

a)

Each entity has a unique identifier

b)

Each attribute is atomic (divided as small as possible)

c)

Each attribute has a single value

d)

There is no repetition

e)

There are no transitive relationships

55.

Select the things which are true for a database in 2NF:

a)

The database is in 1NF

b)

All attributes depend on the primary key

c)

There is no dependence

d)

There is no repetition

e)

There are no transitive relationships

56.

Select the things which are true for a database in 3NF:

a)

The database is in 2NF

b)

There are at least 4 tables in the database

c)

There is no dependence

d)

All attributes have a separate table

e)

There are no transitive relationships

57.

What normal form is this table in?

a)

1NF

b)

2NF

c)

3NF

58.

What normal form is this table in?

a)

1NF

b)

2NF

c)

3NF

59.

What normal form is this table in?

a)

1NF

b)

2NF

c)

3NF

60.
What entity type is used in the given diagram?
a)
STUDENT
b)
DOCTOR
c)
EMPLOYEE
d)
COURSE
61.
Which attribute is the MULTI-VALUED ATTRIBUTE?
a)
EmpID
b)
Degree
c)
Age
d)
Address
62.

An entity is represented by what in a database?

a)

Table

b)

Row

c)

Column

d)

Cell

63.

A record is represented by what in a database?

a)

Table

b)

Row

c)

Column

d)

Cell

64.

An attribute is represented by what in a database?

a)

Table

b)

Row

c)

Column

d)

Cell

65.

Which of these are required for a relational database to meet 1st normal form?

a)

Data must be atomic

b)

No repeating groups of data

c)

No repeating attributes

d)

Sets of data must have a unique identifier

e)

Must meet 2nd normal form

66.

Which of these are required for a relational database to meet 2nd normal form?

a)

Must meet 1st normal form

b)

All the non-key attributes must depend on the whole primary key

c)

All the non-key attributes must not depend on another non-key attribute

d)

Must meet 3rd normal form

67.

Which of these are required for a relational database to meet 3rd normal form?

a)

Must meet 2nd normal form

b)

All the non-key attributes must depend on another non-key attribute

c)

All the non-key attributes must not depend on another non-key attribute

d)

Must meet 4th normal form

68.

What is the purpose of normalisation?

a)

Eliminate redundant data

b)

Reduce data inconsistencies

c)

Produce redundant data

d)

Increase data inconsistencies

69.

Which type of relationship does the ERD represent?

a)

One-to-many

b)

Many-to-many

c)

One-to-one

70.

Which type of relationship does the ERD represent?

a)

One-to-many

b)

Many-to-many

c)

One-to-one

71.

In a RDBMS such as MS Access, which type of relationship is required to create relationships between entities?

a)

One-to-many

b)

Many-to-many

c)

One-to-one

72.

Which keys are required to create relationships between entities?

a)

Primary key and foreign key

b)

Primary key and secondary key

c)

Foreign key and domestic key

d)

Secondary key and foreign key

73.

What is a foreign key?

a)

Uniquely identifies the records in a table

b)

An attribute that is a primary key in another table

c)

A record that meets 3rd normal form

d)

A primary key made up from two or more attributes

74.

What is a composite primary key?

a)

A primary key that can be duplicated in the same table

b)

An attribute that is a primary key in another table

c)

A foreign key that is a primary key in more than one other table

d)

A primary key made up from two or more attributes

75.

Data type used for telephone numbers

a)

Text

b)

Number

c)

Date/Time

d)

Yes/No

e)

Currency

76.

Data type used for age

a)

Text

b)

Number

c)

Date/Time

d)

Yes/No

e)

Currency

77.

What is used if a postcode needs to have particular format, such as LL09 0LL?

a)

Input mask

b)

Range check

c)

Value lookup

d)

Presence check

78.

In an input mask, what does the character 'A' represent?

a)

User must enter a letter or a digit

b)

User can enter a letter or a digit

c)

User must enter a letter

d)

User can enter a digit, space, plus or minus sign

79.

In an input mask, what does the character '0' represent?

a)

User must enter a digit (0 to 9)

b)

User can enter a digit (0 to 9)

c)

User must enter either a character or a space

d)

User can enter a letter or a digit

80.

Validation rule to ensure data must be entered into that field...

a)

Is Not Null

b)

Is Complete

c)

Is Not Empty

d)

Is Not Nothing

81.

Can be used to create one-to-many relationships between tables...

a)

Table lookup

b)

Value lookup

c)

Input mask

d)

Presence check

82.

Data redundancy is..

a)

when data is repeated unnecessarily

b)

the accuracy and consistency of data

c)

The amount of data stored by organisations

d)

The speed at which data can be processed

83.

Which of these is not a relationship type

a)

One-to-One

b)

One-to-Many

c)

One-to-Two

d)

Many-to-Many

84.
What characteristic does NOT mean that data is in 1NF?
a)
It is all in one table. 
b)
There is redundancy. 
c)
There is an assigned primary key. 
d)
There are duplicate names. 
85.
To be in 1NF: 
a)
Each field contains the smallest meaningful value
b)
There are multiple values in the single field
c)
There are no duplicate records
d)
A primary key is assigned
86.
To be in 2NF: 
a)
Each non-key field relates to the primary key
b)
There are multiple entries in the same field
c)
There are no foreign keys
d)
All numbers are in decimal form
87.
To be in 2NF:
a)
Any field not relating to the PK is placed in a separate table
b)
The records all relate easily
c)
Each table has a foreign key
d)
There are no redundancies
88.
To be in 3NF:
a)
Records do not depend on anything other than the table's PK
b)
The PK is not added
c)
The FKs are limited to one only
d)
The tables all relate to one another
89.
Tables in 2NF but not 3NF contain...
a)
Insert, update and delete anomalies
b)
No extra FKs
c)
No redundancy
d)
Access to more data 
90.
A foreign key
a)
Links to a primary key in another table. 
b)
Links to another foreign key. 
c)
Links to another database system. 
d)
Should always reference a unique value in the same table. 
91.
A primary key
a)
Is a unique identifier for the table. It cannot be null. 
b)
Is a unique identifier for the table. It can be null. 
c)
Is an identifier that always connects to a foreign key. 
d)
Is used in flat file databases. 
92.

Which of these are required for a relational database to meet 1st normal form?

a)

Data must be atomic

b)

No repeating groups of data

c)

No repeating attributes

d)

Sets of data must have a unique identifier

e)

Must meet 2nd normal form

93.

Which of these are required for a relational database to meet 2nd normal form?

a)

Must meet 1st normal form

b)

All the non-key attributes must depend on the whole primary key

c)

All the non-key attributes must not depend on another non-key attribute

d)

Must meet 3rd normal form

94.

Which of these are required for a relational database to meet 3rd normal form?

a)

Must meet 2nd normal form

b)

All the non-key attributes must depend on another non-key attribute

c)

All the non-key attributes must not depend on another non-key attribute

d)

Must meet 4th normal form

95.

What is the purpose of normalisation?

a)

Eliminate redundant data

b)

Reduce data inconsistencies

c)

Produce redundant data

d)

Increase data inconsistencies

96.

What is a composite primary key?

a)

A primary key that can be duplicated in the same table

b)

An attribute that is a primary key in another table

c)

A foreign key that is a primary key in more than one other table

d)

A primary key made up from two or more attributes

97.

A simple database consisting of only one entity

a)

Relational Database

b)

ERD

c)

Flat-file database

d)

Table

98.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
99.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

a)

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

b)

SELECT [all] FROM Persons WHERE FirstName='Peter'

c)

SELECT * FROM Persons WHERE FirstName<>'Peter'

d)

SELECT * FROM Persons WHERE FirstName='Peter'

100.

To remove a record from a table which SQL statement would you use?

a)

Remove

b)

Cancel

c)

Delete

d)

Eradicate

101.

Which statement allows us to add a record to a table?

a)

Add To

b)

Update To

c)

Add Into

d)

Insert Into

Similar Resources on Wayground

Digital Design 1 EOC

102 questions

Digital Design 1 EOC

quiz

Worksheet

•

9th - 12th Grade

Year 7 Scratch Test

100 questions

Year 7 Scratch Test

quiz

Worksheet

•

6th Grade - University

Input Devices IGCSE

103 questions

Input Devices IGCSE

quiz

Worksheet

•

9th - 12th Grade

Mr. W CS FINAL EXAM

100 questions

Mr. W CS FINAL EXAM

quiz

Worksheet

•

9th - 12th Grade

2nd Nine Weeks Study Guide CS

99 questions

2nd Nine Weeks Study Guide CS

quiz

Worksheet

•

9th - 12th Grade

REMEDIAL UAS GENAP INFORMATIKA

100 questions

REMEDIAL UAS GENAP INFORMATIKA

quiz

Worksheet

•

9th - 12th Grade

SOAL TIK KELAS XII

100 questions

SOAL TIK KELAS XII

quiz

Worksheet

•

12th Grade

Chess Quiz - Compilation

100 questions

Chess Quiz - Compilation

quiz

Worksheet

•

KG - Professional Dev...