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 4930

Examine the description of the CUSTOMERS table:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20)
The CUSTOMER_ID column is the primary key for the table.
Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?
 

Option A

A.    SELECT city_address, COUNT(*)
FROMcustomers
WHERE city_address IN ( ‘Los Angeles’, ‘San Fransisco’);
 

Option B

B.    SELECT city_address, COUNT (*)
FROMcustomers
WHERE city address IN ( ‘Los Angeles’, ‘San Fransisco’) GROUP BY city_address;
 

Option C

C.    SELECT city_address, COUNT(customer_id)
FROMcustomers
WHERE city_address IN ( ‘Los Angeles’, ‘San Fransisco’) GROUP BYcity_address, customer_id;
 

Option D

D.    SELECT city_address, COUNT (customer_id)
FROM customers
GROUP BY city_address IN ( ‘Los Angeles’, ‘San Fransisco’);
 

Correct Answer B
Explanation


Question ID 4931

What does the FORCE option for creating a view do?
 

Option A

A.    creates a view with constraints
 

Option B

B.    creates a view even if the underlying parent table has constraints
 

Option C

C.    creates a view in another schema even if you don't have privileges
 

Option D

D.    creates a view regardless of whether or not the base tables exist
 

Correct Answer D
Explanation

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