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 4771

Which two statements are true regarding views? (Choose two.)
 

Option A

A.    A sub query that defines a view cannot include the GROUP BY clause
 

Option B

B.    A view is created with the sub query having the DISTINCT keyword can be updated
 

Option C

C.    A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table
 

Option D

D.    A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated
 

Correct Answer C,D
Explanation


Question ID 4772

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
 
You need to generate a report that displays the IDs or all products in the COSTS table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.
You issue the following query: Exhibit:
 
Which statement is true regarding the above query?

Option A

A.    It produces an error because the DESC option cannot be used with an expression in the ORDER BY clause
 

Option B

B.    It executes and produces the required result
 

Option C

C.    It produces an error because the expression in the ORDER BY clause should also be specified in the SELECT clause
 

Option D

D.    It produces an error because an expression cannot be used in the ORDER BY clause
 

Correct Answer B
Explanation

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