What is the role of a foreign key in a relational database?
A. To prevent unauthorized access
B. To ensure data integrity and relationships
C. To index the database table
D. To encrypt data
Answer: Option B
A. To prevent unauthorized access
B. To ensure data integrity and relationships
C. To index the database table
D. To encrypt data
Answer: Option B
What is database connectivity in Python?
A. Connecting to internet databases
B. Establishing a connection between Python and databases
C. Creating new databases using Python
D. Sending emails from Python to databases
Which module is commonly used for database connectivity in Python?
A. dbconnect
B. pydb
C. sqlite3
D. dbconnector
A. A type of programming language
B. A relational database management system
C. A Python module for web scraping
D. A version control system
How can you create a new SQLite database using the sqlite3 module?
A. Using the create_database() function
B. By writing SQL queries
C. By calling the new_database() method
D. By executing the sqlite3.create() command
Join The Discussion