1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
M.C.A.DEGREE EXAMINATION COMPUTER APPLICATIONS
FOURTHSEMESTER APRIL 2018
CA 4959- DATABASE ADMINISTRATION
Date: 09-05-2018 Dept. No. Max. 100 Marks
Time: 09:00-12:00
Part-A
Answer all the questions 10 X 2 20)
1. How will you start and shutdown a database
2. What is embedded SQL?
3. How will you retrieve tablespace information
4. What are roles
5. What are indexes
6. Write down the syntax for a cursor for loop?
7. What are undo tablespaces?
8. What is exclusive lock
9. What is incremental backup
10. What is database crash
Part-B
Answer all the questions 5 X 8 40)
11. Explain the steps to create and delete a data base.

Explain the database structure of oracle.
12. Write down the steps to create and edit the data base.

How will you retrieve table space for matrix?
13. Explain the categories of operators used in SQL .

What are stored procedures Create a procedure to read r and calculate
simple interest.
14. Types of maintenance operations.

How will you resolve the lock conflicts?
15. Explain the types of database backups.

Explain query tuning in SQL with example.
2
Part-C
Answer any two questions 2 X 20 40)
16. Explain the steps to be followed while installing oracle.
ii) Explain the ways of creating and assigning privileges and roles to users.
17. Explain views and the types of views.
ii) Explain deadlock management in oracle.
18. Explain the types of database failures.
ii) Write a trigger to copy the rows deleted from other table, with the same structure.
Use trigger.