gs gs118 SQLite MCQs - SQLite MCQs - Quiz No.15
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: ____ can be combined into SQLite Expressions.
Values
Operates
SQL Functions
All of the above
Question 2: An SQLite expression uses ____ statements and is written in the query language.
CREATE
SELECT
INSERT
ALTER
Question 4: Which of the following is/are the type(s) of SQLite expression?
Boolean
Numeric
Date
All of the above
Question 5: The data is fetched using SQLite Boolean expressions based on matching ____ value.
Single
Double
Triple
Multiple
Question 6: ____ operations are performed in queries using SQLite Numeric expressions.
Algebraic
Mathematical
Robotics
Textual
Question 7: There are several built-in functions in numerical expressions, such as ____.
avg()
sum()
count()
All of the above
Question 8: ____ include avg(), sum(), count(), etc.
Data calculation functions
Aggregate calculation functions
Aggregate data calculation functions
None of the above
Question 9: The current system ____ is/are retrieved using SQLite Date expressions.
Date
Time
Both A and B
None of the above
Question 10: What is the syntax of SQLite Date Expressions?
SELECT TIMESTAMP;
SELECT CURRENT;
SELECT DATETIME;
SELECT CURRENT_TIMESTAMP;
