READ Free Dumps For Oracle- 1z0-007
| Question ID 7927 | Which operator can be used with a multiple-row subquery?
|
| Option A | =
|
| Option B | LIKE
|
| Option C | BETWEEN
|
| Option D | NOT IN
|
| Option E | IS
|
| Option F | <>
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Only NOT IN operator can be used with a multi-row sub-query. All others may be used with single-row subquery only. Incorrect Answers A: When sub-queries are linked to the parent by equality comparisons, the parent query expects only one row of data from the sub-query, so "=" operator cannot be used with a multiple-row sub-query. B: Operator LIKE will work only with single-row sub-queries. C: Operator BETWEEN will not work with a multi-row sub-queries. E: Operator LIKE is used only for single-row sub-queries. F: When sub-queries are linked to the parent by equality comparisons, the parent query expects only one row of data from the sub-query, so "<>" operator cannot be used with a multiple-row sub-query. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 150-165 Chapter 4: Subqueries
| Question ID 7928 | Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?
|
| Option A | To find the tax percentage for each of the employees.
|
| Option B | To list the name, job id, and manager name for all the employees.
|
| Option C | To find the name, salary, and department name of employees who are not working with Smith.
|
| Option D | To find the number of employees working for the Administrative department and earning less then 4000.
|
| Option E | To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: You will use a nonequijoin query to find the tax percentage for each of the employees because you will check range of salaries without usage of equality operations in a comparison joining data from two tables. Incorrect Answers B: You will use equijoin query because EMPLOYEES and DEPARTMENTS tables will be joined with equality operator. C: It will be equijoin query because EMPLOYEES and DEPARTMENTS tables will be joined with equality operator. D: You will use equijoin query because EMPLOYEES and DEPARTMENTS tables will be joined with equality operator. E: It will be equijoin query because of equality operator in join condition of two tables. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 99-107 Chapter 3: Advanced Data Selection in Oracle