80867 (Pages : 2)

Time

1.
2
3
4
5.
6
7
8
9
10.

11.
12.
13.
14.
15.

ಬ ۶ ۶-٣۶ ‏ممم ممعم‎ 5

FOURTH SEMESTER (CUCBCSS—UG) DEGREE EXAMINATION

APRIL 2020

Computer Science

BCS 4B 05—DATABASE MANAGEMENT SYSTEM AND RDBMS

(2017 Admissions)

: Three Hours

Part A

Answer all questions.
Each question carries 1 mark.
What is an entity set ?
What is logica] schema ?
Define cardinality.
What is data dictionary ?
DML stands for

A tuple is also known as

What is primary key ?
What is the purpose of ROLL BACK ?
To avoid duplicate rows from an SQL database use

What is trigger ?

Part B
Answer all questions.
Each question carries 3 marks.
What you meant by functional dependency ?
Explain built-in functions in SQL.

Describe array statements.
Define different DCL commands.

Explain aggregate functions.

Maximum : 80 Marks

command.

(10 x 1 = 10 marks)

(5 x 3 = 15 marks)

Turn over