SQL Alchemy

What does ORM stand for?

• Object Relational Mapping

• Object Relation Model

• Optimized Relational Method

• Object Repository Manager

Which of the following is a benefit of using an ORM?

• Writing only raw SQL queries

• Mapping database tables to Python classes

• Avoiding databases altogether

• Replacing Python with SQL

In SQLAlchemy, which component is responsible for connecting to the database?

• Session

• Engine

• MetaData

• ORM

Which command installs SQLAlchemy?

• pip install SQLAlchemy

• npm install SQLAlchemy

• apt-get install SQLAlchemy

• conda run SQLAlchemy

Which driver is required for PostgreSQL in SQLAlchemy?

• mysql-connector-python

• sqlite3

• psycopg2-binary

• pymongo

What is the purpose of declarative_base() in SQLAlchemy?

• Creates database tables automatically

• Defines the base class for ORM models

• Starts a session for transactions

• Connects to the database engine

In a model class, tablename is used to:

• Define database constraints

• Specify the table name in the database

• Create indexes automatically

• Generate foreign keys

Which method creates all tables defined in models?

• engine.create_all()

• Base.create_all()

• Base.metadata.create_all(engine)

• session.create_all()

Which of the following is NOT a common column constraint in SQLAlchemy?

• nullable=False

• unique=True

• default=

• compiled=True

What is a session in SQLAlchemy used for?

• Managing database connections and object states

• Installing database drivers

• Mapping Python objects to JSON

• Storing raw SQL strings