READ Free Dumps For Oracle- 1z0-007
| Question ID 7895 | You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?
|
| Option A | SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
|
| Option B | SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
|
| Option C | SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
|
| Option D | SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
|
| Option E | SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: This answer is correct: "Day" shows the day spelled out, "DD" shows the two-digit date, "Month" provides the month spelled out, "YYYY" shows the four-digit year. "FMDay" is special format mask to suppresses the extra spaces between the name of the day and the number of the date. Incorrect Answers A: This statement will return an error because of inappropriate usage of the TO_DATE() function. B: Incorrect format mask "DY" is used to show the number of the day. D: Incorrect format mask "DY" is used to show the name of the day and format mask "DDD" is used to show the number of the day. E: Incorrect format mask "DY" is used to show the name of the day and format mask "DDD" is used to show the number of the day. Also this statement will return an error because of inappropriate usage of the TO_DATE () function. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 87-88 Chapter 2: Limiting, Sorting, and Manipulating Return Data
| Question ID 7896 | The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code?
|
| Option A | SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
|
| Option B | SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';
|
| Option C | SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;
|
| Option D | SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
|
| Option E | SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: This statement returns the rows in the CUSTOMERS table that do not have a postal code. The correct syntax to check NULL values is usage of "IS NULL" clause. Incorrect Answers A: "CONTAINS NULL" is incorrect clause in Oracle. B: This satement will just check if postal code equals to string'____________'; D: Usage of "IS NVL" is incorrect in Oracle. But there is a function NVL() you can use to process NULL values. E: You can not use equal comparison to check whether value is NULL or not. Use construction "IS NULL" or "IS NOT NULL" to do that. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 31-32 Chapter 1: Overview of Oracle Databases