Feedback collection and annotation in LangChain - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

Retrieve all feedback entries with annotations

Given a database table feedback with columns id, comment, and annotation, which SQL query returns all feedback comments along with their annotations?

A SELECT comment, annotation FROM feedback;

B SELECT id, comment FROM feedback WHERE annotation IS NOT NULL;

C SELECT * FROM feedback WHERE annotation IS NULL;

D SELECT annotation FROM feedback;

💡 Hint

Think about selecting both the comment and its annotation for all entries.

Option A selects both comment and annotation columns from all rows, which matches the requirement.

Option A filters only feedback without annotations.

Option A excludes annotations from the result.

Option A selects only annotations without comments.

🧠 Conceptual

intermediate

Understanding annotation storage in feedback systems

Why is it important to store annotations separately from the original feedback comments in a database?

A To allow multiple annotations per feedback without changing the original comment.

B To prevent users from submitting feedback.

C To make feedback comments unreadable without annotations.

D To reduce the size of the database by splitting data.

💡 Hint

Think about how annotations might be added or changed over time.

Storing annotations separately allows adding multiple notes or updates without altering the original feedback, preserving its integrity.

Options A, B, and C do not reflect practical reasons for separate storage.

📝 Syntax

advanced

Identify the correct SQL syntax to update a feedback annotation

Which SQL statement correctly updates the annotation of a feedback entry with id = 5 to 'Reviewed and approved'?

A CHANGE feedback annotation TO 'Reviewed and approved' WHERE id = 5;

B MODIFY feedback SET annotation = 'Reviewed and approved' WHERE id = 5;

C UPDATE feedback SET annotation = 'Reviewed and approved' WHERE id = 5;

D UPDATE feedback WHERE id = 5 SET annotation = 'Reviewed and approved';

💡 Hint

Recall the standard SQL syntax for updating records.

Option C uses the correct UPDATE ... SET ... WHERE ... syntax.

Options A, B, and D use invalid or incorrect SQL syntax.

❓ optimization

advanced

Optimizing feedback annotation queries

You have a large feedback table with millions of rows. Which approach will optimize queries filtering feedback by annotation status?

A Store annotations in a separate text file outside the database.

B Create an index on the <code>annotation</code> column.

C Remove the <code>annotation</code> column to speed up queries.

D Use SELECT * without WHERE clause to avoid filtering overhead.

💡 Hint

Think about how databases speed up searches on specific columns.

Creating an index on the annotation column helps the database quickly find rows matching annotation filters.

Options B, C, and D either reduce functionality or increase workload.

🔧 Debug

expert

Debugging a feedback annotation insertion error

Given the table feedback with columns id (auto-increment), comment (text), and annotation (text), which INSERT statement will cause an error?

Assume id is auto-generated and should not be manually inserted.

A INSERT INTO feedback (comment, annotation) VALUES ('Great app', 'Positive');

B INSERT INTO feedback (id, comment, annotation) VALUES (NULL, 'Needs improvement', 'Negative');

C INSERT INTO feedback (comment) VALUES ('No annotation yet');

D INSERT INTO feedback (id, comment) VALUES (10, 'Manual id insertion');

💡 Hint

Consider how auto-increment columns behave when manually inserting values.

Option D tries to manually insert a value into the auto-increment id column, which can cause a conflict or error depending on database settings.

Option D inserts NULL for id, which is allowed to trigger auto-increment.

Options B, C, and D are valid inserts.

Practice

1. What is the main purpose of feedback collection in a database?

easy

A. To speed up database queries

B. To delete old user data automatically

C. To store user opinions for later review

D. To create user accounts

Solution

1. Step 1: Understand feedback collection

   Feedback collection means saving what users say or think about something.

2. Step 2: Identify the purpose in database context

   In databases, feedback is stored so it can be reviewed or analyzed later.

3. Final Answer:

   To store user opinions for later review -> Option C

4. Quick Check:

   Feedback collection = store opinions [OK]

Hint: Feedback stores user opinions, not deletes or speeds queries [OK]

Common Mistakes:

