05 - SQlite

Question 1

What is SQLite?

Answer 1

Public-domain, lightweight RDBMS, follows nearly entire SQL-92. Designed by D. Richard Hipp, 2000.

Main features:

• Serverless
• Zero configuration
• Cross-platform
• Small Runtime Footprint
• Highly Reliable
• Self-contained

Many applications use SQLite3: WhatsApp, Skype, Mozilla Firefox, Chrome.

Question 2

Name the commands for:

1. Display tables
2. Display schema of a table
3. To change the output
4. To quit

Answer 2

1. .tables
2. .schema

• .output
• .quit

Question 3

What are the five data types in SQLite?

Answer 3

• INTEGER
• TEXT (CHAR, VARCHAR, TEXT, …)
• REAL (REAL, DOUBLE, FLOAT, …)
• NUMERIC (BOOLEAN, DATETIME, NUMERIC, …)
• NONE

Question 4

How can you auto increment a field in SQL?

Answer 4

CREATE TABLE person (

PID INTEGER PRIMARY KEY AUTOINCREMENT

Name TEXT

);

Question 5

What is the SQLite_Master table?

Answer 5

Contain information on all tables, indexes and keys.

Get information from sqlite_master table:

SELECT * FROM sqlite_master;

Show the structure of the sqlite_master table:

.schema sqlite_master;

Question 6

What are the five steps to analysis unknown databases?

Answer 6

1. Understand / Use the Application
2. Find the SQLite files
3. Gather information on each database file
4. Perform common application tasks
5. Develop SQL queries to extract information