Tribhuvan University
Bachelor of Information Technology
Semester 6 · TU Board 2081
Course Title: Database Administration (BIT352)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable.
Group A
Attempt any Two questions.(2 × 10 = 20)
- 1.10
What are different database administration tasks? Explain Oracle Data Guard in brief.
Answer comingAlso asked in 2079
- 2.10
What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example.
- 3.10
What is Tablespace? What is UNDO RETENTION Policy? Write different commands to manage the tablespaces in Oracle.
Group B
Attempt any Eight questions(8 × 5 = 40)
- 4.5
What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database.
Answer comingAlso asked in 2080
- 5.5
What is Oracle AWR? How AWR report is viewed in oracle?
Answer comingAlso asked in 2080
- 6.5
What is Data Pump? Explain the procedure of exporting and importing data using Oracle Data Pump.
- 7.5
Explain the concept of Container database and Portable database.
- 8.5
What is Job and Job classes? Create an event-based schedule in Oracle.
- 9.5
What is Extent? Explain Row chaining and Migration in brief.
- 10.5
What is Role? Create a Role called "general" and grant privileges to the role general and assign that role to a user in oracle.
- 11.5
Why do you think database auditing plays a significant role? Explain.
- 12.5
Write short notes on: a. Audit Trail b. SQL Tuning Advisor
— The End —