READ Free Dumps For Oracle- 1z0-023
| Question ID 8847 | When creating a user, which profile is assigned automatically to the user if none is defined?
|
| Option A | None
|
| Option B | The SYSTEM profile
|
| Option C | The DEFAULT profile
|
| Option D | The RESOURCE_LIMIT profile
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. The DEFAULT profile will be assigned to user automatically to the user if none is defined. Incorrect Answers: A: At least one profile will be assigned to user when creating a user. B: There is no SYSTEM profile in Oracle D: There is no RESOURCE_LIMIT profile in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 492-493 Chapter 10: Managing Database Use
| Question ID 8848 | Which data dictionary view could you query to display the number of extents allocated to the employee table?
|
| Option A | DBA_EXTENTS
|
| Option B | DBA_FREE _SPACE
|
| Option C | USER_TABLES
|
| Option D | DBA_TABLES
|
| Option E | DBA_TABLESPACES
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct. DBA_EXTENTS view can be used to display the number of extents allocated to the EMPLOYEE table. DBA_EXTENTS view gives information about the number of extents allocated to a table, the datafiles in which they are stored, and how large each extent is. Incorrect Answers: B: DBA_FREE_SPACE data dictionary view identifies the location and the amount of free space, by tablespace name, file ID, starting block ID, bytes, and blocks. C: USER_TABLES view is used to show information about tables in user schema only. D: DBA_TABLES view is used to show information about all tables in the database, but it will not show the number of extents allocated to the EMPLOYEE table. E: DBA_TABLESPACERS view provides information about tablespaces, not extents or tables. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 352-353 Chapter 7: Managing the Physical Database Structure