Other Bachelor Degree- DATABASE ADMINISTRATION (Karunya University, Coimbatore-2011)
Friday, 23 August 2013 11:38anudouglas
Karunya University
(Karunya Institute of Technology and Sciences)
(Declared as Deemed to be University under Sec.3 of the UGC Act, 1956)
Supplementary Examination - June 2011
Subject Title: DATABASE ADMINISTRATION Time: 3 hours
Subject Code: CA357 Maximum Marks: 100
Answer ALL questions (5 x 20 = 100 Marks)
1. Compulsory:
Describe all the steps to create a database in Oracle.
2. Explain all the steps in SQL statement processing and list the benefits of the shared SQL area.
(OR)
3. a. Explain about the various storage parameters associated with logical database objects.(10)
b. Explain the procedure to display database storage information in detail (10)
4 Explain how to manage tables and indexes in detail.
(OR)
5. Describe how to manage data Integrity constraints in detail.
6. Explain in detail how to manage users.
(OR)
7. Explain how to manage Database Access and Roles.
8. a. What is the general process for taking a logical export? (10)
b. What is an online backup? What is the process for taking an online backup? (10)
(OR)
9. Why should business requirements be considered when devising a backup and recovery strategy?
Earning: ₹ 0.00/- |