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)?

A. 9999.99
B. 99.9999
C. 99.99
D. 9.99

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

A. VARCHAR2(50)
B. NUMBER
C. NUMBER(5,2)
D. NUMBER(6)

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

A. VARCHAR2(50)
B. NUMBER
C. Char(11)
D. NUMBER(11)

View Answer


4. Determine the most suitable data type for the given column? Column Name: Profile_Image ; Description: Image of the employee

A. Clob
B. Blob
C. Varchar(100)
D. None of the above

View Answer


5. The user defined data type can be created using

A. Create datatype
B. Create data
C. Create definetype
D. Create type

View Answer


6. In contemporary databases, the top level of the hierarchy consists of ______ each of which can contain _____

A. Catalogs, schemas
B. Schemas, catalogs
C. Alter typeEnvironment, schemas
D. Schemas, Environment

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

A. Integer
B. VARCHAR2(11)
C. CHAR(11)
D. Number(6)

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

A. Integer
B. VARCHAR2(11)
C. CHAR(11)
D. Number(6)

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

A. Timestamp
B. VARCHAR2(11)
C. Blob
D. Date

View Answer


10.  SQL allows comparison operations on the data types i.e.

A. Date
B. Timestamp
C. Time
D. All of the above

View Answer






Also check :


Discussion


* You must be logged in to add comment.