Database Administration · Unit 5
Control Files and Multiplexing
Exam-focused notes for Control Files and Multiplexing (Database Administration, BIT352): what the TU syllabus asks and how it has actually been tested, with 1 solved past questions from this unit.
What this unit covers
- Control file definition and purpose
- Control file contents and structure
- Multiplexing control files
- Multiplexing using pfile procedures
Control file definition and purpose
010 marks
What is control file? What are the contents of control file? Explain the procedure of multiplexing control file using pfile.[10]
A control file is a small binary file that is essential to the Oracle database. It records the physical structure of the database and is read by Oracle at database startup. The control file must be available and accessible whenever the database is mounted o...
Full solved answer →Make Unit 5 stick
Practice BIT352 with flashcards & quizzes