Python & SQLite
Quiz Questions:
Question 1: You can delete a whole table, a view of a table, or any other object within a database by using the ____ command
- DROP TABLE
- REMOVE TABLE
- DELETE TABLE
- CLEAR TABLE
Question 2: What is the primary file format used by SQLite databases?
- .txt
- .db
- .sql
- .json
Question 3: Which of these statement is TRUE about SQLite?
- It requires a server to run
- It can store images and files
- It can run only on Linux
- It's only for web applications
Question 4: What is SQLite?
- A database management system
- A Python library
- A web framework
- A game engine
Question 5: Which Python library is commonly used with SQLite?
- pandas
- sqlite3
- matplotlib
- flask
Question 6: How do you create a connection to a SQLite database in Python?
- sqlite3.connect('database.db')
- sqlite3.create('database.db')
- SQLite.connect('database.db')
- py.connect('database.db')
Question 7: What command do you use to insert data into an SQLite table?
- UPDATE command
- INSERT command
- ADD command
- INTO command
Question 8: Correct syntax of UPDATE query
- UPDATE table name SET Column name
- UPDATE table name SET Column name WHERE column name=value
- UPDATE FROM tablename WHERE condition
- Both A and B
Question 9: How can you retrieve all records from a table named 'users'?
- SELECT * FROM users
- GET ALL users
- FETCH users
- LOAD users FROM Table
Question 10: What does the acronym SQL stand for?
- Structured Query Language
- Static Query Language
- Simple Quality Language
- Smart Query Language
Python & SQLite
10 Questions • Share this quiz:
Share:
Question 1
You can delete a whole table, a view of a table, or any other object within a database by using the ____ command
1 of 10
Question 1 of 10