READ Free Dumps For Oracle- 1z0-117
| Question ID 2540 | Which three are tasks performed in the hard parse stage of a SQL statement executions? |
| Option A | A. Semantics of the SQL statement are checked. |
| Option B | B. The library cache is checked to find whether an existing statement has the same hash value. |
| Option C | C. The syntax of the SQL statement is checked. |
| Option D | D. Information about location, size, and data type is defined, which is required to store fetched values in variables. |
| Option E | E. Locks are acquired on the required objects. |
| Correct Answer | B,D,E |
| Question ID 2541 | Which two are the fastest methods for fetching a single row from a table based on an equality predicate? |
| Option A | A. Fast full index scan on an index created for a column with unique key |
| Option B | B. Index unique scan on an created for a column with unique key |
| Option C | C. Row fetch from a single table hash cluster |
| Option D | D. Index range scan on an index created from a column with primary key |
| Option E | E. Row fetch from a table using rowid |
| Correct Answer | C,E |