1A
2B
just to clarify question 2:
2B is exactly what they want to hear and ask for!
... although 2A in a "real world application" certainly would be prefered! If you want to have fun you can discuss this with your teacher and he probably will have to give you right, the reason is that UTF8 has almost no overhead for western characters. Given that almost all ASCII characters in use in western languages are in the 1-128 range and those really special characters (above 128 that in UTF8 would need 2bytes instead of just one) probably just make something like 0.001% of your whole application data and that is neglectable!
But whats not neglectable is the future maintenance. Because for now the requirements are just asian addresses ... but everyone knows that once you start supporting something like this there will be more requirements fur such multilingual fields comming up here and there ... so soon you would have to make more an more nvarchar2 fields in your application just to support this and that always costs you a lot of time. So the best thing you can do is to switch the base characterset once and then you can forget about the whole thing!
Cheers, Stefan
Main Topics
Browse All Topics
by: sri_devaPosted on 2002-12-04 at 01:17:53ID: 7530019
hi hualing,
For question:1, you are right the answer is A. The reason is "Any Object privileges that were cascaded to other user(s) will also be revoked when the rights have been revoked for the user who has cascaded the privilege". i.e if user X has granted the privilege to user Y, who has granted the privilege to user Z,...., then if user X revokes the privilege from user Y, all other users whom user Y has granted privilege will also be revoked.
Also this is not the same with respect to System Privileges, where cascading of right revoking is not possible.
For question:2 i think you are right as well.