Answer Posted / Akash Kumar Misra
A Data Block is a fixed-size unit of storage in Oracle Database. Each data block typically contains multiple rows from one or more tables, depending on the table's structure and block size settings. Data blocks are essential for efficient data management because they reduce I/O operations by caching frequently accessed data within the SGA (System Global Area). When a user queries data, the database first checks if the required data block is in the buffer cache; if not, it reads the data block from disk into the buffer cache.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
How to start an oracle instance?
How to select all columns of all rows from a table in oracle?
How to use values from other tables in update statements using oracle?
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
