Actualtestscom the power of knowing 1z0 023 c if you

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 QUESTION 47: 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 Explanation: Answer B is correct. You can find the number of rows statistics in the DBA_TABLES view. Incorrect Answers: 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 QUESTION 48: Which data dictionary view would you query to retrieve a table's header block number? A. DBA_TABLE B. DBA_TABL...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online