You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?

Related MCQs

• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• ……………….. contains information that defines valid values that are stored in a column or data type.
• What type of join is needed when you wish to include rows that do not have matching values?
• What type of join is needed when you wish to include rows that do not have matching values?
• What type of join is needed when you wish to return rows that do have matching values?
• Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use                        on individual key values, allowing other key values to be inserted or deleted from the same leaf.
• What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
• Which of the following consists of a row of column headings, together with zero or more rows of data values?
• If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as
• One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as