wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Introduction To Database Grade 7

Total questions: 56

Worksheet time: 29mins

Name
Class
Date
1.
The following are functions of a DBMS except
a)
Creating database
b)
Processing data
c)
Creating and processing forms
d)
Administrating database
2.
A database management system (DBMS) is a:
a)
Software system used to create, maintain, and provide controlled access to a database
b)
Hardware system used to create, maintain, and provide controlled access to a database
c)
Hardware system used to create, maintain, and provide uncontrolled access to a database
d)
Software system used to create, maintain, and provide uncontrolled access to a database
3.
A database application can perform which of the following activities?
a)
Add records
b)
Display / read records
c)
Update records
d)
All of the above
4.
A relational database consists of a collection of
a)
Field
b)
Record
c)
Table
d)
Keys
5.
The term attribute refers to a ________ of a table
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
6.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
7.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
a)
NAME
b)
ID
c)
CITY
d)
ID, NAME
8.
Which one of the following should be taken as a primary key?
a)
Name
b)
DepartmentID
c)
Department
d)
Street
9.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street
10.
A attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
11.
Which of the following gives a logical structure of the database graphically?
a)
Entity--relationship diagram
b)
Entity diagram
c)
Database diagram
d)
Architectural representation
12.
The entity relationship set is represented in E-R diagram as
a)
Double diamonds
b)
Undivided rectangles
c)
Dashed lines
d)
Diamond
13.
The rectangles divided into two parts represents
a)
Entity set
b)
Relationship set
c)
Attributes of a relationship set
d)
Primary key
14.

In a database, Multiple _________ can be created.

a)

Tables

b)

Documents

c)

Primary Key

d)

All of these

15.

___________________ Key uniquely identifies each record in table.

a)

Fields

b)

Record

c)

Row

d)

Primary

16.

In a Database, each row is called a _____________

a)

Field

b)

Data

c)

Record

d)

Table

17.

In a Database, each column is called a _____________

a)

Field

b)

Data

c)

Record

d)

Table

18.

This table has ___________ records.

a)

2

b)

4

c)

5

d)

6

19.

This table has ___________ fields.

a)

2

b)

4

c)

5

d)

6

20.

Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?

a)

Name

b)

ID

c)

City

d)

All of these

21.

Which of the following are common database program?

a)

MS Access

b)

Excel

c)

InDesign

d)

Word

22.

Which of the following is an example of a DBMS

a)

MS Word

b)

Microsoft Office

c)

Java

d)

Oracle

23.

______________ symbol indicates that a field is the Primary Key of the table.

a)
b)
c)
d)

All of these

24.
A column name is otherwise known as a _____.
a)
field
b)
table
c)
row
d)
record
25.
Which is the best example of a primary key?
a)
Driver's License Number
b)
Home Runs Hit
c)
Price
d)
First and Last Name
26.
A quick way to find data in a database is to use _____.
a)
queries
b)
quandries
c)
questions
d)
file folders
27.
SQL stands for _____.
a)
structured query language
b)
sustainable query language
c)
structured question language
d)
sustainable question language
28.

What are databases mainly used for?

a)

To store archived data

b)

To store and organise data

c)

To analyse data

29.

Which of the following statements best defines the word 'database'?

a)

A database is a collection of data or information which is stored in a logical and structured way

b)

A database is a collection of statistics stored only for computers.

c)

A database does not collect data or information.

30.

What is the difference between an entity and an attribute?

a)

An attribute is a table in a database and an entity is a field

b)

An attribute is a record in a database and an entity is a table

c)

An attribute is a field in a database and an entity is a table

31.

Why would you create a primary key?

a)

To make each record in a database unique

b)

To make each field in a database unique

c)

To make each query in a database unique

32.

What is a database?

a)

A software package used to store information

b)

Something that has a list

c)

A spreadsheet

d)

A table of data

33.

Which software program do we use to create a database

a)

Microsoft Excel

b)

Microsoft Word

c)

Microsoft Access

d)

Microsoft Publisher

34.

Who might use a database?

a)

School

b)

Police

c)

Employer

d)

All of the above

35.

What is an advanage of a database?

a)

You can input information

b)

