MED ICT ICTED 525 Advanced Database Management System 2080

TRIBHUVAN UNIVERSITY

Faculty of Education

2080 (New Course)

Master/2nd Semester/ICT.Ed.525 Advanced Database Management System

Symbol No.:

Attempt all questions

Group "A" 10 X 1 mark=10

Tick(V) the best answers

1. Which of the following establishes a top-to-bottom relationship among the items?

a. Relational schema

c. Hierarchical schema

b. Network schema

d. All of the mentioned

2. According to the enhance-entity relationship, the association between super class and subclass is as......

a. Super class is subset of subclass

b. Subclass is subset of super class

c. Subclass is partial joint of superclass

d. Super class is partial joint of subclass

3. The given Query can also be replaced with...........

SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

a. Select name,course_id from teaches, instructor where

Instructor_id=course_id;

b. Select name, course_id from instructor natural join teaches;

c. Select name, course_id from instructor;

d. Select course_id from instructor join teaches;

4.........................is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data

a. Procedures

c. Functions

b. Triggers

d. None of the mentioned

5. ....Values?

a. ANY

c. ALL

b. BETWEEN

d. IN

6. Which SQL constraint do we use to set some value to a field whose value has not been added explicitly?

a. UNIQUE

c. DEFAULT

b. NOT NULL

d. NAN

7. The process of finding a good strategy for processing a query is called ..........

a. Query optimization

c. Query Management

b. Query Processing

d. Query cost

8..........a process of dividing the whole or full database into various sub tables or sub relations so that data can be stored in different systems.

a. Fragmentation

c. Allocation

b. Replication

d. Duplication

9. Which of the following is true of NoSQL Database?

a. They do not support very large amounts of sparse data.

b. They do not support distributed database architectures.

c. They are not based on the relational model

d. They are geared toward transaction consistency rather than performance.

10. NoSQL can be refered to as.

a. No SQL

c. Not Only SQL

b.Only SQL

d. 50L Undefined

TRIBHUVAN UNIVERSITY

Master / Education/2nd Semester

2080 (New Course)

Full Marks: 40

ICT.Ed.525 Advanced Database Management System

Time: 3 hrs.

Attempt all questions

Group "B"

1. Explain the process of EER to relational mapping with an example.

2. What is join in database management system? Explain different types of outer join with example.

OR

Consider the following table definitions and complete the questions below:

Sailors (sid: integer, sname: string, rating: integer, age: real)

Boats (bid: integer, bname: string, color: string)

Reserves(sid: integer, bid: integer, day: date)

a. Find all sailors with a rating above 7

b. Find the names of sailors 'Who have reserved boat number 103.

c. Find all sids of sailors who have a rating of 10 or reserved boat 104.

d. Find the names of sailors who have reserved boat 103

4

5. What do you mean by integrity constraint? Explain domain andreferential integrity.

6. Differentiate between attributes and elements in XML? List some of the important attributes used in specifying elements in XML schema.