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 |
How many packages we have in db
suppose you want to audit specific activities on sensitive data. How can you achieve that?
the process of adding a cpu in sql server is called..?
When creating a user, what permissions must you grant to allow them to connect to the database?
How would you go about increasing the buffer cache hit ratio?
Explain the concept of the DUAL table.
i had backup last manday.now i need back monday to now ..how do get backup?
What are the recovery models for a database? : sql server DBA
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
What are the different ways of moving data or databases between servers and databases in SQL Server?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
internal architecture
Oracle (3259)
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)