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 Developed by?

A. D. Richard Hipp
B. Dwight Merriman
C. Eliot Horowitz
D. Kevin Ryan

View Answer


3. SQLite written in?

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

View Answer


4. SQLite Initial release?

A. 1997
B. 1998
C. 1999
D. 2000

View Answer


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


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


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


8. Which command is used to modifies records?

A. Insert
B. Update
C. Delete
D. Modify

View Answer


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

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

View Answer


10. Which command list names and files of attached databases?

A. db
B. use
C. .database
D. database

View Answer


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

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

View Answer


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


13. Does SQLite is case insensitive?

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

View Answer


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


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


16. Which of the following is not Storage Class?

A. Number
B. Integer
C. Text
D. Blob

View Answer


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


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


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


20. Which operator is negation of IN operator?

A. NIN
B. NOT
C. Exists
D. NOT IN

View Answer





Discussion


* You must be logged in to add comment.