READ Free Dumps For Oracle- 1z0-007
| Question ID 1662 | Which two statements about sequences are true? (Choose two.) |
| Option A | A. You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column. |
| Option B | B. You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence. |
| Option C | C. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence. |
| Option D | D. You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value. |
| Option E | E. You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence. |
| Option F | F. If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence. |
| Correct Answer | B,C |
| Question ID 1663 | In which two cases would you use an outer join? (Choose two.) |
| Option A | A. Only when the tables have a primary key-foreign key relationship. |
| Option B | B. The tables being joined have NOT NULL columns. |
| Option C | C. The tables being joined have both matched and unmatched data. |
| Option D | D. The columns being joined have NULL values. |
| Option E | E. The tables being joined have only matched data. |
| Correct Answer | C,D |