A. An index block can contain row data. --> True.
ref: https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch3.htm
B. A data block header is of a fixed length. --> False.
ref: https://www.dba-oracle.com/t_data_block_format.htm
C. Row data is stored starting at the end of the block. --> True.
ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html
D. A table block must always contain row data. --> False.
ref: https://richardfoote.wordpress.com/category/block-dumps/
E. A block header contains a row directory pointing to all rows in the block. --> True.
ref: https://medium.com/geekculture/explain-about-oracle-database-data-block-interview-a-be137c52fe4d
A. An index block can contain row data. --> True, "Row Data" portion : This portion of the block contains table or index data.
B. A data block header is of a fixed length. --> False, the header of a data block has two areas a "common" area and a "variable" area. In the common area you have a fixed-size block header. ==> But it's different to say, I guess.
C. Row data is stored starting at the end of the block. --> True, "Space Management in Data Blocks" -> As the database fills a data block from the bottom up, the amount of free space between the row data and the block header decreases.
D. A table block must always contain row data. --> False, it also contains info about tab and col: If we look at a partial block dump of one of the table blocks.
E. A block header contains a row directory pointing to all rows in the block. --> True, a block header includes the information about block type information, whether it is a row block or an index block, and the information of tables that have the rows in it, and the row directory, means the addresses of each row in this block.
Header (Common and Variable)
The header contains general block information, such as the block address and the type of segment; for example, data, index, or rollback. While some block overhead is fixed in size, the total block overhead size is variable. On average, the fixed and variable portions of data block overhead total 84 to 107 bytes.
I'm sorry I was wrong. please remove this full comment with vote.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
auwia
Highly Voted 6 months, 3 weeks agoauwia
6 months, 3 weeks agozouve
Most Recent 5 months, 1 week agoauwia
6 months, 4 weeks agoauwia
6 months, 3 weeks ago