gs gs118 SQLite MCQs - SQLite MCQs - Quiz No.8
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: What does .timeout ms command do?
For ms seconds, it tries to open locked tables
For ms milliseconds, it tries to open locked tables
For ms microseconds, it tries to open locked tables
For ms average seconds, it tries to open locked tables
Question 2: What does .width num num command do?
For "column" mode, it sets column widths
For "row" mode, it sets column widths
For "column" mode, it sets row widths
For "row" mode, it sets row widths
Question 3: What does .timer on|off command do?
Activates CPU timer measurement
Deactivates CPU timer measurement
Activates or deactivates CPU timer measurement
None of the above
Question 4: What dot command(s) is/are used to format the output?
.header on
.mode column
.timer on
All of the above
Question 5: Based on case-sensitivity, SQLite is -
Case sensitive
Not case sensitive
Not case sensitive with few commands being case sensitive
None of the above
Question 6: Which of the following command(s) is/are case sensitive in SQLite?
GLOB
Glob
Both A and B
None of the above
Question 7: Which of the following is/are TRUE about Comments in SQLite?
You can add comments to your SQLite code to make it more readable.
Nesting is not possible
Two consecutive "-" characters begin a comment.
All of the above
Question 8: Comment can also appear with -
/*
*/
Both A and B
None of the above
Question 10: Which of the following is/are the syntax of ANALYZE statement?
ANALYZE;
ANALYZE database_name;
ANALYZE database_name.table_name;
All of the above
