READ Free Dumps For Oracle- 1z0-023
Question ID 8787 | In Oracle8i, what does the FAST_START_IO_TARGET parameter do?
|
Option A | It allows faster access to database files.
|
Option B | It sets targets for maximum IO on any database file.
|
Option C | It allows the database to distribute IO over many disks.
|
Option D | It improves the performance of crash and instance recovery.
|
Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. To improve the performance of crash and instance recovery you need to set FAST_START_IO_TARGET parameter in initSID.ora file. This parameter defines how often a log switch will occur to minimize instance recovery after crash. Incorrect Answers: A: This parameter does not allow to access database files faster. B: It does not define targets for IO on any database file. D: It does not allow the database to distribute IO over many disks. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 332-333 Chapter 7: Managing the Physical Database Structure
Question ID 8788 | Which view shows all of the objects accessible to the user in a database?
|
Option A | DB_OBJECTS
|
Option B | ALL_OBJECTS
|
Option C | DBA_OBJECTS
|
Option D | USER_OBJECTS
|
Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. ALL_OBJECTS view shows all of the objects accessible to the user in a database. Incorrect Answers: A: These is no DB_OBJECTS view in Oracle. C: DBA_OBJECTS view shows all objects for all schemas, not for particular user. D: USER_OBJECTS shows all objects in user schema, not all objects user can access. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 314-315 Chapter 7: Managing the Physical Database Structure