SQLite Questions and Answers
11. 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
12. SQLite Initial release?
A. 1997
B. 1998
C. 1999
D. 2000
View Answer
Ans : D
Explanation: Initial release: 17 August 2000
13. 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
14. Which command is used to modifies records?
A. Insert
B. Update
C. Delete
D. Modify
View Answer
Ans : B
Explanation: UPDATE : Modifies records
15. 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
16. 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.
17. 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;
18. 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.
19. 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).
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