Question 1 of 25
Hints left: 3
Q1
What is the role of a foreign key in a relational database?
Q2
Which of the following is NOT a common SQL database management system?
Q4
What is the purpose of a stored procedure in a database?
Q5
What is the purpose of the execute() method in the sqlite3 module?
Q6
What is the purpose of the super() function in advanced OOP?
Q7
What is SQL injection?
Q8
What is a primary key in a database table?
Q9
Which ORM library is popular for Python database connectivity?
Q10
What does the commit() method do in the context of database transactions?
Q11
What does the term "CRUD" stand for in the context of databases?
-
A
-
B
-
C
-
D
Q12
Which of the following is NOT an isolation level for database transactions?
Q13
How do you define a class that maps to a database table using SQLAlchemy?
Q14
What is the purpose of database transactions?
Q15
What is database connectivity in Python?
Q16
How do parameterized queries help prevent SQL injection?
Q17
How can you create a new SQLite database using the sqlite3 module?
Q18
What is an ORM (Object-Relational Mapping) in database connectivity?
Q19
How can you fetch data from a result set obtained through an execute() command?
Q20
How can you rollback a transaction in the sqlite3 module?
Q21
What is a cursor in the context of database connectivity?
Q22
How can you update data in a database table using SQL?
Q23
How do you establish a connection to an SQLite database using sqlite3?
Q24
Which module is commonly used for database connectivity in Python?
Q25
How do you execute a stored procedure from Python using the sqlite3 module?