wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

DBMS

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.

A merit of DBMS is

a)

data is dependent on programs.

b)

data redundancy increases.

c)

) data is integrated and can be accessed by multiple programs

2.

A query language supports

a)

support end-users who use English-like commands

b)

support in the development of complex applications software.

c)

all of the above.

3.

The database schema as a whole is designed using

a)

VDL and DDL.

b)

DDL and DML.

c)

VDL and DML.

4.

It changes the description of a table

a)

Alter.

b)

Update.

c)

Create

5.

The weak entity set of E-R model?

a)

Dotted rectangle.

b)

Doubly outlined rectangle

c)

Diamond

6.

The relationship between tables is denoted by

a)

Primary key

b)

Foreign Key

c)

None of these

7.

To connect front end and back end, we use

a)

Object Database Connectivity.

b)

Oral Database Connectivity.

c)

Open Database Connectivity.

8.

The database architecture is of

a)

two levels

b)

three levels

c)

one level

9.

The relations in relational algebra are termed as

a)

Tuples

b)

Tables

c)

Attributes

10.

The schema of database is developed using

a)

HLL

b)

DDL

c)

DML

11.

In an E-R diagram attributes are represented by

a)

rectangle

b)

square

c)

ellipse

12.

The whole view of database is

a)

Conceptual view

b)

Internal view

c)

Physical View

13.

Modification to the database by unauthorised users is referred to as

a)

Integrity issue

b)

Productivity

c)

Consistency

14.

The command to add a column to an existing relation

a)

Create

b)

Alter

c)

Update

15.

The command to provide access on the database to users

a)

Grant

b)

Revoke

c)

commit

16.

Multiple relations can be linked with relationship to _____

a)

Ensure data integrity

b)

Ensure data entry

c)

Create Primary Key

17.

Each category of information in a table is called ________

a)

Tuple

b)

Record

c)

Field

18.

The term used to refer to a information stored at a specific moment at database

a)

Instance

b)

Schema

c)

Attribute

19.

The properties of entities are otherwise known as

a)

Attribute

b)

Tuple

c)

Schema

20.

The DDL stands for

a)

Dynamic Data Language

b)

Detailed Data Language

c)

Data Definition Language

21.

A primary key with a foreign key

a)

creates Parent-Child relationship between the tables that connect them

b)

creates Many to many relationships between the tables that connect them.

c)

None of the above.

22.

Join is a

a)

Unary Operator

b)

Ternary Operator

c)

Binary Operator

23.

The relationship type in ER model is represented by

a)

Rectangle

b)

Ellipse

c)

Diamond

24.

A super key is a set of one or more attributes

a)

to identify uniquely an entity in the entity set

b)

to make the key most powerful for faster retrieval

c)

to increase effectiveness of database access

25.

……..is a combination of columns that uniquely identifies any row within a relational database management

a)

Candidate key

b)

super key

c)

Foreign key

26.

Aadhar no is an example for

a)

Foreign key

b)

Super key

c)

Primary key

27.

Which one of the following statements are true

a)

A prime attribute can be transitively dependent on a key in a BCNF relation.

b)

A relation in which every key has only one attribute is in 2NF

c)

All of above

28.

Choose the formula to find the Maximum number of possible superkeys for a table with n attributes

a)

2^(n-1)

b)

2^(n)

c)

(n-1)

29.

For a table Emp( sid, cid. stuname) find how many numbers of super keys are possible

a)

6

b)

5

c)

4

30.

.........normalization satisfies "no transitive dependency" condition

a)

2NF

b)

3NF

c)

1NF

31.

Statement I : Is it possible to send multiple parameters in procedures Statement II : Is it possible to combine function and procedure in a single program

a)

true, false

b)

true,true

c)

false, false

32.

which project operator combines the related tuples in the relation

a)

select

b)

rename

c)

Join

33.

Relational algebra is a

a)

Non-procedural query

b)

Procedural query

c)

Complex query

34.

Which command is used inserts & delete attributes based on constraints

a)

update

b)

alter

c)

delete

35.

Which SQL keyword is used to sort the attribues

a)

Distinict

b)

Group by

c)

order by

36.

Which of the following command is not used for subqueries

a)

view

b)

all

c)

in

37.

The users friendly interface is used by

a)

Naïve users

b)

Sophisticated end users

c)

Admin

38.

Primary key must be made by combining two columns

a)

True

b)

False

c)

May be

39.

To ensure the candidate key, it must be

a)

minimal

b)

optimal

c)

dual

40.

From the following functional dependency professor → subject falls in

a)

3NF

b)

BCNF

c)

2NF

41.

..... is the constraint which specifies uniqueness

a)

row

b)

key

c)

field

42.

Cartesian product produces the relation that has attributes of R1 and R2

a)

R1 and R2

b)

R1

c)

R2

43.

………..operation takes two tables as input with a single common column

a)

Cartesian Product

b)

Join

c)

Restriction

44.

Which of the following relational algebra operations do not require the participating tables to be union-compatible?

a)

Join

b)

Difference

c)

Union

45.

Relational Algebra does not have contain

a)

Selection operator.

b)

Aggregation operators

c)

Projection operator

46.

......... constraint is used to limit the value range that can be placed in a column

a)

is

b)

As

c)

Check

47.

which symbol is used to matches all substring pattens

a)

//

b)

\\

c)

%

48.

..... command is not used to check the presence of the attribute

a)

not exists

b)

exists

c)

null

49.

...... which command checks the valid date, date-time, etc

a)

istime

b)

isdate

c)

date

50.

.....function returns the values of the last row in an ordered partition

a)

Last Value

b)

Rank

c)

Lead