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