READ Free Dumps For Oracle- 1z0-007
| Question ID 7943 | Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?
|
| Option A | SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
|
| Option B | SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
|
| Option C | SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
|
| Option D | SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
|
| Option E | SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Function TO_CHAR(x, y) converts the value x to a character or converts a date to a character string using formatting conventions. Incorrect Answers B: Function TO_DATE(x,[y]) converts the non-date value x to a date using the format specified by x. C: The DECODE function is used as substitution of IF-THEN-ELSE PL/SQL construction in SQL queries. The SELECT statement provides incorrect syntax of it because it cannot have only two parameters. D: The DECODE function is used as substitution of IF-THEN-ELSE PL/SQL construction in SQL queries. The SELECT statement provides incorrect syntax of it because it cannot have only two parameters. E: This statement provide incorrect syntax of TO_CHAR() function: it requires only one parameter, not two. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 86-87 Chapter 2: Limiting, Sorting, and Manipulating Return Data
| Question ID 7944 | Which is an /SQL*Plus command?
|
| Option A | INSERT
|
| Option B | UPDATE
|
| Option C | SELECT
|
| Option D | DESCRIBE
|
| Option E | DELETE
|
| Option F | RENAME
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: There is only one SQL*Plus command in this list: DESCRIBE. It cannot be used as SQL command. This command returns a description of tablename, including all columns in that table, the datatype for each column, and an indication of whether the column permits storage of NULL values. Incorrect Answers A: INSERT is not a SQL*Plus command. It's data-manipulation language (DML) command. B: UPDATE is not a SQL*Plus command. It's data-manipulation language (DML) command. C: SELECT is not a SQL*Plus command. E: DELETE is not a SQL*Plus command. It's data-manipulation language (DML) command. F: RENAME is not a SQL*Plus command. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 43 Chapter 1: Overview of Oracle Databases