Its different to Excel

c)

It saves files

d)

Can search through and find information quickly

36.

What is a unique identifying field called?

a)

Field

b)

Primary Key

c)

Record

d)

Query

37.

Repetition of data is called data ..............

a)

dependance

b)

redundancy

c)

inconsistency

d)

isolation

38.

A ............ is an organized collection of structured data.

a)

information

b)

file

c)

database

d)

DBMS

39.
What language does the Relational Model use?
a)
Java
b)
Python
c)
SQL
d)
C++
40.
Collection of fields known as
a)
keyfield
b)
record
c)
file
d)
table
41.

What is the full form of DBMS

a)

Data and business management software

b)

Database management system

c)

Database arrangement system

d)

Database align software

42.

What application is DBMS?

a)

Software application.

b)

Hardware application.

43.

Each item from this list is classified as...

Name, Birthdate, Street, County , PostCode

a)

Table

b)

Record

c)

Field

44.

Which of the following is an example of a record?

a)

Artist

b)

Game Over

c)

002, Tail, Seeing You, 2.7, 0, True

45.
A group of related records.
a)
Entity
b)
Validation
c)
Field
d)
Filter
46.
What entity type is used in the given diagram?
a)
STUDENT
b)
DOCTOR
c)
EMPLOYEE
d)
COURSE
47.
Which attribute is the MULTI-VALUED ATTRIBUTE?
a)
EmpID
b)
Degree
c)
Age
d)
Address
48.

Which attribute is the COMPOSITE ATTRIBUTE?

a)

Degree

b)

Age

c)

Salary

d)

Address

49.
Which attribute is the DERIVED ATTRIBUTE?
a)
EmpID
b)
Age
c)
Name
d)
Degree
50.

Which attribute is the PRIMARY KEY?

a)
EmpID
b)
Degree
c)
Name
d)
Birthday
51.

Diamond shape is symbol for ?

a)

Entity

b)

Cardinality

c)

Relationship

d)

Atribut

52.

This shape is symbol for ?

a)

Atribute

b)

Relationship

c)

Entity

d)

Cardinality

53.

For ERD this shape describe for ?

a)

Cardinality

b)

Relationship

c)

Attribute

d)

Entity

54.

An entity ____________.

a)

Is the association between two related processes

b)

Has cardinality (1:1, 1:N, or M:N)

c)

Shows if it can be null or no null

d)

Is a person, place or thing

e)

Is described with a verb phrase

55.

The attribute name could be structured as an attribute consisting of first name, middle name and last name. This type of attribute is called :

a)

Simple attribute

b)

Composite attribute

c)

Multi-valued attribute

d)

Derived attribute

56.

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is:

a)

Single valued

b)

Multi valued

c)

Composite

d)

Derived

Similar Resources on Wayground

Ulangkaji ASK Ting 2 Bab 3.1 Persekitaran Kod Arahan

52 questions

Ulangkaji ASK Ting 2 Bab 3.1 Persekitaran Kod Arahan

quiz

Worksheet

•

1st - 12th Grade

Gr 7-Chapter 1 - Communication network and Mobile OS

52 questions

Gr 7-Chapter 1 - Communication network and Mobile OS

quiz

Worksheet

•

7th Grade

LV1_BT_CD1_CD2

60 questions

LV1_BT_CD1_CD2

quiz

Worksheet

•

6th Grade - University

UNIT 4 TEST OS, Hardware and Software Systems

60 questions

UNIT 4 TEST OS, Hardware and Software Systems

quiz

Worksheet

•

5th - 9th Grade

Hardware and Software Basics

55 questions

Hardware and Software Basics

quiz

Worksheet

•

6th Grade

Quiz sobre IA Generativa

54 questions

Quiz sobre IA Generativa

quiz

Worksheet

•

6th - 8th Grade

BÀI 1,2,3,12 LỚP 8

51 questions

BÀI 1,2,3,12 LỚP 8

quiz

Worksheet

•

6th - 8th Grade

Ôn tập IC3 GS6 Level 1 (4)

54 questions

Ôn tập IC3 GS6 Level 1 (4)

quiz

Worksheet

•

6th - 8th Grade