READ Free Dumps For Oracle- 1z0-050
| Question ID 1813 | Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? |
| Option A | A. SQL statements that are part of the AWR baseline only |
| Option B | B. SQL statements based on the AWR top SQL identification |
| Option C | C. SQL statements that are part of the available SQL Tuning Set (STS) only |
| Option D | D. SQL statements that are available in the cursor cache and executed by a user other than SYS |
| Correct Answer | B |
| Question ID 1814 | View the Exhibit and examine the output.
What is the outcome of this command? |
| Option A | A. The table uses the default Flashback Archive. |
| Option B | B. The Flashback Archive is created on the SYSAUXtablespace. |
| Option C | C. The Flashback Archive is created on the same tablespace where the tables are stored. |
| Option D | D. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive- |
| Correct Answer | D |
