Database2

Which of the following commands is used to insert data into a SQLite database?

• 
  ADD

• DELETE

• UPDATE

• INSERT

What is the syntax for creating a table in SQLite?

• 
  CREATE TABLE table_name (first_col, second_col, third_col)

• 
  CREATE table_name TABLE (first_col, second_col, third_col)

• CREATE table_name (first_col, second_col, third_col) TABLE

• 
  CREATE (first_col, second_col, third_col) TABLE table_name

Which command is used to retrieve data from a SQLite database?

• 
  SELECT

• GET

• 
  FETCH

• RECEIVE

What is the purpose of the WHERE clause in a SQLite SELECT statement?

• 
  To join tables together

• To order the results by a specific column

• 
  To group the results by a specific column

• To filter the results based on a condition

What is a SQLite index?

• A foreign key in a related table

• A column that stores unique identifiers for each row

• 
  A data structure that improves the speed of database queries

• 
  A special type of table used for storing binary data

Which datatype is used to store date and time values in SQLite?

• 
  INT

• 
  TEXT

• DATETIME

• 
  CHAR

What is the difference between a DELETE and DELETE with where clause command in SQLite?

• 
  DELETE removes all rows, while DELETE with where clause removes individual rows

• 
  DELETE removes individual rows, while DELETE with where clause removes all rows at once

• Both are same