Interested to Buy Any Domain ? << Click Here >> for more details...
What is Row Chaining ?
- 3 Answers
- 12892 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / orawhiz
In Circumstances, all of the data for a row in a table may
not be able to fit in the same data block. When this occurs
, the data for the row is stored in a chain of data block
(one or more) reserved for that segment.
| Is This Answer Correct ? | 35 Yes | 0 No |
Answer / pabitra kumar khatoi
In Row chaining basically it happens on the pctused case.
I.e for row insertion case. IF the insert(required) row
size is greater than the available row size then the value
will go to next row . Similarly again if the next row size
is greater than the available row size then the value will
go to next row in a CHAINED manner.That is called Row-
Chaining.
So there is a view called DBA_tables/USER_tables we can get
the column name avg-row_length and chain_cnt .
In the above cloumn we can get the no of row
chaining........
This is the concept of ROW chaining..
If this happen then we can reorg the object.
| Is This Answer Correct ? | 6 Yes | 1 No |
Will you be able to store pictures in the database?explain.
What is raw datatype in oracle?
What is a nested table?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
How do I limit the number of rows returned by an oracle query after ordering?
How to execute the package in oracle?
waht is referencial integrity?
How can we find out the duplicate values in an oracle table?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is Trace File ?
What is difference between Rename and Alias?
Oracle General 
