READ Free Dumps For Oracle- 1z0-001
| Question ID 8085 | You have a view called ANN_SAL that is based on the employee table. The structure of the ANN_SAL view is: NAME NULL TYPE EMPNO NOT NULL NUMBER(4) YEARLY_SAL NUMBER(9,2) MONTHLY_SAL NUMBER(9,2) Which statement retrieves the data from the ANN_SAL view?
|
| Option A | SELECT * FROM ANN_SAL
|
| Option B | SELECT * FROM EMPLOYEE
|
| Option C | SELECT * FROM VIEW ANN_SAL
|
| Option D | SELECT * FROM VIEW ANN_SAL IS DON EMPLOYEE
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct because correct syntax for SELECT command for view is SELECT * FROM
Incorrect Answers: B: This statement will show data from table EMPLOYEE, not view ANN_SAL. C: It's an incorrect statement because of usage word 'VIEW'. D: It's an incorrect statement because of usage words 'VIEW' and 'IS DON EMPLOYEE'. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 160-169 Chapter 4: Creating Other Database Objects in Oracle
| Question ID 8086 | Evaluate this IF statement. IF v_value>100 THEN v_new-value:=2*v-value; ELSIF v-value>200 THEN v-new-value:=3*v-value; ELSIF v-value>300 THEN v-new-value:=4*v-value; ELSE v-new-value:=5*v-value; END IF What would be assigned to v_new_value if v_value=250?
|
| Option A | 250
|
| Option B | 500
|
| Option C | 750
|
| Option D | 1000
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because first IF condition v_value > 100 will be TRUE if v_value have been assigned with new value equal 250. Result of 2*v_value is 500. Incorrect Answers: A: All IF conditions multiple 250 on 2, 3, 4 or 5, so result cannot be 250. C: First IF condition will work not second one, so result will be 500, not 750. D: First IF condition will work not second or third one, so result will be 500, not 750 or 1000. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 215-217 Chapter 5: Introducing PL/SQL