Earn upto Rs. 9,000 pm checking Emails. Join now!

Enter your email address:

Delivered by FeedBurner

Wednesday, October 17, 2007

(Question paper Punjabi university) Relational database management system and oracle-MS-124

Relational database management system and oracle-MS-124
Time : three hours MM – 80
Note :- Attempt five questions in all, selecting exactly one from each of the secations A, B, C and D. section E is compulsory.

Section A
1. Discuss the three level architecture of database management system. Explain the various types of data independence. How mapping is performed between different levels of database architecture ? explain .

2. define and distinguish between network and hierarchical models.

Section-B
3. (a) What are the properties of a valid relation ?
(b) define the following concepts :
(i) Relation
(ii) domain
(iii) union compatibility.
4. (a) Define functional dependency. Discuss various types of functional dependency.
(b) what are the consequences of bad database design ? explain.
Section- C
5. Define database integrity. What are the various types of database integrity ? explain.
6. Define distributed database. What are the tradeoffs in using distributed database ? what are the various methods of data distribution ? explain.

Section-D
7. what is a cursor. Write a procedure in PL-SQL using to compute income tax based on the following information:
(a) if gross pay <=40000 then IT rate 0%
(b) if gross pay >40000 but <=60000 then IT rate 10%
(c) if gross pay >60000 but <=100000 then IT rate 20%
(d) if gross pay >100000 then IT rate 30%
For the purpose create a table with the following information:
(a) basic pay
(b) dearness allowance (85% of basic pay)
(c) house rent allowance (15% of basic pay+da)
(d) medical allowance (rs 450 pm)
(e) city compensatory allowance (350 pm)
(f) enter values in the table so that all the cases can be checked.
8. what are the various background processes of oracle ? explain the role of each process.
Section –E
1. who are the different users of the database system ?
2. what is the difference between super key and candidate key ?
3. what is the purpose of DDL, DML, and DCL ?
4. define domain compatibility.
5. define full function dependency.
6. what are the threats to the database ?
7. define two phase locking protocol.
8. what is the differences between backward recovery and forward recovery ?
9. define deadlock.
10. define two phase commit protocol .
11. what is the philosophy behind client /server architecture ?
12. define data warehousing .
13. what are spatial databases ?
14. view is stored query. Justify this statement.
15. define trigger.
16. what is a cursor?

3 comments:

Anonymous said...

Good words.

Anonymous said...

Seeing these kind of posts reminds me of just how technology truly is undeniably integral to our lives in this day and age, and I can say with 99% certainty that we have passed the point of no return in our relationship with technology.


I don't mean this in a bad way, of course! Ethical concerns aside... I just hope that as technology further develops, the possibility of uploading our brains onto a digital medium becomes a true reality. It's a fantasy that I daydream about almost every day.


(Posted on Nintendo DS running [url=http://cryst4lxbands.blog.com/2010/01/31/will-the-r4-or-r4i-work/]R4i SDHC[/url] DS Qezv2)

Anonymous said...

hi ppl. I'm really into shoes and I had been looking for the sake of that particular brand. The prices as regards the shoes were all over 310 pounds on every site. But for all I found this area selling them as a remedy for half price. I really like these [url=http://www.shoesempire.com]prada sneakers[/url]. I will probably purchase those. what can you tell me about these?

 
Thanks

Total Pageviews