MIT4002 Database Administration M.Sc Question Bank : uou.ac.in
Name of the University : Uttarakhand Open University
Degree : M.Sc
Department : Information Technology
Subject Code/Name : MIT4002 Database Administration
Year : II
Semester : IV
Document Type : Model Question Paper
Website : uou.ac.in
Download Model/Sample Question Paper : https://www.pdfquestion.in/uploads/uou.ac.in/4647-MIT-4002.pdf
Database Administration :
M. Sc. IT-10 (Master of Science in Information Technology)
Fourth Semester Examination 2012
Time : 3 Hrs
Related / Similar Question Paper :
UOU MA Linux Administration Question Paper
Max Marks : 60
Note : the question paper is divided in three sections – A, B and C. Answer the
questions as per instructions given in each section.
Section-A
(Long Answer’s Questions)
Answer any two questions. Each question carries 15 marks. 2 x 15 = 30
1. a) Discuss architecture of a typical database system with the help of suitable diagram. Explain its components in detail.
b) Explain different types of data independence.
2. a) Discuss different types of failures in oracle environment.
b) Explain database backup and recovery strategies.
3. a) Discuss Oracle Net Stack Architecture.
b) What are stored procedures? How do we accept arguments in stored procedures? Explain with the help of suitable example? How do we modify existing stored procedures?
4. a) How do we test backup and recovery plan?
b) What is privilege management in Oracle? How do we grant and revoke privileges?
Section-B
(Short Answer’s Questions)
Answer any four questions. Each question carries 5 marks. 4 x 5 = 20
1. Discuss roles and responsibilities of a Database Administrator.
2. What are different network design considerations in network administration?
3. Write short note on performance tuning.
4. What are views? Explain with the help of suitable example. Write syntax to create a view.
5. What is use of GROUP BY clause in SQL? Explain with the help of suitable example.
6. What is referential integrity? Differentiate between primary key and foreign key.
7. How constraint management is achieved in a typical RDBMS?
8. Discuss physical and logical storage structure.
Section-C
(Objective Type Questions)
Answer all questions. Each question carries 01 mark. 10 x 1= 10
Choose the correct option
1. _______ returns total number of records in a table
a. Unique b. Distinct c. Count d. Max
2. _______ returns records of a table in descending order
a. Order By DESC b. Order By Decreasing c. Order by Descending
d. Descending Order By
3. SQL stands for _____________
a. Simple query language b. Structured query list
c. Structured query language d. Systematic query language
4. To create a table ______ command is used
a. Create table <Table-Name>b. Create <Table-Name>
c. Create table name=<Table-Name>d. Create def <Table-Name>
5. To modify an existing stored procedure following command is used
a. Edit Stored Procedure Name b. Modify Stored Procedure Name
c. Change Stored Procedure Named. Alter Stored Procedure Name
1. Oracle is only a Database System (True / False)
2. Primary key can be a combination of multiple columns (True / False)
3. Foreign key ensures referential integrity (True / False)
4. DROP command is used to delete all the records of a table (True / False)
5. Select count(*) from Table name will return record count after eliminating duplicate values. (True / False)
Fundamental of Database Management System :
Time : 3 Hours
Maximum Marks : 60
Note : This paper is of sixty (60) marks divided into three (03) sections A, B, and C. Attempt the questions contained in these sections according to the detailed instructions given therein.
Section – A : (Long Answer Type Questions)
Note : Section ‘A’ contains four (04) long-answer-type questions of fifteen (15) marks each. Learners are required to answer any two (02) questions only. (2×15=30)
1. What is Normalization? Explain INF, 2NF and 3NF with an example.
2. Consider the following collection of relation schemes :
professor(profname, deptname)
department(deptname, building)
committee(commname, profname)
(a) Find all the professors who are in anyone of the committees that Professor Smith is in..
(b) Find all the professors who are in at least all those committees that Professor Smith is in.
(c) Find all the professors who are in exactly (i.e., no more and no less) all those committees that Professor Smith is in.
(d) Find all the professors who have offices in at least all those buildings that Professor Smith has offices in.
3. What is Deadlock? Discuss the different ways of preventing deadlock and detecting deadlock?
4. Answer the following :
(a) Why some functional dependencies are called trivial?
(b) Discuss the different database anomalies.
(c) Describe the three levels ofdata abstraction?
(d) How can you sort the records of a table in the output table?
Section – B : (Short Answer Type Questions)
Note : Section ‘B’ contains eight (08) short-answer-type questions of five (05) marks each. Learners are required to answer any four (04) questions only. (4×5=20)
1. What are the characteristics of SQL? Explain the SQL logical operators with examples.
2. What do you mean by the terms : field, record, file? Explain with examples.
3. Explain the different types of keys with an example.
4. Differentiate between a strong entity set and a weak entity set.
5. What is the difference between DROP TABLE command and TRUNCATE command?
6. Mention the differences between text files and database files. Why are database files preferred in a commercial organization?
7. What is logical data independence and why is it important?
8. Explain :
(a) Differentiate between implicit and explicit cursor
(b) Differentiate between entity integrity and referential integrity
(c) Database security.
(d) Distributed databases