Bachelors Level/Third Year/Sixth Semester/Science bit/sixth semester/database administration/syllabus wise questions

Bachelors In Information Technology

Institute of Science and Technology, TU

Database Administration (BIT352)

Year Asked: 2081.1, syllabus wise question

Concurrency Backup and Recovery
1.
Explain the concept of Container database and Portable database. [5]
Database Maintenance And Performance Management
1.
What is Oracle AWR? How AWR report is viewed in oracle? [5]
Introduction Administration Basics
1.
What are different database administration tasks? Explain Oracle Data Guard in brief. [10]
Managing Resources And Scheduling Tasks
1.
What is Job and Job classes? Create an event-based schedule in Oracle. [5]
Network Environment and Storage Structures
1.
What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example. [10]
Profiles, Resources, and Auditing
1.
Why do you think database auditing plays a significant role? Explain. [5]
2.
Write short notes on: a. Audit Trail b. SQL Tuning Advisor [5]
Space Management And Oracle Support
1.
What is Tablespace? What is UNDO RETENTION Policy? Write different commands to manage the tablespaces in Oracle. [10]
2.
What is Extent? Explain Row chaining and Migration in brief. [5]
Tuning And Moving
1.
What is Data Pump? Explain the procedure of exporting and importing data using Oracle Data Pump. [5]
Users and Privileges
1.
What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database. [5]
2.
What is Role? Create a Role called “general” and grant privileges to the role general and assign that role to a user in oracle. [5]