READ Free Dumps For Oracle- 1z0-020
| Question ID 7798 | What is one benefit of using the ALTER TABLE . . . . . . MOVE command rather than a CREATE TABLE . . . . . . AS SELECT command? |
| Option A | Row chaining is eliminated. |
| Option B | Index definitions are retained. |
| Option C | Duplicate space is not required while the command executes. |
| Option D | All operations, such as INSERT, UPDATE, DELETE, and SELECT can be performed while the operation completes. |
| Correct Answer | B |
| Question ID 7799 | Which two statements about optimizer plan stability is true? (Choose two) |
| Option A | Profiles specify the user's default category. |
| Option B | Data dictionary statistics are ignored when using a stored outline. |
| Option C | Data dictionary statistics are ignored when creating a stored outline. |
| Option D | Categories allow different stored outlines for the same SQL statement. |
| Correct Answer | BD |