Week 5

Which layer in a web application is responsible for displaying information to users?

• Business Logic Tier

• Data Tier

• Presentation Tier

• User Interface Tier

What does SQL stand for?

• Structured Query Language

• Standard Query List

• Both a) and b)

• Structured Query Logic

Which of the following is NOT a common task performed using SQL?

• Retrieving data from a database

• Updating data in a database

• Creating user accounts for a web application

• Running calculations on the data

What is the role of Node.js in this lesson's context?

• To design the user interface of the web application

• To manage the database itself

• To connect to the database and execute SQL queries

• To define the data structure within the database

What symbol is used to represent all columns in a SELECT query?

• * (asterisk)

• # (hash)

• $ (dollar sign)

• % (percent sign)

How can you filter expenses by category in a Node.js query?

• Include the category name directly in the query string (e.g., SELECT * FROM expenses WHERE category='Food')

• Use a separate variable to store the category and reference it within the query

• Both a) and b) are valid options

• Neither a) nor b) are valid options

Which of the following statements about error handling is true?

• Error handling can be ignored for simple queries.

• It's essential to implement error handling to catch potential connection or query issues.

• Node.js automatically handles all database errors.

• Error messages don't provide valuable information for debugging.

What is the purpose of the connection.end() method in Node.js?

• To establish a connection to the database

• To execute an SQL query

• To close the connection to the database (recommended practice)

• To retrieve data from the database

What library did we use as an example to connect to a MySQL database in Node.js?

• sql

• database

• mysql2

• mySQLConnector

When writing a Node.js query, where should you store your database credentials (username, password)?

• Directly within the query string (not recommended for security reasons)

• In a separate configuration file for better security practices.

• It doesn't matter as long as they are valid.

• Hardcoded within the Node.js script (not recommended).