READ Free Dumps For Oracle- 1z0-001
| Question ID 1569 | Click on the EXHIBIT button and examine the structure of the DEPARTMENT and EMPLOYEE tables. Evaluate this SQL statement: CREATE INDEX emp_dept_id_idx ON employee(dept_id);
|
| Option A | A. Increase the chance of full table scans. |
| Option B | B. May reduce the amount of disk I/O for SELECT statements. |
| Option C | C. May reduce the amount of disk I/O for INSERT statements. |
| Option D | D. Store an index in the EMPLOYEE table. |
| Correct Answer | B |
| Question ID 1570 | Your company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification. If you do not want to store the results in the database, which statement is valid? |
| Option A | A. You need to give the arithmetic expression that involves the salary increment in the UPDATE clause of the SELECT statement. |
| Option B | B. You need to give the arithmetic expression that involves the salary increment in the SET clause of the UPDATE statement. |
| Option C | C. You need to add a column to the EMP table. |
| Option D | D. You need to give the arithmetic expression that involves the salary increment in the SELECT clause of the SELECT statement. |
| Option E | E. You need to give the arithmetic expression that involves the salary increment in the DISPLAY clause of the SELECT statement. |
| Correct Answer | D |