Home » Other » Training & Certification » PL/SQL by exmaple multi choice question
PL/SQL by exmaple multi choice question [message #386123] Thu, 12 February 2009 16:46 Go to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
how are you? i was wondering if someone could help me...
I am readin PL/SQL by Example 3rd edition and on page 65 there was the following question:


which of the following are valid character types for PL/SQl?
a. numbers
b. english letters
c. paragraph returns
d. arith. symbols
e. Japanese Kanji


The answer at the back of the book is B. I thought when i 1st saw this question that it should be both A and B since CHAR type excepts LETTERS and NUMBERS (integers) and not just English letters. I looked in to Errata and there is not correction.
please help,


thank you:)
Re: PL/SQL by exmaple multi choice question [message #386127 is a reply to message #386123] Thu, 12 February 2009 17:03 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Seems wrong to me, too.

Quote:

You use the CHAR datatype to store fixed-length character data. How the data is represented internally depends on the database character set.



Source

And the same is true for varchars.

So any characters can be valid if the character set supports them, which would basically include ALL the answers in the list.

Re: PL/SQL by exmaple multi choice question [message #386128 is a reply to message #386127] Thu, 12 February 2009 17:12 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
thank you Smile

which means that the answer at the book of that book is wrong?

I mean A, B, C, D are correct answers right?
Re: PL/SQL by exmaple multi choice question [message #386131 is a reply to message #386128] Thu, 12 February 2009 17:24 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Unless they mean something completely different by "valid character types for PL/SQL", like some definition of "character" that can be used in PL/SQL code that they only use in the book.

For instance, a variable name in PL/SQL can only contain English characters and numbers (and a few other characters like - and _) , and must start with an character. But that is not really called a character "type" in the normal documentation.


[Updated on: Thu, 12 February 2009 17:25]

Report message to a moderator

Re: PL/SQL by exmaple multi choice question [message #386244 is a reply to message #386123] Fri, 13 February 2009 04:49 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
And that would mean that the answer should be A and B, so even then the books still wrong.
Rolling Eyes
Re: PL/SQL by exmaple multi choice question [message #386247 is a reply to message #386128] Fri, 13 February 2009 04:54 Go to previous message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
happyjoshua777 wrote on Thu, 12 February 2009 23:12

I mean A, B, C, D are correct answers right?


And E.

As Thomas pointed out before:
Quote:

So any characters can be valid if the character set supports them

Previous Topic: MCSE exams
Next Topic: I want to download free SQL*plus(oracle) software from the sites
Goto Forum:
  


Current Time: Sun Dec 04 22:52:45 CST 2016

Total time taken to generate the page: 0.04479 seconds