Unformatted text preview: ower of Knowing 1Z0-023
C: If you will determine extent equal to the size of the biggest possible row, you will just waste
space, because other rows will use not all space in each extent.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 348-350
Chapter 7: Managing the Physical Database Structure
You have used the ANALYZE TABLE. . . .COMPUTE STATISTICS. Where do you find
the number of rows in the table?
A. In the alert file
B. In DBA_TABLES
C. In DBA_ROWSTATS
D. In the trace file produced by the ANALYZE command.
Answer B is correct. You can find the number of rows statistics in the DBA_TABLES view.
A: The alert file will not display this information.
C: There is no DBA_ROWSTATS view in Oracle.
D: The ANALYZE command does not produce the trace file.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 400-401
Chapter 8: Managing Database Objects I
Which data dictionary view would you query to retrieve a table's header block number?
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide