Explain the difference between a data block, an extent and a
segment.
Answers were Sorted based on User's Feedback
Answer / wafa
data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / gaya
The oracle server manages the storage space in the datafiles
in units called oracle blocks or data blocks.
A segment is the space allocated for a specific logical
storage structure within a tablespace.
Space is allocated to a segment by extents.One or more
extents make up a segments.
| Is This Answer Correct ? | 6 Yes | 7 No |
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
how can you record information about current session?
Why would you call update statistics? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is grd?
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
What the different topologies in which replication can be configured? : sql server DBA
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what is rebuild index??
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)