• Confusing feedback with user account data
• Thinking feedback speeds up queries
• Assuming feedback deletes old data

2. Which SQL command correctly creates a table named feedback with columns id (integer) and comment (text)?

easy

A. CREATE feedback TABLE (id INT, comment TEXT);

B. CREATE TABLE feedback (id INT, comment TEXT);

C. MAKE TABLE feedback (id INTEGER, comment STRING);

D. TABLE CREATE feedback (id INT, comment TEXT);

Solution

1. Step 1: Recall correct SQL syntax for table creation

   The correct syntax starts with CREATE TABLE, followed by table name and columns with types.

2. Step 2: Check each option for syntax correctness

   CREATE TABLE feedback (id INT, comment TEXT); uses correct keywords and types. Others have wrong keywords or order.

3. Final Answer:

   CREATE TABLE feedback (id INT, comment TEXT); -> Option B

4. Quick Check:

   CREATE TABLE + columns = CREATE TABLE feedback (id INT, comment TEXT); [OK]

Hint: CREATE TABLE is the right start for making tables [OK]

Common Mistakes:

• Using MAKE TABLE instead of CREATE TABLE
• Wrong order of keywords
• Using STRING instead of TEXT for text columns

3. Given the table feedback with columns id and comment, what will this query return?

SELECT comment FROM feedback WHERE id = 2;

medium

A. Only the comment text where id equals 2

B. An error because id is not selected

C. All ids and comments

D. All comments with id 2

Solution

1. Step 1: Understand the SELECT statement

   The query asks for the comment column only, filtering rows where id equals 2.

2. Step 2: Determine what is returned

   Only the comment text for the row with id 2 is returned, not all comments or ids.

3. Final Answer:

   Only the comment text where id equals 2 -> Option A

4. Quick Check:

   SELECT comment WHERE id=2 = Only the comment text where id equals 2 [OK]

Hint: SELECT column filters output columns, WHERE filters rows [OK]

Common Mistakes:

• Thinking all comments with id 2 means multiple rows
• Expecting id column in output when not selected
• Assuming syntax error due to missing id in SELECT

4. Identify the error in this SQL statement for inserting feedback:

INSERT INTO feedback (id, comment) VALUES 1, 'Great service';

medium

A. Missing parentheses around VALUES

B. Wrong table name

C. Missing semicolon

D. Using single quotes instead of double quotes

Solution

1. Step 1: Review correct INSERT syntax

   VALUES must be followed by parentheses enclosing the values to insert.

2. Step 2: Check the given statement

   The statement lacks parentheses around 1, 'Great service' after VALUES.

3. Final Answer:

   Missing parentheses around VALUES -> Option A

4. Quick Check:

   VALUES requires parentheses [OK]

Hint: Always put parentheses around VALUES in INSERT [OK]

Common Mistakes:

• Forgetting parentheses after VALUES
• Confusing quotes for strings
• Assuming semicolon is mandatory for error

5. You want to label feedback comments as 'positive' or 'negative' in a new column annotation. Which SQL command correctly adds this column to the feedback table?

hard

A. INSERT COLUMN annotation INTO feedback;

B. UPDATE feedback ADD annotation TEXT;

C. CREATE COLUMN annotation TEXT IN feedback;

D. ALTER TABLE feedback ADD COLUMN annotation TEXT;

Solution

1. Step 1: Understand how to add a new column

   To add a column, use ALTER TABLE with ADD COLUMN and specify the type.

2. Step 2: Check each option's correctness

   ALTER TABLE feedback ADD COLUMN annotation TEXT; uses correct syntax. Others use invalid commands or order.

3. Final Answer:

   ALTER TABLE feedback ADD COLUMN annotation TEXT; -> Option D

4. Quick Check:

   ALTER TABLE + ADD COLUMN = ALTER TABLE feedback ADD COLUMN annotation TEXT; [OK]

Hint: Use ALTER TABLE ADD COLUMN to add new columns [OK]

Common Mistakes:

• Using UPDATE instead of ALTER TABLE
• Trying to CREATE COLUMN separately
• Using INSERT COLUMN which is invalid