READ Free Dumps For Oracle- 1z0-001
| Question ID 1623 | Which three SQL arithmetic expressions return a date? (Choose three.) |
| Option A | A. ('03-JUL-96' - '04-JUL-97') / 7 |
| Option B | B. ('03-JUL-96' - '04-JUL-97') / 12 |
| Option C | C. '03-JUL-96' + (12 / 24) |
| Option D | D. '03-JUL-96' - '04-JUL-97' |
| Option E | E. '03-JUL-96' + 7 |
| Option F | F. '03-JUL-96' - 12 |
| Correct Answer | C,E,F |
| Question ID 1624 | When selecting data, which statement is valid about projection? |
| Option A | A. Projection allows you to choose columns. |
| Option B | B. Projection allows you to choose rows. |
| Option C | C. Projection allows you to join tables together. |
| Option D | D. Projection allows you to add columns to a table. |
| Correct Answer | A |