ലലല

رد
ويس م

WS
C 23299 SS

ಮು (Pages : 2) ആദരം... ടം 72

E 5

व ಬಾಸ ಸಜಾ ಹರಾ ಟಾ
FOURTH SEMESTER B.Sc. DEGREE EXAMINATION, APRIL 2017
(CUCBCSS-UG)
Computer Science
‘BCS 4B 06—FUNDAMENTALS OF DATABASE MANAGEMENT SYSTEM AND RDBMS
Time : Three Hours । Maximum : 80 Marks
Part A

Answer all the questions.
Each question carries 1 mark.

The insulation between programs and data is known as
A entity that does not have a key attribute is
The collection of information stored in database at a particular moment is called

ಹಾ tee

The relational algebra operation which allows us to find tuples that are in one relation but not in
another is called ————.

The ————— command is used to take back the privileges given to a user.
The overall logical structure of a database can be expressed graphically by means of
In DBMS the language used by the DBA and database designers for schema definition is

For unique identification of tuple in a relation, we use ——-—— keys.

(ಐ ಊ ಇ ga

option in a DROP command enables us to remove the database schema and all its tables,
domains and other elements.

10. The type of lock which allows us to perform write operation is ————.
(10 x 1 = 10 marks)
Part B

Answer all the questions.
Each question carries 2 marks.

11. Explain the term redundancy.

12. Define the term referential integrity.
18. List various forms of Join operation. -
14. What do you mean by a view in SQL ?
15. Define a cursor.

(5 x 2 = 10 marks)
Turn over