SQLite MCQ Questions And Answers
SQLite MCQs : This section focuses on "Basics" of SQLite. These Multiple Choice Questions (MCQ) should be practiced to improve the SQLite skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.
1. SQLite is a ?
A. NoSQL database
B. Distributed database
C. Relational database
D. Operational database
View Answer
Ans : C
Explanation: SQLite is a relational database management system.
2. SQLite written in?
A. C++
B. C
C. Java
D. Python
View Answer
Ans : B
Explanation: Written in: C
3. SQLite is an in-process library that implements a?
A. self-contained
B. serverless
C. zero-configuration
D. All of the above
View Answer
Ans : D
Explanation: SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. It is a database, which is zero-configured, which means like other databases you do not need to configure it in your system.
4. Which command is used to modifies an existing database object, such as a table?
A. Create
B. Alter
C. Drop
D. Modify
View Answer
Ans : B
Explanation: ALTER : Modifies an existing database object, such as a table.
5. SQLite dot commands and exception should not be terminated by?
A. :
B. /
C. ;
D. '
View Answer
Ans : C
Explanation: The commands are called SQLite dot commands and exception with these commands is that they should not be terminated by a semi-colon (;).
6. Which command print STRING in place of NULL values?
A. .null STRING
B. .value STRING
C. .nullSTRING
D. .nullvalue STRING
View Answer
Ans : D
Explanation: .nullvalue STRING : Print STRING in place of NULL values
7. Does SQLite is case insensitive?
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: SQLite is case insensitive, i.e. the clauses GLOB and glob have the same meaning in SQLite statements.
8. Which of the following command is true regarding ROLLBACK Statement?
A. ROLLBACK;
B. ROLLBACK TO SAVEPOINT savepoint_name;
C. Both A and B
D. ROLLBACK TO savepoint_name;
View Answer
Ans : C
Explanation: ROLLBACK; or ROLLBACK TO SAVEPOINT savepoint_name;
9. Any column can still store any type of data but the preferred storage class for a column is called its ?
A. affinity
B. type affinity
C. column store
D. type storage
View Answer
Ans : A
Explanation: Any column can still store any type of data but the preferred storage class for a column is called its affinity.
10. Which operator is used to search for values that are within a set of values, given the minimum value and the maximum value?
A. And
B. EXISTS
C. In
D. Between
View Answer
Ans : D
Explanation: BETWEEN : The BETWEEN operator is used to search for values that are within a set of values, given the minimum value and the maximum value.
Discussion