Question 1

What is SQLite?

Accepted Answer

A very lightweight system that allows database storage as a db file

Answer

A heavy database system

Answer

A system that requires a constant internet connection

Answer

A cloud-based database system

Question 2

What command is used to connect to a database in SQLite?

Accepted Answer

connect

Answer

run

Answer

start

Answer

open

Question 3

What is the purpose of creating a cursor in SQLite?

Accepted Answer

Allow running operations with the database

Answer

To print the program title

Answer

To add fake data into the database

Answer

To drop the table

Question 4

What does the 'commit' command do in SQLite?

Accepted Answer

Save the data updates

Answer

Print the data

Answer

Update the data

Answer

Delete the data

Question 5

What is stored in a SQLite database table?

Accepted Answer

Records of data

Answer

SQL commands

Answer

Table structures

Answer

Program titles

Question 6

What is the role of a primary key in a SQLite table?

Accepted Answer

Uniquely identify each record

Answer

Delete the data

Answer

Sort the data

Answer

Encrypt the data

Question 7

What type of data should be stored as a text field in SQLite?

Accepted Answer

String data

Answer

Date data

Answer

Boolean data

Answer

Numeric data

Question 8

Why is a phone number typically stored as text in a SQLite database?

Accepted Answer

Not used for mathematical operations

Answer

Easier to search

Answer

Faster retrieval

Answer

More secure

Question 9

What is the purpose of importing the sqlite3 module?

Accepted Answer

To connect to a SQLite database

Answer

To create a menu for user interaction

Answer

To add records of data

Answer

To print the program title

Question 10

What SQL command is used to drop a table in SQLite?

Accepted Answer

drop if exists

Answer

select

Answer

insert into

Answer

create table

Question 11

What is the purpose of the execute statement in SQLite?

Accepted Answer

To add records of data

Answer

To print program titles

Answer

To connect to the database

Answer

To drop tables

Question 12

What does committing in SQLite do?

Accepted Answer

Saves the data for next time

Answer

Deletes all data

Answer

Adds new columns

Answer

Creates a menu for user interaction

Question 13

What is the purpose of closing the database connection in SQLite?

Accepted Answer

To release system resources

Answer

To modify the user table

Answer

To create a menu for user interaction

Answer

To add records of data

Question 14

What is the purpose of adding records of data in SQLite?

Accepted Answer

To populate the table with information

Answer

To create a cursor

Answer

To connect to a database

Answer

To drop a table

Question 15

Why is it important to ensure data is inserted in the correct order?

Accepted Answer

To match the table column structure

Answer

To test program functionality

Answer

To print program titles

Answer

To connect to the database

Question 16

What does modifying the user table entail?

Accepted Answer

Adding new columns

Answer

Creating a cursor

Answer

Connecting to a database

Answer

Dropping the table

Related quizzes

Related quizzes