READ Free Dumps For Oracle- 1z1-051
| Question ID 4757 | Which two statements are true regarding the COUNT function?(Choose two.) |
| Option A | A. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns |
| Option B | B. COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column |
| Option C | C. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV AMT column |
| Option D | D. A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause |
| Option E | E. The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types |
| Correct Answer | A,C |
| Question ID 4758 | Examine the description of the EMP_DETAILS table given below: |
| Option A | A. An EMP_IMAGE column can be included in the GROUP BY clause |
| Option B | B. You cannot add a new column to the table with LONG as the data type |
| Option C | C. An EMP_IMAGE column cannot be included in the ORDER BY clause |
| Option D | D. You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column |
| Correct Answer | B,C |
