Oracle Admin Interview Questions and Answers - 1
What is the logical structure of the disk resource?
Following is the logical structure of the disk resources:
- Data block – Refers to the smallest logical storage unit. Size of a data block is a multiple of operating system block size.
- Extent – Refers to the contiguous set of data blocks, which is allocated as a unit to a segment.
- Tablespace – Refers to the final logical storage unit. It is mapped to physical data file.
- Segment – Allocates a logical structure, such as table. It is a set of extents, which are stored in the same tablespace.
What is LoGWRiter(LGWR)?
LGWR is the background process that writes redo information from redo log buffers to the log files.
What is the difference between multithreaded/shared server and dedicated server?
- In case of a dedicated server, a server process is associated with a single user process and serves it dedicatedly.
- In case of a shared server, a single server process can serve multiple user processes. This is achieved with the help of a dispatcher process, which places each process in a single request queue.
- Server process picks up the user process whenever it is free. After that, the server process puts the result in the individual response queue associated with different dispatcher processes.
How long does the rollback segment hold data to maintain consistency?
- Rollback segment holds the previous version of data block until either its gets committed or the space is not available for reuse.
- If a session is reading specific block from rollback segment while the other session has committed the information, then more rollback space is required to maintain more rollback information.
- In that case, this specific block ages out of the rollback segment and the reading or selecting session gets an error.
What background process refreshes materialized views?
The job queue processes refresh the materialized views.
1000+ Hydraulic Machines Multiple Choice Questions and Answers Pdf More
1000+ Hydraulic Machines Objective Questions and Answers Pdf More
1000+ Hydraulics MCQ, Objective Questions and Answers Pdf More
Railway Interview Questions and Answers Pdf More
Top 1000+ Indian Railway MCQ Questions & Answers More
100+ Reasoning Word Formation Questions for Bank Exams More
100+ PL/SQL Interview Questions and Answers for Experienced More
MS Word Objective Questions & Answers for Competitive Exams More
100+ Simplification Questions for SBI, IBPS PO, SO, Clerk Pdf More
TNPSC Group 1, 2, 2a, 4 Preposition Objective Questions and Answers More