1. The data type of a column is declared as CHAR(5). Can the column contain a string of four characters?   Yes   No   2. The string constant 'Roger''s' will be stored as _______.   Rogers   Roger''s   Roger's   Roger s   Hint Half-n-half Clue   3. What is the POSITION function used for?   To extract the row number of a particular record.   None of the above   To extract the starting position of a string in another string.   Half-n-half Clue   4. The data type used to store variable length bit strings is _______.   BIT(length)   VARBIT(length)   VARBIT2(length)   BIT VARYING(length)   Half-n-half Clue   5. SQL is a _______ language.   object-oriented   procedural   non-procedural   Half-n-half Clue   6. _______ value is used to represent unknown or undefined values.   Blank   ZERO   NULL   Half-n-half Clue   7. BINARY STRING data type is used to store images, audio, video and programs.   True   False