wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ITX202 - Database Basics

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.

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

2.

Who might use a database?

a)

School

b)

Police

c)

Employer

d)

All of the above

3.

In school, what kind of data might be stored in a database?

a)

Favourite colour

b)

Emergency contact details

c)

Favourite food

d)

Your mobile phone number

4.

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

5.

What is a unique identifying field called?

a)

Field

b)

Primary Key

c)

Record

d)

Query

6.

Short text, date, long text and number are all examples of what?

a)

Data types

b)

Headings

c)

Fields

d)

Records

7.

A column in a database is better known as a...

a)

Record

b)

Query

c)

Field

d)

Form

8.

A row in a database is better known as

a)

Record

b)

Query

c)

Field

d)

Form

9.

True or false - it is important to check our literacy (spelling, capital letters, etc) when inputting data into a database

a)

True

b)

False

10.

A query is used to

a)

Sort the database in alphabetical order

b)

Search the database

c)

Delete records

d)

Create a form

11.

If we are running a query and looking for all records with a date before 1999, we type what into the criteria?

a)

>1999

b)

>01/01/1999

c)

<01/01/1999

d)

<1999

12.

Which of these holds lots of data?

a)

Record

b)

Field

c)

Table

d)

Drawing

13.

The best data type to choose for a memberID would be

a)

Number

b)

Date/Time

c)

Text

d)

Currency

14.

The best data type to choose for date of birth would be

a)

Number

b)

Date/Time

c)

Text

d)

Currency

15.

In a database, data is stored in

a)

Queries

b)

Forms

c)

Reports

d)

Tables

16.

In a database, all the information about one person or thing is called a

a)

Worksheet

b)

Presentation

c)

Record

d)

File

17.

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.

18.

Which of the following uses paper-based databases?

a)

Phonebook

b)

Smart Phone

c)

Computer

19.

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

20.

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

21.

Select the computer-based database

a)

Phonebook

b)

Chalkboard

c)

Google search engine

22.

A sports club needs to store information about each member. The all the information about each member is called a:

a)

Field

b)

File

c)

Table

d)

Record

23.
 A database of racing includes the names of each driver, total wins and losses, and average speeds. What criterion will produce Jeff Gordon’s total winnings?  
a)
 >Jeff Gordon
b)
  <Jeff Gordon 
c)
  =Jeff Gordon
d)
 <>Jeff Gordon
24.
Jennifer is creating a database for several customers. How will she list the Customer ID?  
a)
  Yes/No
b)
  Data 
c)
 Number
d)
 Currency
25.
 Juan needs to create a database of all his friends. In a table, what is all the information about one friend considered?   
a)
  Field 
b)
 Record
c)
 Table
d)
  Entry
26.
Chloe is creating a database for several customers. What is the data type for the field total sales?  
a)
 Yes/No
b)
  Data 
c)
 Number
d)
  Currency
27.
 Max wants to create a list of graduate degrees in a database that will allow the selection of only three choices: BSBA, MBA, and MBE. Which field property should he use? 
a)
 Auto Number 
b)
 Lookup
c)
  Number 
d)
  Yes/No
28.
Which criteria will produce an alphabetical list of drivers who have 150 points?   
a)
  >150 and Sort Ascending
b)
  >150 and Sort Descending
c)
  >=150 and Sort Ascending 
d)
  >=150 and Sort Descending
29.
In a database, a "table" is a...
a)
set of data elements using a model of vertical columns and horizontal rows
b)
spreadsheet program
c)
presentation program
30.
Keisha wants only Beyoncé songs from her database. What should she use to see and save them?
a)
Filter
b)
Form
c)
Query
31.
Nick wants Access to assign an ID number to each record. What is this called?
a)
Data Type
b)
auto numbering
c)
Properties
32.

The ID field in a table will usually use the auto-number data type

a)

True

b)

False

33.

Columns in database tables are referred to as

a)

Fields

b)

Records

c)

Entities

34.

Rows in database tables are referred to as

a)

Fields

b)

Records

c)

Entities

35.

Tables in databases are referred to as

a)

Fields

b)

Records

c)

Entities

36.

All the data entered about a specific item within a table would be called a field

a)

True

b)

False

37.

Each item from this list is classified as...

Name, Birthdate, Street, County , PostCode

a)

Table

b)

Record

c)

Field

38.

Which of the following is an example of a record?

a)

347

b)

ChannelType

c)

351, Nature, Documentary, Bling, False

39.

The HD field is using the data type Boolean

a)

True

b)

False

40.

Which data type would be most suitable for Length?

a)

Number

b)

AutoNUmber

c)

Yes/No

d)

Short Text

41.

Which of the following is an example of a field?

a)

TimesPlayed

b)

004

c)

Holidays

42.

Which of the following is a field in this database table?

a)

DistrictName

b)

3

c)

Northend

d)

+

43.

Select the elements that make up the definition of a database

a)

Organised

b)

Collection of Information

c)

Manageable

d)

Fields

44.

Microsoft Access is the only database software in use

a)

True

b)

False

45.
The following two attributes from different tables will form a relationship:
a)
Supplier's ID and Item Supplier
b)
Quantity purchased and Quantity left
c)
Item name and supplier's ID
46.
The following is not a valid type of a relationship:
a)
one-to-all
b)
one-to-one
c)
one-to-many
d)
many-to-many
47.
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
a)
Cell
b)
Field
c)
Column
d)
Record
48.
Which attribute is the KEY IDENTIFIER or the PRIMARY KEY?
a)
EmpID
b)
Degree
c)
Name
d)
Birthday
49.
This symbol indicates _____ relationship.
a)
one or many
b)
zero or many
c)
zero or one
d)
many to many
50.
This symbol indicates _____ relationship.
a)
zero or one
zero or one
b)
zero or many
c)
one or many
d)
many to many

Similar Resources on Wayground

KUIZ VLE - PENGETAHUAN AM

50 questions

KUIZ VLE - PENGETAHUAN AM

quiz

Worksheet

•

10th - 12th Grade

SOAL PAT TLJ XI TKJ

45 questions

SOAL PAT TLJ XI TKJ

quiz

Worksheet

•

11th Grade

TIN HỌC 10 HK2

50 questions

TIN HỌC 10 HK2

quiz

Worksheet

•

10th - 12th Grade

Soal Kejuruan TKJ 4

50 questions

Soal Kejuruan TKJ 4

quiz

Worksheet

•

10th - 11th Grade

HTML

50 questions

HTML

quiz

Worksheet

•

9th - 12th Grade

General Review Grade 8

50 questions

General Review Grade 8

quiz

Worksheet

•

7th - 12th Grade

Teknologi Jaringan Telekomunikasi

50 questions

Teknologi Jaringan Telekomunikasi

quiz

Worksheet

•

11th Grade

SOAL SEMESTER 1 KELAS 9 BAHASA INDONESIA 2020/2021

50 questions

SOAL SEMESTER 1 KELAS 9 BAHASA INDONESIA 2020/2021

quiz

Worksheet

•

3rd Grade - University