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 1764

Evaluate these two SQL statements:
SELECT last_name, salary , hire_date FROM EMPLOYEES
ORDER BY salary DESC;
SELECT last_name, salary , hire_date
FROM EMPLOYEES ORDER BY 2 DESC;
What is true about them?
 

Option A

A.    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

 

Option B

B.    The two statements produce identical results.
 

Option C

C.    There is no need to specify DESC because the results are sorted in descending order by default.
 

Option D

D.    The second statement returns a syntax error.

Correct Answer B
Explanation


Question ID 1765

Examine the structure of the EMPLOYEES table:
Column name Data type Remarks
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID VARCHAR2(20) NOT NULL
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column
of the DEPARTMENTS table
You need to create a view called EMP_VU that allows the users to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the users to insert rows?
 

Option A

A.    CREATE VIEW emp_vu AS SELECT employee_id, emp_name, department_id
FROM employees
WHERE mgr_id IN (102, 120);
 

Option B

B.    CREATE VIEW emp_vu AS
SELECT employee_id, emp_name, job_id,
department_id
FROM employees
WHERE mgr_id IN (102, 120);
 

Option C

C.    CREATE VIEW emp_vu AS
SELECT employee_id, emp_name, job_id, DISTINCT department_id
FROM employees;
 

Option D

D.    CREATE VIEW emp_vu AS
SELECT department_id, SUM(sal) TOTALSAL
FROM employees
WHERE mgr_id IN (102, 120)
GROUP BY department_id;
 

Correct Answer B
Explanation

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