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 Developed by?
A. D. Richard Hipp
B. Dwight Merriman
C. Eliot Horowitz
D. Kevin Ryan
View Answer
Ans : A
Explanation: Developer: D. Richard Hipp
3. SQLite written in?
A. C++
B. C
C. Java
D. Python
View Answer
Ans : B
Explanation: Written in: C
4. SQLite Initial release?
A. 1997
B. 1998
C. 1999
D. 2000
View Answer
Ans : D
Explanation: Initial release: 17 August 2000
5. 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.
6. Which join is supported in SQLite?
A. LEFT OUTER JOIN
B. RIGHT OUTER JOIN
C. FULL OUTER JOIN
D. All of the above
View Answer
Ans : A
Explanation: Only LEFT OUTER JOIN is implemented in SQLite
7. 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.
8. Which command is used to modifies records?
A. Insert
B. Update
C. Delete
D. Modify
View Answer
Ans : B
Explanation: UPDATE : Modifies records
9. 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 (;).
10. Which command list names and files of attached databases?
A. db
B. use
C. .database
D. database
View Answer
Ans : C
Explanation: .databases : List names and files of attached databases
11. 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
12. The master table holds the key information about your database tables and it is called?
A. sqlite_master
B. sqlite_source
C. sqlitemaster
D. sqlite
View Answer
Ans : A
Explanation: The master table holds the key information about your database tables and it is called sqlite_master.
13. 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.
14. Which of the following command is true regarding SQLite ALTER TABLE Statement (Rename)?
A. ALTER TABLE table_name ADD COLUMN column_def...;
B. ALTER TABLE table_name RENAME TO new_table_name;
C. ALTER TABLE table_name COLUMN column_def...;
D. ALTER TABLE table_name TO new_table_name;
View Answer
Ans : B
Explanation: SQLite ALTER TABLE Statement (Rename) : ALTER TABLE table_name RENAME TO new_table_name;
15. 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;
16. Which of the following is not Storage Class?
A. Number
B. Integer
C. Text
D. Blob
View Answer
Ans : A
Explanation: Number is not Storage Class.
17. 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.
18. SQLite does have a separate Boolean storage class.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : B
Explanation: SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).
19. 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.
20. Which operator is negation of IN operator?
A. NIN
B. NOT
C. Exists
D. NOT IN
View Answer
Ans : D
Explanation: NOT IN : The negation of IN operator which is used to compare a value to a list of literal values that have been specified.
Discussion