BIT Database Administration

bitsemester 6

This course introduces the database administration techniques in Oracle. Most of the DBA's tasks are covered. Topics covered include principles of DBA Roles, Oracle Database Architecture and storage management, Database backup, restoration and recovery, connectivity and user management for database security, tuning of database and overall DB administration which could be useful for administrator in the future.

Chapter Wise Notes Question Banks Syllabus Chapter Wise Questions Viva Practical

Institute of Science and Technology

2081

Bachelor in Information Technology

Database Administration

BIT352

Full Marks: 60

Pass Marks: 24

Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.

"Section A"

Long Answer Questions. Attempt any TWO questions.

[2 × 10 = 20]

Describe levels of locking in oracle. Discuss the methods used to acquire locks in oracle.

[5+5]

Explain architecture of oracle database with suitable diagram.

[10]

What is space management? How space management is done? How can you create tables without segments?

[2+4+4]

"Section B"

Short Answer Questions Attempt any EIGHT questions.

[8 × 5 = 40]

What are the roles and responsibilities of Database Administrator?

[5]

What is tablespace and datafile in oracle? How can we add new tablespace and datafiles in oracle database?

[2+3]

What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database.

[1+4]

What is Oracle AWR? How AWR report is viewed in oracle?

[2+3]

What is Role? Explain its role in privilege management with suitable example.

[1+4]

What is SQL Tuning? Explain SQL Tuning Process in Oracle?

[2+3]

What is user profile? Create a simple user profile and assign the profile to new user in oracle.

[1+4]

What is listener? Explain about listener.ora and tnsnames.ora file in oracle database.

[1+4]

How event based schedules are created? Explain.

[5]

BIT Database Administration

BIT Semester 6 Database Administration Question Paper 2081 – Solved

Institute of Science and Technology