SQLIte Interview Q & A

1.What do you mean by SQLite ?

SQLite is an open source  relational database management system which is self-contained and need zero-configuration.

2.What data types does SQLite support ?

List of SQLite data types are given below:

INTEGER

TEXT

BLOB

REAL

NULL

3.List the standard SQLite commands

SELECT

INSERT

DELETE

UPDATE

DROP

CREATE

4.Who was the founder of SQLite database ?

D.Richard Hipp

5.What are the advantage of SQLite database ?

It is light -weight database

It does not required separate server.

It is easy to learn and implement.

It is written in C programming language.

It support almost all the operating system.

It is a self-contained means there is no need to external dependencies.

6.What are the important features of SQLite database ?

It is an open source means there is need to license

It is a cross-platform means can be used with window,linux,mac etc

It is server-less means does not required to interact with the server to configure

It needs  Zero-configuration

7.What is the difference between the SQL and SQLite database ?

SQLSQLite
SQL stands for structured query language

SQLite is  a embedded relational database management system.


It is a stored procedure language.

It support many features of SQL but it is not stored procedure language.


It is a query language which is used to interact with the database and perform the different operations such creating database,tables,inserting data into the tables etc.

It is file-based and portable database
There is need connection to setup the SQL ie server orientedThere is no need to connection to setup SQLite ie server-less

8 What is main purpose of use SQLite ?

It is used for the data analysis

It can be used to store the data for the website

It is most suitable with the android application

It is not client-server database

9 How can create database in SQLite ?

sqlite3 database_name.db

10.How can create table in SQLite ?

Create table database_name.table_name
(
col_1 datatype PRIMARY KEY
col_2 datatype 
);