READ Free Dumps For Oracle- 1z0-061
| Question ID 2331 | Which two statements are true regarding the count function? |
| Option A | A. The count function can be used only for CHAR, VARCHAR2, and NUMBER data types. |
| Option B | B. Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns. |
| Option C | C. Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column. |
| Option D | D. Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV AMT column. |
| Option E | E. A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause. |
| Correct Answer | B,D |
| Question ID 20997 | Evaluate the following SQL statement:
Which statement is true regarding the outcome of the above query? |
| Option A | It executes successfully and displays rows in the descending order of PROMO_CATEGORY. |
| Option B | It produces an error because positional notation cannot be used in the order by clause with set operators. |
| Option C | It executes successfully but ignores the order by clause because it is not located at the end of the compound statement. |
| Option D | It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement. |
| Correct Answer | D |
