READ Free Dumps For Oracle- 1z0-007

Question ID 7911	Which two statements are true regarding the ORDER BY clause? (Choose two)
Option A	The sort is in ascending by order by default.
Option B	The sort is in descending order by default.
Option C	The ORDER BY clause must precede the WHERE clause.
Option D	The ORDER BY clause is executed on the client side
Option E	The ORDER BY clause comes last in the SELECT statement.
Option F	The ORDER BY clause is executed first in the query execution.
Correct Answer	AE

Explanation Explanation/Reference: Explanation: The ORDER BY clause does sort data in ascending order by default. And the ORDER BY clause comes last in the SELECT statement: after FROM or WHERE or GROUP BY clause. Incorrect Answers B: The ORDER BY clause does sort data in ascending, not descending order, by default. C: The ORDER BY clause must be after the WHERE clause in the SQL statement. D: The ORDER BY clause is executed on the server side as the whole SQL statement is. F: The ORDER BY clause is executed last in the query execution, after results are limited with the WHERE and GROUP BY clause conditions. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 56-61 Chapter 2: Limiting, Sorting, and Manipulating Return Data

Question ID 7912	Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?
Option A	SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary
Option B	SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
Option C	SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary
Option D	You cannot find the information because there is no common column between the two tables.
Correct Answer	A

Explanation Explanation/Reference: Explanation: You can find the percentage tax applicable for each employee by using SQL statement in answer A. Incorrect Answers B: Syntax "WHERE e.salary > t.min_salary, tax_percent" is incorrect. C: Functions, like MIN() and MAX(), cannot be used in the WHERE clause. D: The SQL statement from the answer A will provide requested information. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 98-103 Chapter 3: Advanced Data Selection in Oracle

Previous-Page 1 2. . . 83 84 85 86 87 88 89. . . 160 161 Next-Page

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