ADBMS-Unit 3-Questions

Unit3 Questions

1.       With an example explain the generalized model for active database. [8]

2.       Give the syntax summary for specifying triggers in oracle system. [6]

3.       What is the fundamental difference between row  level and statement level active rules? [2]

4.       Consider the simplified company database shown below (with usual notations):

       EMPLOYEE

Name

ssn

Salary

Dno

Supervisor –ssn

      DEPARTMENT

Dname

Dno

Total- Salary

Manager-ssn

    

The total salary attribute is a derived attribute whose value is the sum of salaries of all employees who are assigned to a particular department. Write the triggers (active rules) For automatically maintaining the consistency of total salary of department in the notation of the oracle DBMS. [12]    

5.       Discuss the design and implementation issues for active databases. [7]

6.       Discuss the following SQL standard components: [12]

i) SQL/Foundation

ii) SQL/CLL (Call Level Interface)

iii) SQL/PSM (Persistent Stored Model)

iv) SQL/Binding and SQL/Temporal

7.       Explain In detail the temporal database concepts. [10]

8.       With examples, explain the range query and nearest neighbor query of spatial queries. List the application of spatial databases.
[6]

9.       Explain the categories of spatial queries with example.  [6]

10.    How do spatial database differ from regular databases? Discuss the different categories of spatial queries. Also, write the various types of multimedia sources. [8]

11.    Explain Prolog/Datalog notations  with example.  [6]

12.    Describe the concepts of deductive databases in detail. [10]

13.    Discuss the multimedia database concepts. [7]

14.    Briefly discuss multimedia application based on their data management characteristics. [6] (Also in Unit 6)

15.    Briefly explain the nature of multimedia data and multimedia applications in the present scenario. Also discuss the issues to be addressed in multimedia data management. [10] (Also in Unit 6)