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

Questions 11–15

1. 11foundation · easy

   In the mysql package, which method is used to escape a value before including it in a SQL query?

   • Aconnection.clean()
   • Bconnection.sanitize()
   • Cconnection.encode()
   • Dconnection.escape()
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which of the following is a basic prevention method for SQL injection?

   • AUsing string concatenation to build queries
   • BUsing parameterized queries or prepared statements
   • CUsing only SELECT queries
   • DDisabling the database server
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   When executing a SQL query in Node.js using the mysql package, what does the callback function receive as its first argument?

   • AThe number of affected rows
   • BThe result rows
   • CThe connection object
   • DAn error object (or null if successful)
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Given a SELECT query result in Node.js, how do you access the value of a column named 'email' from the first row?

   • Aresult[0].get('email')
   • Bresult[0]['email']
   • Cresult.email
   • Dresult['email'][0]
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is SQL injection?

   • AA way to encrypt database connections
   • BA technique where an attacker inserts malicious SQL code into a query
   • CA method to speed up database queries
   • DA tool for database backup
   Reveal Solution Discussion Select an answer first