WorksheetsDatabase2
Total questions: 7
Worksheet time: 4mins
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
