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


2. SQLite written in?

A. C++
B. C
C. Java
D. Python

View Answer


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


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


5. SQLite dot commands and exception should not be terminated by?

A. :
B. /
C. ;
D. '

View Answer


6. Which command print STRING in place of NULL values?

A. .null STRING
B. .value STRING
C. .nullSTRING
D. .nullvalue STRING

View Answer


7. Does SQLite is case insensitive?

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


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


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


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





Discussion


* You must be logged in to add comment.