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 4729

See the Exhibit and examine the structure of the CUSTOMERS table:
Exhibit:
 
Using the CUSTOMERS table, you need to generate a report that shown the average credit limit for customers in WASHINGTON and NEW YORK.
Which SQL statement would produce the required result?

Option A

A.    SELECT cust_city,AVG(NVL(cust_credit_limit,0)) FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK')
 

Option B

B.    SELECT cust_city,AVG(cust_credit_limit)
FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city,cust_credit_limit;
 

Option C

C.    SELECT cust_city,AVG(cust_credit_limit)
FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_city;
 

Option D

D. SELECT cust_city,AVG(cust_credit_limit)
FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK') GROUP BY cust_credit_limit,cust_city;
 

Correct Answer C
Explanation


Question ID 4730

You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:
 
Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERs table?

Option A

A.    SELECT cust_city,cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust_city,cust_income_level;
 

Option B

B.    SELECT cust_city,cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust credit_limit, cust_income_level, cust_city;
 

Option C

C.    SELECT cust_city,cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust_city,cust_income_level,cust_credit_limit;
 
 

Option D

D. SELECT cust_city,cust_income_level,MAX(cust_credit_limit) FROM customers
GROUP BY cust_city, cust_income_level,MAX(cust_credit_limit);
 

Correct Answer A
Explanation

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