SQLite Questions and Answers

11. SQLite Developed by?

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

View Answer

12. SQLite Initial release?

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

View Answer

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

14. Which command is used to modifies records?

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

View Answer

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

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

View Answer

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

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

18. Which of the following is not Storage Class?

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

View Answer

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

20. Which operator is negation of IN operator?

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

View Answer

---

Discussion