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:
3.List the standard SQLite commands
4.Who was the founder of SQLite database ?
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 ?
|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 oriented||There 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 ?
10.How can create table in SQLite ?
Create table database_name.table_name ( col_1 datatype PRIMARY KEY col_2 datatype );