wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DBMS

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

The Collection of information stored in database at a Particular moment is called _________

a)

Instance

b)

Language

c)

Schema

d)

Data Dictionary

2.

A DBMS consists a collection of _________

a)

Tables

b)

Fields

c)

Records

d)

Keys

3.

The term attribute refers to a _____ of a table.

a)

Record

b)

column

c)

Key

d)

Tuple

4.

In relational model, the row of table is known to be a ______

a)

Relation

b)

 Entity field

c)

Tuple

d)

Attribute

5.

A table is a collection of relationships, there is a close correspondence between concept of _______

a)

Table and variables

b)

Tables and instances

c)

 Tables and Entries

d)

Tables and relations.

6.

DDL Statement is a set of tables that is stored in a special file called_________

a)

Data Dictionary

b)

Data Set

c)

Data Library

d)

Data isolation

7.

Which Language is used to define the integrity constraints?

a)

DDL

b)

DCL

c)

DML

d)

SQL

8.

A Language that enables users to access and manipulate data is __________

a)

SQL

b)

Data Language

c)

Database Manipulation Language

d)

DDL

9.

DDL Stands for____________

a)

Data Definition Language

b)

Database Decision Language

c)

Data Domain Language

d)

Data Dictionary Language

10.

DBMS provides _________ of data

a)

Whole

b)

Hidden

c)

Part

d)

Abstract

11.

Number, char, varchar2 are examples for _________ types

a)

Data

b)

Field

c)

Record

d)

Attribute

12.

An example for an Aggregate function is _______________

a)

Minus

b)

Join

c)

Union

d)

 Sum

13.

Query languages used in practice includes _______.

a)

Elements

b)

Instances

c)

Tuples

d)

 Fields

14.

Logical design of database, is known to be________

a)

Database relation

b)

Database instance

c)

 Database Schema

d)

Database entity

15.

__________ is a procedural language.

a)

Relational algebra 

b)

Domain relational calculus

c)

Tuple relational calculus

d)

Query language

16.

A  statement that executed automatically by the system is called

a)

Assertion

b)

Trigger

c)

Referential integrity

d)

Integrity constraints

17.

All aggregate functions except __________ ignore null values in their input collection.

a)

Count (attribute)

b)

Count(*)

c)

Avg

d)

Sum

18.

Which of the following is used to define the schema of the database?

a)

DDL

b)

DCL

c)

DML

d)

DLL

19.

In E-R diagram Rectangle represents __________

a)

Attributes

b)

Weak entity sets

c)

derived attributes

d)

entity set

20.

In E-R Diagram ellipse represent ______________

a)

Attributes

b)

entity set

c)

derived attibutes

d)

weak entity set

21.

Weaker Normal Form called ______ Normal Form

a)

Secord

b)

First

c)

Third

d)

Boyce Codd

22.

NF stands for ___________________

a)

Natural Form

b)

Nutural Form 

c)

Null Form

d)

Normal Form

23.

PL/SQL Block Contains __________ section.

a)

1

b)

2

c)

3

d)

4

24.

The _____ statement change at the flow of control within a PL/SQL block.

a)

GoTo

b)

If….Else

c)

If Condition

d)

For ... loop

25.

 Roll back of transition is normally used to___________.

a)

 Recover from the transaction failure

b)

 Update the transaction

c)

Retrieve old records

d)

Repeat a transition