Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a data block, an extent and a
segment.
- 2 Answers
- 10720 Views
- I also Faced
- E-Mail Answers
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 is the default fill factor value? : sql server DBA
who owns the operating system files created by the utl_file package?
how can you implement fine-grained auditing?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Explain materialized views and how they are used.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
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.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the recovery models for a database? : sql server DBA
what do you understand by fine-grained auditing?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
