Explain the difference between a data block, an extent and a
segment.
Answer Posted / 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 |
Post New Answer View All Answers
What would you do with an "in-doubt" distributed transaction?
What are the operating modes in which database mirroring runs? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
how can you implement fine-grained auditing?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is a correlated sub-query? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How would you go about verifying the network name that the local_listener is currently using?
how can you find out if a table can be redefined?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
. 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?
What are the steps you will take to improve performance of a poor performing query?