Database Administration Model

Group A

Long Answer Questions (Attempt any TWO questions) [2 x 10 = 20]

2. You are working as DBA in Nepal Clearing House Limited which handle 24/7 online system. You have to design security and backup procedure for the organization.

3. What are the various kinds of performance report available in the oracle database management system mention the name and describe them one by one.

Group B

Short Answer Questions (Attempt any Eight questions) [8 x 5 = 40]

4.What is DML? Explain all the SML command with suitable example.

5. What is a view? Write an importance of view.

6. Explain the role of database administrator?

7. What is ASM? Mention the capabilities of ASM.

8. Write the command to add new redo group and drop group in the database.

9. Write DDL command for following.

a. Change table product to product_org

b. Add new check constraints in the status field of product_org table value of status field should always (00, 01 and 09)

c. Create backup table of sales

d. Disable check constraint in the table.

10. What is AWR report? Write all the component of AWR report.

11. What do you mean by parallel instance recovery?

12. Write a trigger to create log of every update and delete statement of product table.

13. Write short note of followings:

a. Step to create backup device

b. Internet database connector