wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Data Science: DBMS

Total questions: 40

Worksheet time: 31mins

Name
Class
Date
1.

What is a field in a database?

a)
A field is a row in a database table that contains multiple records.
b)
A field is a column in a database table that stores a specific attribute of a record.
c)
A field is a type of database that stores entire tables.
d)
A field is a command used to query a database for information.
2.

What is a record in a database?

a)
A record is a type of database software.
b)
A record is a single data type in a database.
c)
A record is a collection of related data items stored together in a database.
d)
A record is a command used to query a database.
3.

A row is ​ (a)   in a table that ​ (b)   all the​ (c)   about one item or ​ (d)  

Choose from the below words
a record
contains
information
person.
4.

What is a primary key?

a)
A primary key is a type of foreign key.
b)
A primary key can be duplicated in a table.
c)
A primary key is used to store images in a database.
d)
A primary key is a unique identifier for a record in a database table.
5.

  • A field that uniquely identifies each record in a table is a _____ _____ (P... K...)



(a)  

6.

What is a foreign key in a database?

a)
A foreign key is a unique identifier for a single table.
b)
A foreign key is a type of index that speeds up queries.
c)
A foreign key is a field that stores data from the same table.
d)
A foreign key is a field that links two tables by referencing the primary key of another table.
7.

  • A field in one table that links to the primary key in another table is called a _____ _____(F... K...)



(a)  

8.

Which of these is an example of a primary key?

a)
PhoneNumber
b)
Username
c)
UserID
d)
Email
9.

Why do we use foreign keys in a database?

a)
To store duplicate data in multiple tables.
b)

To connect related data in different tables

c)
To improve the speed of data retrieval.
d)
To increase the size of the database.
10.

What is normalisation in a database?

a)

Dividing data into smaller, related tables to reduce redundancy

b)

Normalisation is a method to encrypt data in a database.

c)

Normalisation refers to the physical storage of data on disk drives.

d)

Normalisation is the process of increasing redundancy in a database.

11.

What is data redundancy?

a)
Data redundancy is the unnecessary duplication of data in a database.
b)
Data redundancy refers to the compression of data in a database.
c)
Data redundancy is the elimination of duplicate data in a database.
d)
Data redundancy is the process of backing up data.
12.

​ (a)   is the process ​ (b)   data into ​ (c)   , ​ (d)   to remove ​ (e)   or repetition.

Choose from the below words
Normalisation
of organising
smaller
related tables
redundancies
13.

  • The process of organising data into smaller, related tables to remove repetition is called: (a)   (Nor...)

14.

What is data redundancy?

a)
Data redundancy is the process of compressing data to save space.
b)
Data redundancy refers to the use of multiple databases for security purposes.
c)
Data redundancy is the practice of deleting old data to improve performance.
d)
Data redundancy is the unnecessary duplication of data in a database.
15.

Repeated or duplicate data in a table is referred to as: data (a)   (redu....)

16.

What is the relationship between an owner and their pets?

a)

Many-to-One

b)

One-to-Many

c)

Many-to-Many

d)

One-to-One

17.

Data ​ ​ (a)   refers to ​ (b)   and ​ (c)   of data in a ​ (d)  

Choose from the below words
integrity
the accuracy
consistency
database.
18.

In the normalised database, where is the pet's "Name" stored?

a)

Owner table

b)

Pet table

c)

Visit table

d)

It is not stored

19.

A row or horizontal line of data in a table, also called a " (a)   " (re...).

20.

  • A column of data in a table, also called a "________."

a)
record
b)
column
c)
attribute
d)
field
21.

  • A row of data in a table, also called a "_________"

a)
entry
b)
field
c)
column
d)
record
22.

A table is also referred to as an (a)   (enti...)

23.

A column or field is also referred to as an (a)   (attri...)

24.

  • When one item in one table relates to many items in another table, it is referred to as a: _____-__-___relationship



(a)  

25.

When many items in one table relate to many items in another table-it is called a (a)   relationship

26.

A set of rows and columns used to organise data is called a (ta (a)  

27.

A connection between tables in a relational database is referred to as a (a)   (rela...)

28.

Repeated or duplicate data in a table is also called (a)   (redu

29.

  • The structure or design of a database, showing tables and their relationships is referred to as a (a)   (sche...)

30.

Why do we separate data into smaller tables in a DBMS?

a)
We separate data into smaller tables to reduce redundancy, improve data integrity, and enhance query performance.
b)
To eliminate the need for relationships between data.
c)
To increase the size of the database for better performance.
d)
To combine all data into a single table for simplicity.
31.

Which field would you use as a foreign key in the Pet table?

a)
pet_id
b)
age
c)
owner_id
d)
species
32.

What type of relationship exists between the Pet and Visit tables in a DBMS?

a)
One-to-many relationship
b)
No relationship
c)
One-to-one relationship
d)
Many-to-many relationship
33.

Which field could NOT be a primary key?

a)

Owner ID (unique for every owner)

b)

Pet ID (unique for every pet)

c)

Pet Type (e.g., dog, cat)

d)

Visit ID (unique for every visit)

34.

What is the purpose of the Amount Owed field in the Visit table?

a)
To calculate the total revenue for the clinic.
b)
To determine the patient's insurance coverage.
c)
To record the date of the patient's last visit.
d)

To record the total money owed for the visit

35.

In the flat file database, why is it hard to update an owner's phone number?

a)

It may be duplicated in multiple records, requiring multiple updates.

b)
Updating the phone number requires a system reboot.
c)
The phone number is stored in a separate database.
d)
Flat file databases do not allow any updates.
36.

What is the primary key in the Visit table?

a)

Pet_ID

b)

Appointment_Date

c)

Visit_ID

d)

Visit_date

37.

What is a "flat file" database?

a)

A single table with all the data stored together

b)

A database that uses advanced encryption for data security.

c)

A type of cloud storage service.

d)
A flat file database is a complex relational database with multiple tables.
38.

What happens when data is normalised?

a)
Data is deleted to free up resources.
b)
Data is encrypted for security purposes.
c)
Data is compressed to save storage space.
d)

Data is organised into multiple tables to reduce redundancy.

39.

When many items in one table relate to many items in another table it is referred to as a (a)   (ma... to ma...) relationship

40.

When many items in one table relate to many items in another table such as student ID is referred to as a

(a)   (P... K...)

Similar Resources on Wayground

HTML AZ

35 questions

HTML AZ

quiz

Worksheet

•

6th Grade - University

Quiz sobre Escalonadores de Processos

40 questions

Quiz sobre Escalonadores de Processos

quiz

Worksheet

•

12th Grade - University

Soal Informatika Kelas 9

36 questions

Soal Informatika Kelas 9

quiz

Worksheet

•

9th Grade - University

UH Topologi Jaringan Komputer

35 questions

UH Topologi Jaringan Komputer

quiz

Worksheet

•

11th Grade - University

Bại ôn tập học kì 1 môn tin lớp 3

40 questions

Bại ôn tập học kì 1 môn tin lớp 3

quiz

Worksheet

•

3rd Grade - University

Bagian 1: Berpikir Komputasional - Algoritma dan Dekomposisi

40 questions

Bagian 1: Berpikir Komputasional - Algoritma dan Dekomposisi

quiz

Worksheet

•

9th Grade - University

UH 2 Perlindungan Data Pribadi

35 questions

UH 2 Perlindungan Data Pribadi

quiz

Worksheet

•

9th Grade - University

TIN 8 - BÀI 02

36 questions

TIN 8 - BÀI 02

quiz

Worksheet

•

8th Grade - University