Test 1

Which module in Python is used to work with SQLite database?

• sql3

• sqlite

• sqlite3

• db_sqlite

To establish a connection to an SQLite database, you use the function:

• sqlite3.connect()

• sqlite.connect()

• sqlite3.create_connection()

• sql.connect()

In SQLite, data types are associated with columns. Which of the following is NOT a valid SQLite data type?

• INTEGER

• REAL

• TEXT

• STRING

The SQL statement to create a table named "Students" with columns "ID", "Name" and "Age" would be:

• CREATE TABLE Students ( ID INT, Name TEXT, Age INT)

• CREATE Students (ID INTEGER, Name TEXT, Age INTEGER)

• TABLE Students (ID INTEGER, Name TEXT, Age INTEGER)

• CREATE Students TABLE (ID INT, Name TEXT, Age INT)

To insert data into an SQLite table, you use the SQL statement:

• ADD INTO

• INSERT INTO

• INSERT DATA

• ADD DATA

Which method is used to commit changes to the database after executing SQL statements?

• update()

• save()

• apply()

• commit()

To retrieve all rows from an SQLite table, you use the following SQL statement:

• SELECT ALL FROM table_name

• SELECT*FROM table_name

• SELECT FROM table_name

• SELECT ROWS FROM table_name

The method to fetch the next row from a result set after executing a SELECT query is:

• fetch_row()

• next_row()

• ftechone()

• get_row()

Which of the following is true about SQLite data storage?

• SQLite databases are stored on the server.

• SQLite database can only be accessed by one application at a time.

• SQLite database are stored in a single file on the disk.

• SQLite database required a separate installation process.

In SQLite, the primary key is used for

• Storing encrypted data.

• Indexing purposes and ensuring unique rows.

• Joining tables together.

• Storing larger binary files.