Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

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, syllabus wise question

Concurrency Backup and Recovery
1.
Describe levels of locking in oracle. Discuss the methods used to acquire locks in oracle. [10]
Database Maintenance And Performance Management
1.
What is Oracle AWR? How AWR report is viewed in oracle? [5]
Introduction Administration Basics
1.
Explain architecture of oracle database with suitable diagram. [10]
2.
What are the roles and responsibilities of Database Administrator? [5]
Managing Resources And Scheduling Tasks
1.
How event based schedules are created? Explain. [5]
Network Environment and Storage Structures
1.
What is listener? Explain about listener.ora and tnsnames.ora file in oracle database. [5]
Profiles, Resources, and Auditing
1.
What is user profile? Create a simple user profile and assign the profile to new user in oracle. [5]
Space Management And Oracle Support
1.
What is space management? How space management is done? How can you create tables without segments? [10]
2.
What is tablespace and datafile in oracle? How can we add new tablespace and datafiles in oracle database? [5]
Tuning And Moving
1.
What is SQL Tuning? Explain SQL Tuning Process in Oracle? [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? Explain its role in privilege management with suitable example. [5]