AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 1672

Which two are true about aggregate functions? (Choose two.)

Option A

A.    You can use aggregate functions in any clause of a SELECT statement.

 

Option B

B.    You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
 

Option C

C.    You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
 

Option D

D.    You can use aggregate functions on a table, only by grouping the whole table as one single group.
 

Option E

E.    You can pass column names, expressions, constants, or functions as parameters to an aggregate function.

Correct Answer B
Explanation


Question ID 1675

Click the Exhibit button and examine the data from the EMP table.
The COMMISSION column shows the monthly commission earned by the employee.
Which three tasks would require subqueries or joins in order to be performed in a single step?

(Choose three.)

Option A

A.    finding the number of employees who do NOT earn commission and are working for department 20
 

Option B

B.    increasing the commission of employee 3 by the average commission earned in department 20
 

Option C

C.    decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800
 

Option D

D.    inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3
 

Option E

E.    creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table
 
 

Option F

F. deleting the records of employees who do not earn commission 

Correct Answer B,D,E
Explanation

Send email to admin@getfreedumps for new dumps request!!!