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
Solution (By Examveda Team)
A foreign key is used to establish relationships between tables, ensuring data integrity and referential integrity.This Question Belongs to Python Program >> Database Connectivity With Python
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