SRM University 2007 B.Tech Information Technology IT202-Data Base Management Systems - Question Paper

40. Define object containment.
41. Define object relational system.
42. Define persistence programming language.
43. What is meant by ODMG standard?
44. Define object stores, persistence storage module (PSM).
45. Define nested relations & nested relational model.


Part-B

1. (a)Compare Object-oriented versus object relational data model.
(b)Write short notes on persistent programming languages.
2. Explain object-oriented data model in detail.
3. Explain object-oriented relational model in detail.
4. (a)Discuss in detail Referential integrity with examples.
(b)Write a short note on domain constraints.
5. (a) Briefly discuss Embedded SQL.
(b) describe a view.What are the conditions to be met for a view to be updateable?
6. Explain DDL commands with examples.
7. Explain DML commands with examples.
8. (a)Explain nested queries with example.
(b)Explain set operations with example.
9. Define procedural language. discuss in detail operations of relational algebra with examples.
10. Define nonprocedural language. provide example. discuss them in detail.
11. Write improper commands in SQL for the subsequent queries:
(a) Create a table pers with the subsequent attributes:
Empno , ename ,deptno,job,joining date .
(b) List the ename,empno where the job is manager and the joining date is after 12 jan 1995.
(c) List all the employees whose name begins with ‘K’.
(d) List all the employees who belong to dept no = one and group them in the order of their names in descending order.
(e) Add a new column pay to the table.
12. Write improper SQL commands for creating the subsequent constraints.
(a)Create sales_order table with sorder_no,product_no,qty_ordered,product_rate. Declare sorder_no and product_no as primary keys for the table.
(b) Create table client_master with unique constraint on column client_no.
(c) Add a check constraint on the client_no column of the client_master so that client_no value begins with ‘c’.
(d) Create table sales_order_details with primary key as sorder_no and product_no and foreign key as sorder_no referencing column sorder_no in the sales_order table.
(e)Drop the primary key constraint from sales_order table.

13. Consider the relational database provided beneath where the primary keys are underlined.

Earning:   Approval pending.