gs gs118 SQLite MCQs - SQLite MCQs - Quiz No.12
gs gs118 Data Mining Quiz
This quiz belongs to book/course code gs gs118 Data Mining of gs organization. We have 15 quizzes available related to the book/course Data Mining. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQLite MCQs. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: ____ storage class(es) is/are all stored in the TEXT column.
NULL
TEXT
BLOB
All of the above
Question 2: Each of the ____ storage classes may be used in the NUMERIC column.
Two
Three
Four
Five
Question 3: With an exception in a cast expression, INTEGER behaves like a column with ____ affinity.
Variable affinity
Text affinity
Numeric affinity
Null affinity
Question 4: Integer values are converted into _____ by REAL, just like a column with numeric affinity.
Point values
Floating values
Floating point values
None of the above
Question 5: Columns with affinity NONE maintain ____ between storage classes and don't persuade data between them.
Preference
No preference
Partial preference
Average preference
Question 6: Which of the following is/are the data type(s) for the INTEGER affinity?
INT
INTEGER
BIGINT
All of the above
Question 7: Which of the following is NOT the data type for the INTEGER affinity?
TINYINT
SMALLINT
NUMERIC
MEDIUMINT
Question 8: Which of the following is/are the data type(s) for the TEXT affinity?
CHARACTER()
VARCHAR()
NCHAR()
All of the above
Question 9: Which of the following is the data type for the NONE affinity?
BLOB datatype specified
BLOB no datatype specified
CLOB datatype specified
CLOB no datatype specified
Question 10: Which of the following is/are the data type(s) for the REAL affinity?
NUMERIC
DATETIME
FLOAT
All of the above
