IMT - 37: DBMS (ORACLE)

PART- A

Q1. Classify various database models used in database programming. Explain ER model in detail.

Q2. Explain how various normalization rules helps in removing redundancy from a database design. Differentiate between 3rd and BCNF rules.

Q3. How the implementation and design of object oriented database systems is different from non object oriented database systems.

Q4. Explain how data retrieval can be improved using Table Indexes and Table partitioning.

Q5. Name and explain various Database schema object.

PART- B

Q1. How the problems of transaction failures can be checked using Redo Log files? Also explain the significance of Commit and Rollback statements.

Q2. Explain how the architecture of Distributed database management system is different from client server architecture.

Q3. What do you understand by Oracle Instance? Explain oracle memory structure in reference to all processes in Oracle instance.

Q4. Explain Oracle database schema in reference to Physical and Logical layer. Also explain relationship between tablespaces and data files.

Q5. Explain the role of Oracle Enterprise Manager in configuring and managing Oracle database.

PART - C

Q1. What is the role of init.ora file in Oracle database? Explain various parameters in init.ora file.

Q2. What is the role of database triggers? Explain various different types of triggers including instead of triggers.

Q3. Explain the role of SYS and SYSTEM User ID in Oracle database. What all privileges are given to new user created in Oracle. Give supporting SQL command.

Q4. Explain Oracle database schema in reference to Physical and Logical layer. Also explain relationship between tablespaces and data files.

Q5. Explain the role of Oracle Enterprise Manager in configuring and managing Oracle database.

CASE STUDY-1

A$100 million chain of general stores is struggling to implement information system. Due to lack of proper information system, the store management is unable to maintain the daily records of customers, products sold, and there is a total confusion on reports like demand and supply of products in various retail outlets, etc leading to a poor supply chain management. The basic requirement of the information system is to manage data for customers, products, demand and supply records in particular retail outlets, quantity supplied and available, payments made by customers, etc. That is to develop a small supply chain management system.

Question

1. Suggest the database design for above system with ER model using UML notations.

CASE STUDY-2

A big manufacturing industry in consumer goods located in different countries is facing huge loses due tomismanaged data. Existing system is not capable enough to tackle the integration of various key departments like: stores, shop floor, plant maintenance, manufacturing, quality, sales and distribution, etc. One department is not in a position to know the status of process and items available in other. E.g. sales department while bidding for the orders, can not calculate the existing capacity, product balance in warehouse, etc. Management want to integrate at least purchase, manufacturing and sales department of the organization to start with.

Questions

1. Purpose process flow of purchase, manufacturing and sales departments.