Database Administration · Unit 3
Database Startup, Shutdown and Initialization
Exam-focused notes for Database Startup, Shutdown and Initialization (Database Administration, BIT352): what the TU syllabus asks and how it has actually been tested, with 2 solved past questions from this unit.
What this unit covers
- Database startup modes and commands
- Database shutdown modes and commands
- Initialization parameter files
- Spfile versus Pfile differentiation
- Oracle defined roles and their usage
Spfile versus Pfile differentiation
What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example.[10]
Note: The reference notes did not contain material on this topic. The following answer is based on standard Oracle Database concepts as taught in BSc CSIT Database Administration courses. --- An Initialization Parameter File (also called an init file) is a ...
Full solved answer →Database startup modes and commands
Explain oracle database startup and shutdown modes with respective commands. [5]
Note: The reference notes did not contain this topic. The following answer is based on standard Oracle Database administration concepts, which are part of the TU BSc CSIT Database Administration curriculum. --- Oracle database startup is a three-stage proce...
Full solved answer →Make Unit 3 stick
Practice BIT352 with flashcards & quizzes