Crowdly

To execute SQL queries

To manage transactions

To define table structures

How do you create a new record in a SQLAlchemy Table object?

Execute an SQL INSERT statement using a SQLAlchemy Connection object

Call the create() method on the Table object

Create a new Python object and add it to the Table object

Call the insert() method on the Table object

What is SQLAlchemy?

An SQL query builder

A database management system

A programming language for managing databases

A Python library for managing SQL databases

What is the difference between a SQLAlchemy Session and a Connection?

A Session is used to query the database, while a Connection is used to execute transactions.

A Session is used to manage transactions, while a Connection is used to manage connections to the database.

A Session is used to execute transactions, while a Connection is used to query the database.

A Session is used to manage connections to the database, while a Connection is used to manage transactions.

Which of the following is NOT a benefit of using the SQLAlchemy ORM?

Increased database portability

Faster query execution

Improved code readability

Easier database schema migrations

What is the purpose of the SQLAlchemy ORM?

To create database connections

To execute SQL queries directly

To map Python objects to database tables

To manage transactions

Which of the following is a valid SQLAlchemy data type?

All of the above

INT

JSON

VARCHAR(50)

In root folder of project two files are located. There are helloFile.txt with some text and main.py with the next script.

What we obtain as result of script execution?

FileNotFoundError on first row.

The contents of the helloFile.txt file will be printed to the terminal.

No errors and no prints in terminal.

File helloFile will be created. In terminal will printed empty row.

In root folder of project only one file is located. It contains the next script

What we obtain as result of its execution?

Empty helloFile file.

File helloFile with writed string Hello world!

No Errors and no files as result

FileNotFoundError

What is the purpose of the following code in Python?

To demonstrate inheritance

To demonstrate overloading

To demonstrate overriding

To demonstrate encapsulation