Explain the difference between a data block, an extent and a
segment.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the role of dip user in our database?

2249


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

859


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1734


What is dcl? : sql server DBA

924


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2430


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2292


What the different topologies in which replication can be configured? : sql server DBA

945


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3209


How would you best determine why your MVIEW couldn't FAST REFRESH?

2083


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2215


how can you create a user-defined lock?

839


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1876


What are the commands you'd issue to show the explain plan for "select * from dual"?

2014


how can you enable flashback feature?

743


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1755