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 |
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to make a replica of existing oracle server to another server?
Explain CREATE DATABASE syntax?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What view would you use to determine free space in a tablespace?
How to start SQL Server in minimal configuration mode?
how to restore files with rman?
What are the commands used in dcl? : sql server DBA
what is the use of ocr?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the recovery models for a database? : sql server DBA