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 1762

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.
Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?

Option A

Option B

'Martin'));

Option C

C.    SELECT ord _id, cust_id, ord_total FROM orders
WHERE cust_ id IN (SELECT cust_id FROM customers
WHERE cust_name = 'Martin');
 

Option D

D.    SELECT ord_id, cust_id, ord_total FROM orders
WHERE ord_date IN (SELECT ord_date FROM orders, customers
WHERE cust_name = 'Martin');
 

Correct Answer B
Explanation


Question ID 1763

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL
EMP_NAME VARCHAR2(30)
JOB_ID VARCHAR2(20) DEFAULT 'SA_REP'
SAL NUMBER
COMM_PCT NUMBER
MGR_ID NUMBER
DEPARTMENT_ID NUMBER
You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:
JOB_ID: Default value specified for this column definition.
SAL: Maximum salary earned for the job ID SA_REP.
COMM_PCT: Default value specified for this commission percentage
column, if any.
If no default value is specified for the column,
the value should be NULL.
DEPARTMENT_ID: Supplied by the user during run time through
substitution variable.
Which UPDATE statement meets the requirements?
 

Option A

UPDATE employeesC.UPDATE employees
SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees
WHERE job_id = 'SA_REP'),
comm_pct = DEFAULT,
department_id = &did
WHERE employee_id IN (103,115);
 

Option B

B.    UPDATE employees
SET job_id = DEFAULT,
Sal = (SELECT MAX(sal)
FROM employees
WHERE job_id = 'SA_REP'),
comm_pct = DEFAULT OR NULL,
department_id = &did
WHERE employee_id IN (103,115);
 

Option C

C.    UPDATE employees
SET job_id = DEFAULT
AND Sal = MAX(sal)
AND comm_pct = DEFAULT OR NULL
AND department_id = &did
WHERE employee_id IN (103,115)
AND job_id = 'SA_REP';
 

Option D

D.    UPDATE employeesD.UPDATE employees
SET job_id = DEFAULT,
Sal = MAX(sal),
comm_pct = DEFAULT,
department_id = &did
WHERE employee_id IN (103,115)
AND job_id = 'SA_REP';
 

Correct Answer A
Explanation

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