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

Questions 6–10

1. 6foundation · easy

   What is the purpose of escaping variables in SQL queries?

   • ATo encrypt the data in the database
   • BTo compress the query string
   • CTo make the query run faster
   • DTo prevent syntax errors and SQL injection attacks
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the primary purpose of a primary key in a database table?

   • ATo store large text data
   • BTo speed up queries on non-key columns
   • CTo enforce a foreign key relationship
   • DTo uniquely identify each row in the table
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which of the following is a required characteristic of a primary key?

   • AIt must be unique for each row
   • BIt must be a single column
   • CIt must be auto-incremented
   • DIt must be an integer
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   In Node.js with the mysql package, what is the structure of the result passed to the callback for a SELECT query?

   • AAn array of objects, each representing a row
   • BA single object representing the first row only
   • CAn object with a single 'rows' property containing an array
   • DA JSON string containing the rows
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which method of a MySQL connection object in Node.js is used to execute a SQL query?

   • Asend()
   • Brun()
   • Cexecute()
   • Dquery()
   Reveal Solution Discussion Select an answer first