READ Free Dumps For Oracle- 1z0-020
| Question ID 8231 | What is one of the benefits of system-managed locally managed tablespace, defined with the AUTOALLOCATE option? |
| Option A | All extents will be uniformly sized. |
| Option B | Rollback segments created in them automatically resize themselves. |
| Option C | You do not have to worry about the amount of free space available. |
| Option D | Neither the DBA nor the users have to concern themselves with storage parameters to size the extents. |
| Correct Answer | D |
| Question ID 8232 | You decide to move a table from one tablespace to another with this command: ALTER TABLE orders MOVE TABLESPACE data1 Which type(s) of statements could be executed on the table while the table is being moved? |
| Option A | None |
| Option B | Queries only |
| Option C | Queries, inserts, and updates |
| Option D | Inserts, updates, and deletes |
| Option E | Queries, DML, DDL statements |
| Option F | Queries, inserts, updates, and deletes |
| Correct Answer | B |