READ Free Dumps For Oracle- 1z0-061
| Question ID 21028 | View the Exhibit and examine the data in the costs table.
You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% more than the unit cost. The details should be
Which statement is true regarding the above query? |
| Option A | It executes and produces the required result. |
| Option B | It produces an error because an expression cannot be used in the order by clause. |
| Option C | It produces an error because the DESC option cannot be used with an expression in the order by clause. |
| Option D | It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause. |
| Correct Answer | A |
| Question ID 21029 | View the Exhibit and examine the structure of the products table.
Evaluate the following query:
What would be the outcome of executing the above SQL statement? |
| Option A | It produces an error. |
| Option B | It shows the names of all products in the table. |
| Option C | It shows the names of products whose list price is the second highest in the table. |
| Option D | It shows the names of all products whose list price is less than the maximum list price. |
| Correct Answer | C |
