035.3 SQL Basics (weight: 3) WEB-DEVELOPMENT-ESSENTIALS Practice Questions (Page 4)

Questions 16–18

1. 16expert · hard

   A security auditor is reviewing a Node.js application that uses the mysql2 library. The application builds a query by concatenating a user-provided ID into a string: `SELECT * FROM users WHERE id = ${userId}`. The auditor recommends using a parameterized query. Which additional benefit does parameterization provide beyond preventing SQL injection?

   • AIt automatically encrypts the data in transit between the application and the database.
   • BIt can improve performance by allowing the database to reuse the query execution plan.
   • CIt ensures that the query results are cached in memory for faster subsequent access.
   • DIt automatically validates the data type of the user input before executing the query.
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A database administrator is designing a new 'orders' table. The table needs to store order data, and each order must be uniquely identifiable. The administrator is considering using a composite primary key consisting of (customer_id, order_date). Which concern is most important to evaluate before choosing this composite key?

   • AWhether the combination of customer_id and order_date is guaranteed to be unique for every order.
   • BWhether the order_date column can store NULL values for orders that are not yet dated.
   • CWhether the orders table will be referenced by a foreign key from another table.
   • DWhether the customer_id column is indexed separately for faster lookups.
   Reveal Solution Discussion Select an answer first
3. 18foundation · easy

   Which Node.js package is commonly used to connect to a MySQL database and provides a callback-based API for executing queries?

   • Apg-promise
   • Bmongoose
   • Cexpress
   • Dmysql
   Reveal Solution Discussion Select an answer first