Database Management Systems University Questions 6

Database Management Systems University Questions 6

Database Management Systems

Time : Three Hours                                                                          Max.Marks:100

NOTE:

i) Neatly draw the diagrams and explain it, wherever required.

ii) Wherever the example is require, explain with an example.

PART – A (8 X 5 = 40 Marks)

Answer ALL Questions

1. Discuss in detail about the functions of DBMS.

2. Explain the ACID properties of a transaction.

3. Explain in details, how TCL statements are important in banking applications.

4. Discuss the concept of query optimization in DBMS.

5. How database differs from data warehouse and data mining?

6. Explain Functional dependency and Multi valued dependency with example.

7. What is the need of the normalization? Explain the first three steps involved in the normalization.

8. Explain the three schema architecture in detail with diagram.

PART – B (6 X 10 = 60 Marks)

Answer any SIX Questions

9. Describe the overall architecture of a DBMS.

10. Use an Entity-Relationship diagram to depict the information needs of the following engineering enterprise:

- Each engineer works on a number of projects. For every engineer a record is kept of his/her number, name, title and salary. For every project a record is kept of its number, name, budget and location. Additionally, the responsibility each engineer has on a particular project and the amount of time spent on the project is noted.

- Clients contract these projects. The clients name, address and phone number must be recorded. The contract date, i.e. the date at which the client signs the contract for a specific project is also noted. A record is also kept of the machinery being used for a particular project. The name, amount and the date the machinery is needed for the project is recorded.

Note: Include any attributes you think should be represented (state why). State any assumptions you have made.

11. How files are organized using hashing and discuss about handling bucket overflow.

12. Why is concurrency control needed? Explain lost update, Inconsistent retrievals and uncommitted dependency anomalies.

13. Explain how the items in the database are cataloged using indices and define the evaluation techniques used for evaluating it.

14. Discuss in detail about the features of Distributed Databases.

15. Consider the below table and write the SQL queries:

RegNo	SName	Branch	Grade	Age	Gender
238	Kumar	BE (CSE)	6.5	23	M
300	Megan	BSc (CS)	9.2	22	F
354	Morris	MSc (CS)	7.4	22	M
302	Harry	BSc (CS)	8.7	23	M
230	Ramesh	BE (CSE)	8.9	23	M

a) Display the maximum and average Grade of BE – CSE students alone with student names.

b) Renme the Gender column to Sex.

c) Display the minimum Grade in each branch.

d) Display all the student names that starts with ‘R’ or ‘A’

e) Update the branch ‘BE (CSE)’ as B.E, ‘BSc (CS)’ as ‘B.Sc’ and ‘MSc (CS)’ as ‘M.Sc’

16. When is a transaction said to be deadlocked? Explain the deadlock prevention methods with an example.

****************

Advanced Database Management Systems - Pune University May 2012 Questions

Advanced Database Management Systems - Pune University April May 2012 Questions / ADBMS April May 2012 Question Paper / B.Tech Information Technology ADBMS Pune University question paper with answer

Total No. of Questions : 12]                                                              [Total No. of Pages : 2

P1476 [4164] - 724

B.E. (IT)

ADVANCED DATABASE MANAGEMENT SYSTEM

(Elective - I) (2008 Pattern) (Sem. - I)

Time :3 Hours]                                                [Max. Marks :100

Instructions to the candidates:-

1) Answer three questions from each Section.

2) Answers to the two sections should be written in separate books.

3) Figures to the right indicate full marks.

4) Neat diagrams must be drawn wherever necessary.

5) Assume suitable data, if necessary.

SECTION – I

Q1) a) Draw PL/SQL block structure and execution environment. Explain each block. [8]

b) Which control structures are allowed in PL/SQL? [8]

OR

Q2) What are cursors in PL/SQL? Write a cursor to calculate a bill in cake shop for a customer. [16]

Q3) a) What are transactional workflows? [8]

b) What are two-phase locks? Give an example. [8]

OR

Q4) a) Specify the need of concurrency control mechanisms. State the mechanisms. [8]

b) What are compensating transactions? [8]

Q5) a) What are the limitations of RDBMSs? [10]

b) What is XML DTD? Explain with example. [8]

OR

Q6) a) How is inheritance implemented in SQL? [8]

b) How is querying and transformation done in XML? [10]

SECTION - II

