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 7965

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER (4) NOT NULL CUSTOMER_NAME VARCHAR2 (100) NOT NULL STREET_ADDRESS VARCHAR2 (150) CITY_ADDRESS VARHCAR2 (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

COUNT(UPPER(country_address))

Option B

COUNT(DIFF(UPPER(country_address)))

Option C

COUNT(UNIQUE(UPPER(country_address)))

Option D

COUNT DISTINTC UPPER(country_address)

Option E

COUNT(DISTINTC (UPPER(country_address)))

Correct Answer E
Explanation


Question ID 7966

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?

Option A

DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);

Option B

DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);

Option C

DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'

Option D

DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'

Correct Answer C
Explanation Explanation/Reference: Explanation : The correct syntax for DELETE statement DELETE [ FROM ] table [WHERE condition]; Incorrect Answers : A. '=' is use in the statement and subquery will return more than one row. Error Ora-01427 : single-row subquery returns more than one row. B. Incorrect DELETE statement D. Incorrect DELETE statement Refer : Introduction to Oracle9i : SQL, Oracle University Student Guide, Manipulating Data, p. 8-19

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