DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

What is ROWID?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

104. What is ROWID?

Answer1
For each row in the database, the ROWID pseudocolumn returns a row’s address. ROWID values contain information necessary to locate a row:
* which data block in the data file
* which row in the data block (first row is 0)
* which data file (first file is 1)

Answer2
.row id: A rowid is a pseudo-column that uniquely identifies a row in a table, but not within a data base.

(Continued on next question...)

Other Job Interview Questions