Exam Details
| Subject | advanced database design | |
| Paper | paper 22 | |
| Exam / Course | m.c.a | |
| Department | ||
| Organization | Nalanda Open University | |
| Position | ||
| Exam Date | 2016 | |
| City, State | bihar, patna |
Question Paper
N A L A N D A O P E N U N I V E R S I T Y
Master of Computer Application Part-III
PAPER-XXII
(Advanced Database Management Systems)
Annual Examination, 2016
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. How do UML diagrams help in designing the database? Discuss with the help of an example.
How does data granularity affect the performance of concurrency control? Do you think that
data granularity and database security are interrelated Justify your answer.
2. Consider the following situation
"A company has two employee named "A" and "B". The company has two projects P1 and P2.
Project P1 uses languages C and whereas project P2 uses languages C and JAVA.
Employee whose name is "A" works on both the projects P1 and P2, whereas employee
named "B" works on project P2 only."
Represent the information given above as a relation/ tables.
List the FDs and MVDs in the table above.
Normalize the table upto 4th Normal Form.
3. Compare and contrast the distributed DBMS environment with the centralized DBMS
environment. What are semantic databases? List the features of semantic databases. Explain
the process of searching the knowledge in these databases.
4. What do you mean by Deadlock? How can we prevent Deadlock? Write an algorithm that
checks whether the concurrently executing transactions are in deadlock or not.
5. What is a data warehouse? Describe the process of ETL(Extract, Transform and Load) for a
data warehouse. What are datamarts? Briefly discuss the method of creating the data marts.
6. Explain the role of Query Optimizer in Oracle. Explain the algorithm and cost calculation for
Simple Hash Join.
7. Differentiate between the following
Embedded SQL and Dynamic SQL
XML and HTML
2 PC and 3 PC Protocol
JDBC versus ODBC
8. What are cursors, stored procedures and triggers? Give SQL syntax for each and discuss the
utility aspect of each.
9. Write a short note, with suitable example, for each of the following
Vendor-Specific Security
Multilevel Security
10. Explain the following with the help of an example and diagram
Role of system catalogue
Nested loop join
Timestamp and its use
Fragmentation and allocation schema
Master of Computer Application Part-III
PAPER-XXII
(Advanced Database Management Systems)
Annual Examination, 2016
Time 3 Hours. Full Marks 80
Answer any Five Questions.
All questions carry equal marks.
1. How do UML diagrams help in designing the database? Discuss with the help of an example.
How does data granularity affect the performance of concurrency control? Do you think that
data granularity and database security are interrelated Justify your answer.
2. Consider the following situation
"A company has two employee named "A" and "B". The company has two projects P1 and P2.
Project P1 uses languages C and whereas project P2 uses languages C and JAVA.
Employee whose name is "A" works on both the projects P1 and P2, whereas employee
named "B" works on project P2 only."
Represent the information given above as a relation/ tables.
List the FDs and MVDs in the table above.
Normalize the table upto 4th Normal Form.
3. Compare and contrast the distributed DBMS environment with the centralized DBMS
environment. What are semantic databases? List the features of semantic databases. Explain
the process of searching the knowledge in these databases.
4. What do you mean by Deadlock? How can we prevent Deadlock? Write an algorithm that
checks whether the concurrently executing transactions are in deadlock or not.
5. What is a data warehouse? Describe the process of ETL(Extract, Transform and Load) for a
data warehouse. What are datamarts? Briefly discuss the method of creating the data marts.
6. Explain the role of Query Optimizer in Oracle. Explain the algorithm and cost calculation for
Simple Hash Join.
7. Differentiate between the following
Embedded SQL and Dynamic SQL
XML and HTML
2 PC and 3 PC Protocol
JDBC versus ODBC
8. What are cursors, stored procedures and triggers? Give SQL syntax for each and discuss the
utility aspect of each.
9. Write a short note, with suitable example, for each of the following
Vendor-Specific Security
Multilevel Security
10. Explain the following with the help of an example and diagram
Role of system catalogue
Nested loop join
Timestamp and its use
Fragmentation and allocation schema
Other Question Papers
Subjects
- (internet concepts and web design
- accounting & financial management
- advanced database design
- advanced discrete mathematics
- advanced internet technologies
- advanced internet technologies and computer graphics set-i
- advanced internet technologies and computer graphics set-ii
- application development with .net framework
- artificial intelligence and knowledge management
- c and assembly language programming
- communication skill
- communication skills
- computer graphics and multimedia
- computer networking
- computer organization
- computer organization and assembly language programming
- data and file structures
- data communication and computer networks
- database management system
- design and analysis of algorithm
- discrete mathematics
- internet concepts and web design
- introduction to database management systems
- lab (for data and file structures, networking and java programming)
- laboratory course
- management and information system
- mcs-041 : operating systems
- numerical and statistical computing
- object oriented analysis and design
- object oriented programming using java
- object oriented technologies and java programming
- operating system
- operating system concepts and networking management
- operating systems
- principles of management and information systems
- problem solving and programming
- problem solving using c
- software engineering
- system analysis and design
- systems analysis and design
- unix and oracle
- unix and oracle set-i
- unix and oracle set-ii