Study for the Database Systems Test. Prepare with flashcards and multiple choice questions, each with hints and explanations. Get ready for success!

Multiple Choice

Which function converts a string to proper case (initial capital letters)?

Turning a string into proper case means capitalizing the first letter of each word and making the remaining letters lowercase. The InitCap function does exactly that: it converts the string so that each word starts with an uppercase letter while the rest of the letters are lowercase. The other options don’t fit: Lower makes everything lowercase, Length returns how many characters, and Right returns a substring from the end. So InitCap is the correct choice for proper-case formatting.

Turning a string into proper case means capitalizing the first letter of each word and making the remaining letters lowercase. The InitCap function does exactly that: it converts the string so that each word starts with an uppercase letter while the rest of the letters are lowercase. The other options don’t fit: Lower makes everything lowercase, Length returns how many characters, and Right returns a substring from the end. So InitCap is the correct choice for proper-case formatting.