What is the purpose of a stored procedure in a database?
A. To store data backups
B. To define data types
C. To encapsulate SQL code for reuse
D. To generate random data
Answer: Option C
Solution (By Examveda Team)
A stored procedure is a precompiled collection of SQL statements that can be reused and executed in a database.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