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 4854

View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements:
Statement 1
SQL>SELECT promo_categoiy.SUM(promo_cost) FROM promotions
WHERE promo_end_date-promo_begin_date > 30
GROUP BY promo_category: Statement 2
SQL>SELECT promo_categoiy.siun(promo_cost) FROM promotions
 
GROUP BY promo_categpry
HA\TNGMTN(promo_end_date-promo_begin_date)>30:
Which statement is true regarding the above two SQL statements?

Option A

A.    statement 1 gives an error, statement 2 executes successfully
 

Option B

B.    statement 2 gives an error, statement 1 executes successfully
 

Option C

C.    statement 1 and statement 2 execute successfully and give the same output
 

Option D

D.    statement 1 and statement 2 execute successfully and give a different output

Correct Answer D
Explanation


Question ID 4855

Examine the structure and data of the CUSTJTRANS table: CUSTJRANS
Name Null? Type
CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO TRANSDATE TRANSAMT
11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000 Dates are stored in the default date format dd-mon-rr in the CUSTJTRANS table. Which three
 
SQL statements would execute successfully? (Choose three.)
 

Option A

A.    SELECT transdate + '10' FROM custjrans;
 

Option B

B.    SELECT * FROM custjrans WHERE transdate = '01-01-07':
 

Option C

C.    SELECT transamt FROM custjrans WHERE custno > '11':
 

Option D

D.    SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':
 

Option E

E.    SELECT custno - 'A' FROM custjrans WHERE transamt > 2000:
 

Correct Answer A,C,D
Explanation

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