READ Free Dumps For Oracle- 1z0-050
| Question ID 4794 | Which statement is true regarding the default behavior of the ORDER BY clause? |
| Option A | A. NULL values are not considered at all by the sort operation |
| Option B | B. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause |
| Option C | C. Numeric values are displayed from the maximum to the minimum value if they have decimal positions |
| Option D | D. In a character sort, the values are case-sensitive |
| Correct Answer | D |
| Question ID 5922 | Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two)
|
| Option A | Cursor cache |
| Option B | Stored outline |
| Option C | SQL Tuning Set |
| Option D | Automatic Workload Repository (AWR) snapshots |
| Correct Answer | A,C |