Why database backup is needed? What are types of database backup? Explain the procedure of cold backup of oracle database with necessary commands. [10]
Database Maintenance And Performance Management
1.
Explain oracle database startup and shutdown modes with respective commands. [5]
2.
What is Oracle AWR? How AWR report is viewed in oracle? [5]
3.
Write short notes on: a. Data Pump b. Container Database [5]
Introduction Administration Basics
1.
Explain architecture of oracle database with suitable diagram. Explain different oracle background processes. [10]
Managing Resources And Scheduling Tasks
1.
Explain relationship between schedule, job and program. Create a Schedule in oracle. [5]
Network Environment and Storage Structures
1.
What is control file? What are the contents of control file? Explain the procedure of multiplexing control file using pfile. [10]
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 tablespace and datafile in oracle? How we can add new tablespace and datafiles in oracle database? [5]
2.
What is UNDO tablespace and UNDO RETENTION policy? How to view and alter UNDO RETENTION Policy 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]