Interested to Buy Any Domain ? << Click Here >> for more details...
What is ROWID explain ?
- 2 Answers
- 4937 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishor potu
ROWID is the pesudo column the oracle it can create in built. it is the hexa decimal data type(it contain alpha numaric number). it contain length is 18 digits. there ROWID in a table must be unique. if you drop the row the ROWID will remove. if any new record enter into the table ROWID assigns a unique number that record.
if you want to see the rowid
select rowid from table_name;
| Is This Answer Correct ? | 2 Yes | 0 No |
ROWID is the physical location of a row. Consequently it is the fastest way of locating a row
| Is This Answer Correct ? | 2 Yes | 1 No |
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how do u implement scheduling in Informatica?
What are the steps involved in etl process?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
where is the cache (lookup, index) created and how can you see it.
What do you understand by active and passive transformations?
What is partitioning? Explain different types of partitioning?
What are the names of the layers in etl?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is a materialized view log?
what happens if the info.server doesn't find the session parameter in the parameter file?
what is the difference between cardinality and Nullability?
Teradata 