Q7) a) Write a short note on classes of schemas that are popularly used for modeling data warehouse. [9]

b) What is preprocessing? What is the need of this step while building data warehouse? [9]

OR

Q8) a) Explain how Oracle implements data warehouse. [9]

b) What does ETL mean? Explain any ETL tool in short. [9]

Q9) a) What is k-means algorithm used for? Explain with help of example. [8]

b) What is data mining? Mention any five algorithms. [8]

OR

Q10) Write short notes on : (any two) [16]

a) Categories of OLAP tools

b) Supervised and unsupervised learning

c) Classification algorithm

Q11) a) What are locks? Why do we need them? What are the disadvantages of locks? [8]

b) Write a note on Database threats. [8]

OR

Q12) a) Explain statistical database auditing. [8]

b) What is the need of granting and revoking privileges? [8]

***************

Advanced Database Management Systems - Pune University December 2011 Questions

Advanced Database Management Systems - Pune University December 2011 Questions / ADBMS November December 2011 Question Paper / B.Tech Information Technology ADBMS Pune University question paper with answer

Total No. of Questions : 12]                                                         [Total No. of Pages :3        P 608

[4064] - 604

B.E. (IT)

ADVANCED DATABASE MANAGEMENT

(2008 Course) (414443(A)) (Sem. - I) (Elective - I)

Time : 3 Hours]                                                                                            [Max Marks : 100 Instructions to candidates :

1) Answers to the two sections should be written in separate books.            

2) Neat Diagrams must be drawn wherever necessary.

3) Figures to the right indicate full marks.

4) Assume suitable data if necessary.

5) All questions are compulsory.

SECTION-I

Q1) a) What is the need of PL/SQL? Draw PL/SQL block structure and execution environment. Explain each block. [8]

b) How can you trap exceptions in PL/SQL? Write a code fragment to trap any three exceptions. [8]

OR

Q2) Write an UPDATE trigger on a table that keeps track of old values of the updated record. Add old values in another table. Create required tables and write SQL statements for the same. [16]

Q3) a) What are TP monitors? Explain the TP-Monitor architectures. [8]

b) What are two-phase locks? Give an example. [8]

OR

Q4) a) Write a note on long-duration transactions. What are the key properties they must have? [8]

b) What are compensating transactions? [8]

Q5) a) Where you would need to use Complex data types? How would you declare structured types using SQL: 1999? [10]

b) What is XML DTD? Explain with example. [8]

OR

Q6) a) Write a note on XML applications. [8]

b) In order to turn a language into database programming language, we need to make objects persistent. Explain different approaches. [10]

SECTION-II

Q7) a) Suppose that a data warehouse consists of three dimensions time, doctor and patient, and the two measures count and charge where charge is the fee that a doctor charges a patient for a visit. [9]

i) Enumerate three classes of schemas that are popularly used for modeling data warehouse.

ii) Draw a schema diagram for the above data warehouse using one of the schemas listed above.

b) Define data warehouse. Explain each clause in the definition. Can RDBMSs be used instead of warehouses? Give reasons. [9]

OR

Q8) a) What is the need of extraction, cleaning and transformation while building data warehouse? Give examples to support your answer. [9]

b) Describe how a dimensional model differs from an Entity-Relationship (ER) model present a diagrammatic representation of a typical star schema and state its advantages and disadvantages. [9]

Q9) a) What is market-basket analysis? Explain the algorithm that implements this concept. [8]

b) Explain in detail any four OLAP functions which are extensions to SQL. [8]

OR

Q10) Write short notes on: (any two) [16]

a) Categories of OLAP tools.

b) Supervised and unsupervised learning

c) OLAP benchmarks and applications.

Q11) a) Explain Implicit Locking. How does Oracle implement it? [8]

b) Write a note on Database Security and the threats. [8]

OR

Q12) a) How will you implement business rule validations? [8]

b) Explain the following in terms of providing security for a database: [8]

i) Authorization.

ii) Encryption.

*********

Database Management Systems - University Questions

Database Management Systems (DBMS) - University Questions / Database Management Systems (DBMS) - Previous Year University Questions with Answers

• Anna University - Chennai

• Cochin University of Science andTechnology - Cochin

• Gujarat Technological University - Ahmedabad

• Savitribai Phule Pune University / University of Pune - Pune

• University of Mumbai - Mumbai

• Visvesvaraya Technological University