How does parameterized query help in preventing SQL Injection attacks?
- It escapes special characters in user input
- It encrypts SQL queries before execution
- It restricts SQL queries to a predefined set
- It validates SQL queries against a whitelist
A parameterized query helps prevent SQL Injection attacks by escaping special characters in user input. This ensures that user input is treated as data and not executable code. The other options do not accurately describe how parameterized queries work against SQL Injection.
In a test for a method that processes data retrieved from a database, how would you use stubbing to simulate different scenarios and edge cases related to data retrieval?
- Stub the entire database to return predefined data
- Stub only the network communication with the database
- Stub the method that retrieves data, returning different values
- Avoid stubbing and use the real database
When testing a method that processes data from a database, you should use stubbing to simulate different scenarios and edge cases related to data retrieval. This can be achieved by stubbing the method that retrieves data and having it return different values for each test scenario. Stubbing the entire database may lead to over-complicated tests, and avoiding stubbing by using the real database can result in unreliable and slow tests. Stubbing only network communication is not sufficient for simulating different scenarios related to data retrieval.
The Buffer class in Node.js is a global class and can be accessed in an application without importing the ______ module.
- fs
- net
- buffer
- http
The Buffer class in Node.js is available globally, so it can be accessed without importing any specific module. This is one of the unique features of the Buffer class in Node.js.
What command will uninstall a Node.js package?
- npm remove
- npm delete
- npm uninstall
- npm purge
To uninstall a Node.js package, you should use the npm uninstall command. This command removes the package from the current project. The other options are either incorrect or not the standard way to uninstall a package.
When defining dynamic routes in Express.js, using :param* will match ______ in the route path.
- param
- :param
- *param
- :param*
In Express.js, when defining dynamic routes, using :param* will match any characters after param in the route path and store them as a parameter in the request object. The other options do not represent the correct syntax for defining dynamic routes in Express.js.
In Express, which method is used to start a server listening for connections?
- app.listen()
- server.start()
- express.startServer()
- node.start()
In Express, you use the app.listen() method to start a server that listens for incoming connections. This method binds the server to a specified port and hostname, allowing it to handle HTTP requests. The other options are not valid methods for starting an Express server.
In JavaScript, the ______ property is used to set up inheritance between custom types.
- inherit
- prototype
- extend
- object
In JavaScript, the prototype property is used to set up inheritance between custom types. It allows one object to inherit properties and methods from another object. This is a fundamental concept in JavaScript's object-oriented programming model.
How can you ensure that a specific script in package.json runs only after another specified script has successfully completed?
- Using npm's pre and post scripts
- Using conditional statements in JavaScript
- It's not possible to achieve this in package.json
- By using a third-party package
In package.json, you can use pre and post scripts to define the order in which scripts should run. For example, if you want a script to run after another, you can use "pre": "npm run firstScript" and "post": "npm run secondScript". This ensures that secondScript runs after firstScript.
In Express.js, what does the next() function do in middleware?
- Ends the request-response cycle
- Sends an HTTP response
- Passes control to the next middleware function
- Logs a message to the console
In Express.js, the next() function is used in middleware to pass control to the next middleware function in the stack. It allows the request to continue processing through subsequent middleware functions. If you don't call next(), the request-response cycle may be terminated, and subsequent middleware or route handlers won't be executed.
Which of the following is a common technique used for implementing full-text search in databases?
- Regular Expressions
- Binary Search
- Inverted Index
- Depth-First Search
A common technique for implementing full-text search in databases is the use of an inverted index. This index stores a list of words or terms along with the locations where they appear in the documents, making it efficient for searching large volumes of text. Regular expressions, binary search, and depth-first search are not typically used for full-text search in databases.