Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 4

Q1. In MySQL, date values to be enclosed in { } or in single quotation 

      marks(True/False)

Q2. ______________ is the format of date in MySQL.

Q3. Data type of "name" field in a table is char(25). How many bytes will be

      occupied by values "Ram" and "Rohan Kumar"?

Q4. Time data type is used to store time in ________ format.

Q5. Varchar is a fixed length data type.(True/False)

Q6. Name the command which is used to close MySQL.

Q7. Which data type in MySQL is used to store logical values?

Q8. Out of char, varchar and memo, which data type is used to store large 

      amount of data?

Q9. Which data type in MySQL is used to store images, animations,

      clips etc.

Q10. Write the appropriate data types for the following fields.

1. DateofBirth
2. Salary
3. Name
4. Address
5. Phonenumber

 SOLUTIONS

Q1. In MySQL, date values to be enclosed in { } or in single quotation 

      marks(True/False)

Ans. True

Q2. ______________ is the format of date in MySQL.

Ans. yyyy/mm/dd

Q3. Data type of "name" field in a table is char(25). How many bytes will be

      occupied by values "Ram" and "Rohan Kumar"?

Ans. 25

Q4. Time data type is used to store time in ________ format.

Ans. hh:mm:ss

Q5. Varchar is a fixed length data type.(True/False)

Ans. False

Q6. Name the command which is used to close MySQL.

Ans. quit

Q7. Which data type in MySQL is used to store logical values?

Ans. Boolean

Q8. Out of char, varchar and memo, which data type is used to store large 

      amount of data?

Ans. memo

Q9. Which data type in MySQL is used to store images, animations,

      clips etc.

Ans. BLOB or RAW

Q10. Write the appropriate data types for the following fields.

1. DateofBirth
2. Salary
3. Name
4. Address
5. Phonenumber

Ans. 

1. Date
2. Any numeric data type preferable numeric or decimal.
3. Char or Varchar
4. Char or Varchar
5. Char or Numeric