READ Free Dumps For Oracle- 1z0-062
| Question ID 2352 | Which two statements are true about extents? |
| Option A | A. Blocks belonging to an extent can be spread across multiple data files. |
| Option B | B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk. |
| Option C | C. The blocks of a newly allocated extent, although free, may have been used before. |
| Option D | D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespaee when all the rows in a table are deleted. |
| Correct Answer | B,C |
| Question ID 2353 | You execute the commands: |
| Option A | A. The create user command fails if any role with the name Sidney exists in the database. |
| Option B | B. The user sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace. |
| Option C | C. The user sidney is created but cannot connect to the database instance because no profile is |
| Option D | D. The user sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace. |
| Option E | E. The user sidney is created and authenticated by the operating system. |
| Correct Answer | C,E |