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 4894

Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual;
Which values are displayed?
 

Option A

A.    46 and 45
 

Option B

B.    46 and 45.93
 

Option C

C.    50 and 45.93
 

Option D

D.    50 and 45.9
 

Option E

E.    45 and 45.93
 

Option F

F.    45.95 and 45.93
 

Correct Answer C
Explanation


Question ID 4895

The CUSTOMERS table has these columns:
CUSTOMER_IDNUMBER (4)NOT NULL
CUSTOMER_NAMEVARCHAR2 (100)NOT NULL
STREET_ADDRESSVARCHAR2 (150) CITY_ADDRESSVARHCAR2 (50) STATE_ADDRESSVARCHAR2 (50) PROVINCE_ADDRESSVARCHAR2 (50) COUNTRY_ADDRESSVARCHAR2 (50) POSTAL_CODEVARCHAR2 (12) CUSTOMER_PHONEVARCHAR2 (20)
The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?
 

Option A

A.    COUNT(UPPER(country_address))
 

Option B

B.    COUNT(DIFF(UPPER(country_address)))
 

Option C

C.    COUNT(UNIQUE(UPPER(country_address)))
 

Option D

D.    COUNT DISTINCT UPPER(country_address)
 

Option E

E.    COUNT(DISTINCT (UPPER(country_address)))
 

Correct Answer E
Explanation

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