READ Free Dumps For Oracle- 1z0-007
| Question ID 7963 | Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?
|
| Option A | SELECT &1, "&2" FROM &3 WHERE last_name = '&8';
|
| Option B | SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
|
| Option C | SELECT &1, &2 FROM &3 WHERE last_name = '&8';
|
| Option D | SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation : In a WHERE clause, date and characters values must be enclosed within single quotation marks. Sample of the correct syntax SELECT EMPLOYEE_ID, &COLUMN_NAME FROM EMPLOYEES Incorrect Answers : A. Incorrect use of " symbol B. Incorrect use of ' symbol D. No input for table name as EMP has been use in the statement. Refer : Introduction to Oracle9i : SQL, Oracle University Student Guide, Producing Readable Output with iSQL*PLUS, p. 7-8
| Question ID 7964 | Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?
|
| Option A | 46 and 45
|
| Option B | 46 and 45.93
|
| Option C | 50 and 45.93
|
| Option D | 50 and 45.9
|
| Option E | 45 and 45.93
|
| Option F | 45.95 and 45.93
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation : ROUND (45.953,-1) will round value to 1 decimal places to the left. TRUNC (45.936,2) will truncate value to 2 decimal The answer will be 50 and 45.93 Incorrect Answers : A. Does not meet round and truncate functions B. Does not meet round functions D. Does not meet truncate functions E. Does not meet round functions F. Does not meet round functions Refer : Introduction to Oracle9i : SQL, Oracle University Student Guide, Single-Row functions, p. 3-13