wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Introduction to Database

Total questions: 18

Worksheet time: 9mins

Name
Class
Date
1.
What is database?
a)
Collection of organized data that allows access, retrieval of  that data.
b)
Collection of organized data that allows access, retrieval, and use of  that data.
c)
Collection of organized data that allows retrieval, and use of  that data.
2.
Why we need database?
a)
To store  a particular picture
b)
To store  a particular text
c)
To store  a particular collection of data.
d)
To store  a particular audio
3.
Which is the example of File Based System?
a)
Using MySQL to find specific data
b)
Using MS Access to control users access
c)
 Using spreadsheet software to manage data of employee
d)
Using OpenOffice.org Base to create new table
4.
Why File Based System become unpopular?
a)
It causes sync with all the data synchronization
b)
It causes data redundancy
5.
What is Database Management System?
a)
A software system that enables users to access to the database.
b)
A software system that enables users to create  access to the database.
c)
A software system that enables users to define, create, maintain and control access to the database.
d)
  A software system that enables users to maintain and control access to the database.
6.
Which of the following is NOT Advantages of DBMS
a)
Increased data consistency 
b)
Reduced data redundancy
c)
Improved data security 
d)
Increase data isolation
7.
Which of the following is the disadvantages of DBMS?
a)
Cost of setup of DBMS is relatively cheap
b)
Database systems are complex
c)
 Database will not be corrupted
d)
Database systems are fast to be designed
8.
Which type of application should you use if you need to store a large quantity of data in an organized format that you can easily query?
a)
Database
b)
Presentation
c)
Spreadsheet
d)
Word Processor
9.

Logically related data consists of these EXCEPT

a)

attributes

b)

relationships

c)

entities

d)

variables

10.

Data Definition Language is used to _______ the DBMS.

a)

create

b)

define

c)

control access

d)

manage

11.

Data Manipulation Language is used to _______ the DBMS.

a)

create

b)

define

c)

control access

d)

manage

12.

_____ is the bridge between machine and human in a DBMS environment

a)

People

b)

Hardware

c)

Software

d)

Data

e)

Procedure

13.

_______ decides how the logical DB design is to be physically realised

a)

Data Administrator (DA)

b)

Database Administrator (DBA)

c)

Database Designers (Logical & Physical)

d)

Application Programmers

14.

Using different file organization should not require change to conceptual or external schemas.

This is referring to

a)

Logical Data Independence

b)

Physical Data Independence

c)

Conceptual Data Independence

d)

User Data Independence

15.

_______ is responsible for the management of the data resource.

a)

Data Administrator (DA)

b)

Database Administrator (DBA)

c)

Database Designers (Logical & Physical)

d)

Application Programmers

16.

_______ is responsible for the maintenance of operational control.

a)

Data Administrator (DA)

b)

Database Administrator (DBA)

c)

Database Designers (Logical & Physical)

d)

Application Programmers

17.

_______ builds the application programs that provide the required functionality for the end-users.

a)

Data Administrator (DA)

b)

Database Administrator (DBA)

c)

Database Designers (Logical & Physical)

d)

Application Programmers

18.

For the ANSI-SPARC Three-Level Architecture, ________ is the community view of the database.

a)

External Level

b)

Conceptual Level

c)

Internal Level

Similar Resources on Wayground

Informatika Kelas 5 Bab 2

19 questions

Informatika Kelas 5 Bab 2

quiz

Worksheet

•

5th Grade - University

Quiz on Misinformation and Bias

18 questions

Quiz on Misinformation and Bias

quiz

Worksheet

•

10th Grade - University

ระบบปฏิบัติการ ชุดที่ 1

15 questions

ระบบปฏิบัติการ ชุดที่ 1

quiz

Worksheet

•

University

Round 2 for Preplacement Bootcamp

15 questions

Round 2 for Preplacement Bootcamp

quiz

Worksheet

•

University

DWDM Unit1 Quiz

21 questions

DWDM Unit1 Quiz

quiz

Worksheet

•

University

COA_QUIZ_UNIT I

20 questions

COA_QUIZ_UNIT I

quiz

Worksheet

•

University

have fun with econometrics

15 questions

have fun with econometrics

quiz

Worksheet

•

University

CPA MS-Office Hotkeys Quiz

21 questions

CPA MS-Office Hotkeys Quiz

quiz

Worksheet

•

8th Grade - Professio...