wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

DBMS

Total questions: 10

Worksheet time: 10mins

Name
Class
Date
1.

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

a)

DML

b)

DDL

c)

Relational Schema

d)

Query

2.

Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

a)

DML

b)

DDL

c)

Relational Schema

d)

Query

3.

What do you mean by one to many relationships?

a)

One class may have many teachers

b)

One teacher can have many classes

c)

Many classes may have many teachers

d)

Many teachers may have many classes

4.

Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.

a)

Data Repository

b)

Data Inconsistency

c)

Data Mining

d)

Data Redundancy

5.

Which of the following is not a schema?

a)

Database schema

b)

Logical schema

c)

Critical schema

d)

Physical schema

6.

Who proposed the relational model?

a)

Bill gates

b)

E.F.Codd

c)

Charles Babbage

d)

Herman Hollerith

7.

In SQL, which command is used to changes data in a table?

a)

UPDATE

b)

INSERT

c)

BROWSE

d)

APPEND

8.

The term "Data" refers to

a)

The electronic representation of the information( or data)

b)

Basic information

c)

Row Facts and figures

d)

Both A and C

9.

Rows of a relation are known as the

a)

Degree

b)

Tuples

c)

Entity

d)

All of the above

10.

The term "SQL" stands for

a)

Standard query language

b)

Sequential query language

c)

Structured query language

d)

Server-side query language