What is an Extent ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
An Extent is a specific number of contiguous data blocks,
obtained in a single allocation, used to store a specific
type of information
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mahima
it is basic unit of storage space for table and index. it
allocate s0pace for table and index row data.its having 8
64k datapages.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
An extent is a contiguous area of storage reserved for a file in a file system, represented as a range. A file can consist of zero or more extents; one file fragment requires one extent.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an Oracle Instance?
how to find the n'th highest salary from emp ?
How to assign query results to variables?
What are the different type of Segments ?
What are the execution control statements?
What are the attributes that are found in a cursor?
What is the use of Control File ?
what is shell?
what is the syntax of CREATE command?
What is the use of aggregate functions in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15