READ Free Dumps For Oracle- 1z0-001
| Question ID 8156 | Examine the table instance chart for the patient table. Column Id_number Last_name first_name birth_date doctor_id name Key type PK NN, UU NN NN Nulls/Unique FK table DOCTOR FK column Data type NUM DATE NUMBER VARCHAR2 VARCHAR2 Length 10 25 25 10 You created the patient_vu view based on the id_number and last_name columns from the patient table. What is the best way to modify the view to contain only those patients born in 1997?
|
| Option A | Replace the view adding a WHERE clause.
|
| Option B | Use the ALTER command to add WHERE clause to verify the time.
|
| Option C | Drop the patient_vu then create a new view with a WHERE clause.
|
| Option D | Drop the patient_vu then create a new view with a HAVING clause.
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct because the statement with a WHERE clause will extract only data about patients born in 1997. Incorrect Answers: B: View cannot be modified with the ALTER command. C: View can be replaced with the WHERE clause, there is no reason to drop it. D: View can be replaced with the WHERE clause, there is no reason to drop it. A clause HAVING will not modify view correctly, it can be used only with a GROUP BY clause. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 20-21 Chapter 1: Selecting Data from Oracle
| Question ID 8157 | Evaluate this PL/SQL block: BEGIN FOR i IN 1. . 5 LOOP IF i=1 THEN NULL; ELSIF i=3 THEN COMMIT; ELSIF 1=5 THEN ROLLBACK; ELSE INSERT INTO test (results); VALUES(i); END IF; END LOOP; COMMIT; END; How many values will be permanently inserted into the TEST table?
|
| Option A | 0
|
| Option B | 1
|
| Option C | 2
|
| Option D | 3
|
| Option E | 5
|
| Option F | 6
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because only one value will be inserted into the TEST table. First iteration in loop will do nothing because of NULL operator. Second one will insert value into table. Third will commit change. Forth will insert second value, but fifth iteration will rollback last transaction. So it will be just one value inserted into the table. Incorrect Answers: A: One value will be inserted, not zero. C: One value will be inserted, not two. D: One value will be inserted, not three. E: One value will be inserted, not four. F: One value will be inserted, not five. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 219-220 Chapter 5: Introducing PL/SQL