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 4858

View the Exhibit and examine the data in the PRODUCTS table. You need to display product names from the PRODUCTS table that belong to the 'Software/Other1 category with minimum prices as either $2000 or $4000 and no unit of measure. You issue thej
following query:
SQL>SELECT prod_name. prod_category. prod_min_price
FROM products
WHERE prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR
prod_min_price = 4000) AND prod_unit_of_measure o";
Which statement is true regarding the above query?
 

Option A

A.    It executes successfully but returns no result.
 

Option B

B.    It executes successfully and returns the required result.
 

Option C

C.    It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
 

Option D

D.    It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
 

Correct Answer A
Explanation


Question ID 4859

You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr.Which two SQL statements would give the required output? (Choose two.)
 

Option A

A.    SELECT SYSDATE - '01-JAN-2007' FROM DUAL:
 

Option B

B.    SELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL:
 

Option C

C.    SELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL:
 

Option D

D.    SELECT TO_CHAR(SYSDATE. 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL:
 

Option E

E.    SELECT TO_DATE(SYSDATE. *DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL:
 

Correct Answer B,C
Explanation

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