SQLite Interview Questions and answers from aCoding tag - PowerPoint PPT Presentation

About This Presentation
Title:

SQLite Interview Questions and answers from aCoding tag

Description:

Most frequently asked top Advanced sqlite interview questions and answers pdf with detailed.we will discuss some of the most likely SQLite Interview Questions which are asked during an interview. visit now for more questions and answers at SQLITE :- – PowerPoint PPT presentation

Number of Views:87

less

Transcript and Presenter's Notes

Title: SQLite Interview Questions and answers from aCoding tag


1
SQLite Interview
Questions
  • By Coding Tag

2
SQLite Interview
Questions
3
What is SQLite ?
  • SQLite SQLITE is a C-Language library which
    implements a small,self contained ,
    high-reliability, full featured, It is the most
    used database engine in the world wide.
  • As talking about databases ,it is built into all
    mobile phones and most computers and comes
    bundled inside countless other applications in
    people daily routines and other applications to
    store data .

4
Difference between SQL and SQLite ?
  • SQL
  • It's a Structured query language used to query a
    database
  • SQL is a query that specifies how a relation
    schema is created.
  • DDL and DML, Embedded SQL and dynamic SQL are
    components of SQL.
  • SQLite
  • Its an Embeddable Relational Database Management
    Systems
  • It is a file based
  • It support many features of SQL and does not
    support stored procedures.
  • It is used in Android Development to apply
    database concepts.

5
Explain some mostly used SQLITE commands
  • Mostly used SQLite commands are
  • i) Commands used for general storage management
    and accessing methods
  • CREATE
  • DROP
  • ALTER
  • ii) Commands used for manipulating and modifying
    the stored data
  • INSERT
  • DELETE
  • UPDATE
  • iii) Commands used for retrieving the data from
    the database
  • SELECT

6
How to add or delete columns from an existing
table.
  • SQLite has a limit on ALTER TABLE command it can
    be used to add a column to the end of the table
    or to change the name of the table .or in other
    hand recreate the existing table data to a
    temporary table, drop the old table, then create
    a new table and then copy the data back in from a
    temporary table.
  • The following steps illustrate how this could be
    done
  • BEGIN TRANSACTION
  • CREATE TEMPORARY TABLE t1(a,b)
  • INSERT INTO t1 SELECT a,b FROM t1
  • DROP TABLE t1
  • CREATE TABLE t1(a,b)
  • INSERT INTO t1 SELECT a,b FROM t1
  • DROP TABLE t1
  • COMMIT

7
How to add Primary key in SQLITE tables ?
  • Unlike other databases systems MySQL , Alter
    Table statement cannot be used to add primary key
    to an existing table.
  • You can add primary key by following steps
  • Set the foreign key constraint check off.
  • Rename the table to another table name
    (old_table)
  • Create a new table with exact structure of the
    table that you have been renamed.
  • After that, copy data from the old_table to the
    table.
  • Turn on the foreign key constraint check on

8
What databases does SQLite support ?
  • SQLite uses dynamic typing in its table
    databases. Content can be stored as
  • INTEGER
  • REAL
  • TEXT
  • BLOB
  • or as NULL.

9
THANKS!
Do you have any questions codingtag.com_at_gmail.com
www.codingtag.com
Write a Comment
User Comments (0)
About PowerShow.com