Database Access

You are using sqlite3 in Python and need to ensure that data integrity is maintained when performing multiple related INSERT operations. Which method should you call on the connection object to commit your changes?

Which Python library is the standard built-in interface for SQLite databases?

How do you retrieve the number of documents matched by a PyMongo 'find' operation without fetching all documents into memory?

Which of the following best describes the benefit of using parameterized queries in sqlite3?

In sqlite3, how do you handle a database error such as a constraint violation?

Which TWO of these are valid parameters for the MongoClient constructor?

What is the purpose of the 'upsert=True' option in MongoDB update operations?

You are implementing a custom type in SQLAlchemy. Which method must be overridden to convert data from the database type back to a Python object?

Which object in SQLAlchemy is responsible for maintaining a collection of loaded objects and managing their lifecycle?

You are using SQLAlchemy with an asynchronous driver (asyncio). Which object must be used to perform database operations asynchronously?

Which THREE of these are valid relationship loading strategies in SQLAlchemy?

In SQLAlchemy, what does the 'metadata.create_all(engine)' command do?

When using the sqlite3 module, what is the primary purpose of using a context manager (the 'with' statement) on a connection object?

Which TWO are common pitfalls when working with SQLite databases in a multi-threaded environment?

Which THREE are valid cascade options in SQLAlchemy?

Which THREE operations are supported by the PyMongo 'bulk_write' method?

Which THREE methods are part of the PEP 249 Python DB-API 2.0 interface?

Which THREE features are provided by SQLAlchemy's Unit of Work pattern?

In SQLAlchemy, how do you prevent an object from being saved to the database during a session.commit()?

Which THREE are characteristics of BSON (Binary JSON) as used by MongoDB?

Which TWO are common methods to handle BSON Date objects in PyMongo?

Which PyMongo method should be used to update a single document if you want to modify specific fields without replacing the entire document?

In a PyMongo application, what happens when you use 'insert_many' with 'ordered=False'?

Which TWO of the following are valid ways to execute a raw SQL query in SQLAlchemy?

When connecting to a MongoDB instance using PyMongo, what is the role of the 'MongoClient' object?

When configuring a connection pool in SQLAlchemy, what does the 'pool_size' parameter define?

In SQLAlchemy, what is the difference between 'lazy='select'' and 'lazy='joined'' loading strategies?

You are developing an application using SQLAlchemy and need to retrieve a single object by its primary key. Which method is preferred for this operation?

When using the MongoDB aggregation framework in PyMongo, which stage should be used to filter documents based on a condition?

When performing bulk inserts in PyMongo, which method is the most efficient?

You are using SQLAlchemy's relationship() function. What does 'back_populates' achieve?

Which command-line tool is typically used to inspect the contents of a SQLite database file?

When using SQLAlchemy Declarative Base, how do you define a table name that differs from the class name?

In SQL, which clause is used to filter results based on a condition after grouping?