Explain the difference between a data block, an extent and
a segment.
- 1 Answers
- 8827 Views
- Accenture, IBM, I also Faced
- E-Mail Answers
Answer / kumar.s
Datablock, Extent and Segment
A segment is defined as any entity that consumes physical
storage space within the database.
Each Oracle segment is made up of contiguous chunks of
storage space in the database called extents. Every segment
must have at least one extent, but can have as many as 2
billion extents.
Each extent is itself made up of a collection of smaller
chunks of space called Oracle database blocks. The minimum
size of an extent is five database blocks.
The default size of these database blocks is set at
database creation, but Oracle 10g db can use multiple block
sizes within one db. The common database block sizes are
2KB, 4KB, 8KB, and 16KB.
| Is This Answer Correct ? | 10 Yes | 2 No |
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
Explain the use of table functions.
Name two files used for network connection to a database.
Is it possible to drop a column in a table which contains only one column? How?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is the sql query to find the employee who has Nth maximum salary?
What is the Symbol use for Inner Join
What is the difference between recovery and restoring of the oracle database?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
what is correlated subquery
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
Oracle General 
