| naidu |
Posted: Dec 27, 2006 09:59:41 AM |
Total Post: 85
Joined: Nov, 2006
|
The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER (4) NOT NULL
CUSTOMER_NAME VARCHAR2 (100) NOT NULL
STREET_ADDRESS VARCHAR2 (150)
CITY_ADDRESS VARHCAR2 (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.
You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?
A. COUNT (UPPER (country_address))
B. COUNT (DIFF (UPPER (country_address)))
C. COUNT (UNIQUE (UPPER (country_address)))
D. COUNT DISTINTC UPPER (country_address)
E. COUNT (DISTINTC (UPPER (country_address)))
Answer:
|
|
|
 Jayanta |
| Posted: Dec 27, 2006 10:58:54 AM |  |
|
Total Post: 479
Joined: Feb, 2006
|
|
|
|
|
| naidu |
| Posted: Dec 28, 2006 01:11:15 AM | |
|
Total Post: 85
Joined: Nov, 2006
|
Ans: E is wrong answer
because COUNT(DISTINTC(UPPER(country_address)))
here DISTINCT is wrong
Ans is C.
COUNT(UNIQUE(UPPER(country_address)))
|
|
|
|
|
| Jayanta |
| Posted: Dec 28, 2006 01:22:50 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
hello naidu!
i dont know how u find that option e is wrong. will u plz explain a little bit elaborately, to make my understanding clear.
here i am giving my explanation against the option e:
the syntax of count is count({*|[distinct|all]expression})
and group functions can be nested to a depth of two.
expectingur explanation
with regards
jayanta
|
|
|
|
|
| naidu |
| Posted: Dec 28, 2006 02:00:19 AM | |
|
Total Post: 85
Joined: Nov, 2006
|
can u plz see E is have DISTINCT spel is wrong
in case DISTINCT we can use UNIQUE
i hope this is right
if me is anything wrong let me know that Plz
|
|
|
|
|
| Jayanta |
| Posted: Dec 28, 2006 03:55:08 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
dear naidu,
u r supposed to write oracle not english literature
hope the source from where u got the question have some typing mistake.
and unique is a constraint name can't be used in this manner.
hope this helps.
with regards
jayanta
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
