Database Access

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

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

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

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

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?

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 THREE operations are supported by the PyMongo 'bulk_write' method?

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

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

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

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

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

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

Which THREE are valid cascade options in SQLAlchemy?

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