READ Free Dumps For Oracle- 1z0-023
| Question ID 8793 | You have used the ANALYZE TABLE. . . .COMPUTE STATISTICS. Where do you find the number of rows in the table?
|
| Option A | In the alert file
|
| Option B | In DBA_TABLES
|
| Option C | In DBA_ROWSTATS
|
| Option D | In the trace file produced by the ANALYZE command.
|
| Correct Answer | B |
Explanation Explanation/Reference: 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 ID 8794 | Which data dictionary view would you query to retrieve a table's header block number?
|
| Option A | DBA_TABLE
|
| Option B | DBA_TABLES
|
| Option C | DBA_OBJECT
|
| Option D | DBA_OBJECTS
|
| Option E | DBA_SEGMENT
|
| Option F | DBA_SEGMENTS
|
| Correct Answer | F |
Explanation Explanation/Reference: Explanation: Answer F is correct. DBA_SEGMENTS view gives information about the name, tablespace location, the table's header block number and owner of segments containing table data in Oracle. Incorrect Answers: A: DBA_TABLE view does not exist in Oracle. B: DBA_TABLES view gives information about all storage settings for the table, as well as the statistics collected as part of the ANALYZE operation on that table. C: There is no DBA_OBJECT in Oracle. D: DBA_OBJECTS view gives information about the object ID number used in part to determine ROWID for rows in the table, as well as the table creation timestamp for determining dependencies. E: DBA_SEGMENT view does not exist in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 400-401 Chapter 8: Managing Database Objects I