wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Introduction to DBMS

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

The DBMS is a collection of interrelated __________ and a set of programs to access those data.

a)

information

b)

data

c)

database

d)

events

2.

Data redundancy leads to which of the following problem?

a)

Data Isolation

b)

Data Security

c)

Data Integrity

d)

Data inconsistency

3.

Which level of data abstraction describes how the data are stored in the database?

a)

Physical level

b)

Logical Level

c)

View Level

d)

All the Above

4.

The overall design of the database is called _____________.

a)

Data Model

b)

Architecture

c)

Schema

d)

instance

5.

The ____________ is a collection of conceptual tools for describing data, data relationship, data semantics, and consistency constraints.

a)

database

b)

DBMS

c)

data model

d)

database language

6.

The collection of information stored in the database at a particular moment is called as ____________ of the database.

a)

schema

b)

instance

c)

view

d)

data model

7.

A _____________ is a statement requesting the retrieval of information from the database.

a)

constraint

b)

schema

c)

query

d)

program

8.

Write the expansion for DML.

(a)  

9.

Declarative DML is also known as (a)   .

10.

The ____________ is widely used to represent semi-structured data.

a)

XML

b)

C++

c)

Java

d)

Oracle