Loading from databases in LangChain - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What does this LangChain database loader output?

Consider this LangChain code snippet that loads documents from a SQL database and prints the first document's content. What will be printed?

LangChain

from langchain.document_loaders import SQLDatabaseLoader
from langchain.sql_database import SQLDatabase

db = SQLDatabase.from_uri("sqlite:///example.db")
loader = SQLDatabaseLoader(db=db, table_name="users")
docs = loader.load()
print(docs[0].page_content)

A A list of all rows from the 'users' table printed as a list

B The content of the first row in the 'users' table as a string

C An error because 'load' method does not exist

D The database connection object printed as a string

💡 Hint

Remember that SQLDatabaseLoader loads rows as documents with page_content holding the row data.

The SQLDatabaseLoader loads each row from the specified table as a Document object. The 'page_content' attribute contains the row's data as a string. So printing docs[0].page_content shows the first row's content.

📝 Syntax

intermediate

Which option correctly initializes a LangChain loader for a PostgreSQL database?

You want to load documents from a PostgreSQL database named 'mydb' on localhost with user 'user' and password 'pass'. Which code snippet correctly creates the SQLDatabase and loader?

A

db = SQLDatabase.from_uri("postgresql://user:pass@localhost/mydb")
loader = SQLDatabaseLoader(db=db, table_name="documents")

B

db = SQLDatabase.from_uri("postgresql://user:pass@localhost/mydb")
loader = SQLDatabaseLoader(db=db, table="documents")

C

db = SQLDatabase.from_uri("postgresql://user:pass@localhost:5432/mydb")
loader = SQLDatabaseLoader(db=db, table_name="documents")

D

db = SQLDatabase.from_uri("postgres://user@localhost:pass/mydb")
loader = SQLDatabaseLoader(db=db, table="documents")

💡 Hint

The correct URI includes the port and the loader uses 'table_name' parameter.

Option C correctly specifies the PostgreSQL URI with port 5432 and uses 'table_name' parameter in SQLDatabaseLoader. Other options have wrong URI format or wrong parameter name.

🔧 Debug

advanced

Why does this LangChain database loader code raise an error?

Given this code snippet, why does it raise an AttributeError? from langchain.document_loaders import SQLDatabaseLoader from langchain.sql_database import SQLDatabase db = SQLDatabase.from_uri("sqlite:///example.db") loader = SQLDatabaseLoader(db=db) docs = loader.load()

A Because 'table_name' parameter is missing in SQLDatabaseLoader initialization

B Because 'load' method does not exist on SQLDatabaseLoader

C Because the database URI is invalid

D Because 'db' should be a connection string, not SQLDatabase object

💡 Hint

Check required parameters for SQLDatabaseLoader to know which table to load.

SQLDatabaseLoader requires the 'table_name' parameter to know which table to load. Omitting it causes an AttributeError when calling load().

❓ state_output

advanced

What is the length of the documents list after loading?

You run this code to load documents from a table with 3 rows: from langchain.document_loaders import SQLDatabaseLoader from langchain.sql_database import SQLDatabase db = SQLDatabase.from_uri("sqlite:///example.db") loader = SQLDatabaseLoader(db=db, table_name="notes") docs = loader.load() What is len(docs)?

A Raises an error

B 1

C 0

D 3

💡 Hint

Each row in the table becomes one Document in the list.

SQLDatabaseLoader.load() returns one Document per row in the specified table. Since the table has 3 rows, len(docs) is 3.

🧠 Conceptual

expert

Which statement best describes how LangChain's SQLDatabaseLoader handles database connections?

Select the most accurate description of how SQLDatabaseLoader manages connections when loading data from a database.

A SQLDatabaseLoader uses the SQLDatabase object which manages connection pooling internally, so connections are reused efficiently

B SQLDatabaseLoader requires the user to manually open and close the database connection before and after loading

C SQLDatabaseLoader opens a new connection for each load call and closes it automatically after loading

D SQLDatabaseLoader does not use any database connection; it only reads from local cache

💡 Hint

Think about how SQLDatabase abstracts connection management.

SQLDatabaseLoader relies on SQLDatabase which manages connections and pooling internally, allowing efficient reuse without manual connection handling.