Week 3-MySQL query time!

This week we learned how to use MySQL to make database queries, and link the workbench up to Google Cloud. I love data ❤

If a user attempts to create a resource that already exists — for example, an email address that’s already registered — what HTTP status code would you return? | Error 409, Already_Exists.

Consider a responsive site design that requires a full-width image in all responsive states. What would be the correct way to code this to ensure the page loads the smallest image required to fill the space? | Using a grid or flex-box in CSS one can set the image to a percentage of the page to fill the space. The height would be set to auto depending on the width of the image.

When should you npm and when yarn? | Yarn is a new package manager that runs faster than npm because it can perform multiple installation steps at once. Yarn, however, doesn’t work with any node.js version older than 5

How can you make sure your dependencies are safe? | Run an audit after install and then audit fix.

What are the differences between CHAR and VARCHAR data types? (MySQL) | VARCHAR is variable-length, and CHAR is fixed length.

How else can the JavaScript code below be written using Node.Js to produce the same output? console.log(“first”); setTimeout(function() { console.log(“second”); }, 0); console.log(“third”); // Output: // first // third // second |

console.log(“first”); setImmediate(() => { console.log(“second”); }); console.log(“third”);