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- 1z0-007





Question ID 1754

Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:
SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary,
m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m
ON (e.mgr_id = m.employee_id)
AND e.salary > 4000;
What is its output?

Option A

A.    EMP_id EMPLOYEE SALARY Mgr_id Manager
110 Bob 8000 Bob
120 Ravi 6500 110 Ravi
108 Jennifer 6500 110 Jennifer
103 Chris 4200 120 Chris
105 Diana 5000 108 Diana
 

Option B

B.    EMP_id EMPLOYEE SALARY Mgr_id Manager
120 Ravi 6500 110 Bob 108 Jennifer 6500 110 Bob 103 Chris 4200 120 Ravi 105 Diana 5000 108 Jennifer
 

 

Option C

C.    EMP_id EMPLOYEE SALARY Mgr_id Manager
110 Bob 8000
120 Ravi 6500 110 Bob 108 Jennifer 6500 110 Bob 103 Chris 4200 120 Ravi 105 Diana 5000 108 Jennifer
 

Option D

D.    EMP_id EMPLOYEE SALARY Mgr_id Manager
110 Bob 8000 110 Bob
120 Ravi 6500 120 Ravi
108 Jennifer 6500 108 Jennifer
103 Chris 4200 103 Chris
105 ana 5000 105 Dina

Correct Answer B
Explanation


Question ID 1757

The CUSTOMERS table has these columns:
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.
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(UNIQUE(UPPER(country_address)))
 

Option B

B.    COUNT(DISTINCT (UPPER(country_address)))
 

Option C

C.    COUNT DISTINCT UPPER(country_address)

 

Option D

D.    COUNT(UPPER(country_address))

Correct Answer B
Explanation

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