READ Free Dumps For Oracle- 1z0-061
| Question ID 21042 | Examine the structure of the employees table.
You want to display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would get the correct output?
|
| Option A | Option A
|
| Option B | Option B
|
| Option C | Option C
|
| Option D | Option D
|
| Correct Answer | B,D |
Explanation Explanation: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.s qlref%2Fsrc%2Ftpc%2Fdb2z_sql_subselectexamples.htmL
| Question ID 21043 | Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated
credit amounts in each income level.
Which query would give the required result?
|
| Option A | Option A
|
| Option B | Option B
|
| Option C | Option C
|
| Option D | Option D
|
| Correct Answer | C |
Explanation Explanation: Duplicate Rows Unless you indicate otherwise, SQL displays the results of a query without eliminating the duplicate rows. To eliminate duplicate rows in the result, include the DISTINCT keyword in the SELECT clause immediately after the SELECT keyword. You can specify multiple columns after the DISTINCT qualifier. The DISTINCT qualifier affects all the selected columns, and the result is every distinct combination of the columns.