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


* You must be logged in to add comment.