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- 1z1-051





Question ID 4785

See the Exhibit and examine the structure of the SALES table:
Exhibit:
 
 
The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times:
Exhibit:
SQL> SELECT prod_id
FROM sales
WHERE quantity_sold > 55000 AND COUNT(*)>10
GROUP BY prod_id HAVING COUNT(*)>10;
Which statement is true regarding this SQL statement?

Option A

A.    It produces an error because COUNT (*) should be specified the SELECT clause also
 

Option B

B.    It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*)
 

Option C

C.    It executes successfully and generates the required result
 

Option D

D.    It produces an error because COUNT (*) should be only the HAVING clause and not in the WHERE clause
 

Correct Answer D
Explanation


Question ID 4786

When does a transaction complete? (Choose all that apply.)
 
 

Option A

A.    When a PL/SQL anonymous block is executed
 

Option B

B.    When a DELETE statement is executed
 

Option C

C.    When a data definition language statement is executed
 

Option D

D.    When a TRUNCATE statement is executed after the pending transaction
 

Option E

E.    When a ROLLBACK command is executed
 

Correct Answer C,D,E
Explanation

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