READ Free Dumps For Oracle- 1z0-007
| Question ID 7935 | You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed?
|
| Option A | The main query executes with the first value returned by the subquery.
|
| Option B | The main query executes with the last value returned by the subquery.
|
| Option C | The main query executes with all the values returned by the subquery
|
| Option D | The main query fails because the multiple-row subquery cannot be used with the comparison operator.
|
| Option E | You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: The main query fails because the multiple-row sub-query cannot be used with the comparison operator. Only single-row query can use comparison operators, like =, <, >, <=, >, and <>. Incorrect Answers A: The main query fails because the multiple-row sub-query cannot be used with the comparison operator. B: The main query fails because the multiple-row sub-query cannot be used with the comparison operator. C: The main query fails because the multiple-row sub-query cannot be used with the comparison operator. E: You can define a multiple-row sub-query in the WHERE clause of a SQL query, but error will be generated by different reason. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 150-165 Chapter 4: Subqueries
| Question ID 7936 | You need to calculate the total of all salaries in the accounting department. Which group function should you use?
|
| Option A | MAX
|
| Option B | MIN
|
| Option C | SUM
|
| Option D | COUNT
|
| Option E | TOTAL
|
| Option F | LARGEST
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Function SUM(x) calculates the sum of all values in column x in all rows returned by the SELECT statement. Incorrect Answers A: Function MAX(x) determines the maximum value in column x for all rows returned by the SELECT statement. B: Function MIN(x) determines the minimum value in column x for all rows returned by the SELECT statement. D: Function COUNT(x) counts the number of non-NULL values returned by the SELECT statement for column x. E: There is no TOTAL() function in Oracle. F: There is no LARGEST() function in Oracle. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 122-126 Chapter 3: Advanced Data Selection in Oracle