SQLite Interview Questions and Answers

Ques 1. What is SQLite?

SQLite is a relational database management system which is self-contained, server-less and need zero configuration.

SQLite is a freely available open source database provided in Android. SQLite is a lightweight and compact database that does not require any kind of server to run. It is easily integrated into any kind of mobile.

Ques 2. Who was the designer of SQLite?

SQLite was designed by D. Richard Hipp for the purpose of no administration required for operating a program.

Ques 3. What are the most important features of SQLite?

There are lots of features which make SQLite very popular:

• SQlite is free of cost.
• SQLite is server-less.
• SQLite is flexible.
• SQLite doesn't need configuration.
• SQLite is cross-platform.
• SQlite is lightweight.

Ques 4. What are the advantages of using SQLite?

SQlite has the following main advantages:

• SQLite is very light weight database.
• Data storing is very easy and efficient.
• SQlite is very easy to learn and use.

Ques 5. How would you create a database in SQLite?

In SQLite, sqlite3 command is used to create database.

Syntax:

sqlite3 my_database_name.db

Ques 6. How to create a table in SQLite database?

CREATE TABLE statement is used to create a table in SQLite database. You have to define the columns and data types of each column while creating the table.

CREATE TABLE my_database_name.table_name(    

column1 datatype  PRIMARY KEY(one or more columns),    

column2 datatype,    

column3 datatype,    

columnN datatype,    

);    

Ques 7. How would you drop a table in SQLite database?

DROP TABLE command is used to delete or permanently drop a table from SQLite database.

DROP TABLE my_table_name;

Ques 8. What data types are supported by SQLite?

SQLite uses dynamic typing. Content can be stored as INTEGER, REAL, TEXT, BLOB, or as NULL.

Ques 9. How to insert data in a table in SQLite?

INSERT INTO statement is used to insert data in a table in SQLite database. There are two ways to insert data in table:

Syntax A:

INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]      

VALUES (value1, value2, value3,...valueN);   

Syntax B:

INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);      

Ques 10. How to create an AUTOINCREMENT field?

For autoincrement, you have to declare a column of the table to be INTEGER PRIMARY KEY, then whenever you insert a NULL into that column of the table, the NULL is automatically converted into an integer which is one greater than the largest value of that column over all other rows in the table, or 1 if the table is empty.