SQL Data Types Questions and Answers
This section focuses on the "Data Types" of the SQL. These Multiple Choice Questions (mcq) should be practiced to improve the SQL skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.
1. What is the maximum value that can be stored in NUMERIC(4,2)?
View Answer
2. Determine data type for the given column? Column Name: Price ; Description: Cost of an item in rupees and paise ; Example: 200.21
View Answer
3. Determine data type for the given column? Column Name: IFSC_Code ; Description: A 11 Character alphanumeric code that identifies a bank branch ; Example: SBIN0009044
View Answer
4. Determine the most suitable data type for the given column? Column Name: Profile_Image ; Description: Image of the employee
View Answer
5. The user defined data type can be created using
View Answer
6. In contemporary databases, the top level of the hierarchy consists of ______ each of which can contain _____
View Answer
7. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: PIN_Code ; Description: Six digit numeric PIN code for any address in India ; Example: 560100
View Answer
8. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: Student_id ; Description: Unique number assigned to every Student ; Example: 100000
View Answer
9. Choose the most suitable data type in case multiple data types are possible for the column.Column Name: Date_Of_Birth ; Description: Date of Birth of the employee ; Example: 1990/01/01
View Answer
10. SQL allows comparison operations on the data types i.e.
View Answer
Also check :