READ Free Dumps For Oracle- 1z0-007
| Question ID 7909 | 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) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? (Choose two.)
|
| Option A | SELECT TOTAL(*) FROM customer;
|
| Option B | SELECT COUNT(*) FROM customer;
|
| Option C | SELECT TOTAL(customer_id) FROM customer;
|
| Option D | SELECT COUNT(customer_id) FROM customer;
|
| Option E | SELECT COUNT(customers) FROM customer;
|
| Option F | SELECT TOTAL(customer_name) FROM customer;
|
| Correct Answer | BD |
Explanation Explanation/Reference: Explanation: These statements provide correct syntax and semantics to show the number of customers. Function COUNT() can be used with substitution symbol of all columns "*" or just with one column name. Last query will be processed a little bit faster. Incorrect Answers A: There is no TOTAL() function in Oracle. C: There is no TOTAL() function in Oracle. E: You cannot table name as a parameter of COUNT() function. F: There is no TOTAL() function in Oracle. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 123-125 Chapter 3: Advanced Data Selection in Oracle
| Question ID 7910 | Which two tasks can your perform by using the TO_CHAR function? (Choose two)
|
| Option A | Convert 10 to 'TEN'
|
| Option C | Convert '10' to 10
|
| Option D | Convert 'TEN' to 10
|
| Option E | Convert a date to a character expression
|
| Option F | Convert a character expression to a date
|
| Correct Answer | CE |
Explanation Explanation/Reference: Explanation: TO_CHAR(x) function is used to convert the value x to a character or converts a date to a character string using formatting conventions. Incorrect Answers A: This function cannot convert the number to the string representing number spelled out. B: TO_CHAR() function cannot convert the character value to a number. TO_NUMBER() function does this. D: This function is not able to convert the string representing number spelled out to the number itself. F: TO_CHAR() function cannot convert a character expression to a date. TO_DATE() function does this. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 86-87 Chapter 2: Limiting, Sorting, and Manipulating Return Data