READ Free Dumps For Oracle- 1z0-001
| Question ID 8140 | For which three tasks would you use the where clause? (Choose three)
|
| Option A | Compare two values.
|
| Option B | Display only unique data.
|
| Option C | Designate a table location.
|
| Option D | Restrict the rows displayed.
|
| Option E | Restrict the output of the group function.
|
| Option F | Only display data greater than a specified value.
|
| Correct Answer | ADF |
Explanation Explanation/Reference: Explanation: Answer A, D, F is correct because the WHERE clause used to compare two values, restrict the rows displayed and data grater than a specified value. Incorrect Answers: B: Unique data will be displayed with the DISTINCT clause usage. C: The WHERE clause is used to designate a table location. E: To restrict the output of the group function the HAVING clause is used. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 20-21 Chapter 1: Selecting Data from Oracle
| Question ID 8141 | Which SELECT statement would you use in a PL/SQL block to query the employee table and retrieve the last name and salary of the employee whose ID is 3?
|
| Option A | SELECT last_name,salary FROM employee;
|
| Option B | SELECT last_name,salary FROM employee; WHERE id=3;
|
| Option C | SELECT last_name,salary INTO v_last_name,v_salary FROM employee WHERE id=3;
|
| Option D | SELECT l last_name,salary FROM employee; INTO v_last_name,v_salary WHERE id=3;
|
| Option E | SELECT last_name,salary INTO v_last_name,v_salary WHERE id=3;
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because this SELECT statement will populate variables v_last_name and v_salary from the table EMPLOYEE where employee's ID is 3. Incorrect Answers: A: This statement will show ALL employees from EMPLOYEE table and no variables will be populated with values from the table. B: This statement will extract correct data from the table, but not populate variables with these values in PL/ SQL block. D: Statement is wrong because the INTO clause must be used before the FROM clause in the statement. E: Statement is wrong because the INTO clause must be followed by the FROM clause, not WHERE. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 20-21 Chapter 1: Selecting Data from Oracle