40 questions for “SQL/Sequelize)”

Found in 1 field. Select a question to see its full answer.

Information Technology

40 questions in 1 technology

#QuestionTechnologyTopicLevel
1What is Mongoose, and what does it add on top of the raw MongoDB Node.js driver? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Node.jsDatabases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Beginner
2How does Sequelize define models and relationships for a relational (SQL) database in Node.js? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Node.jsDatabases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Intermediate
3How do you implement database transactions in Node.js using Sequelize to ensure multiple related writes succeed or fail together? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Node.jsDatabases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Intermediate
4What is a database migration, and how do tools like Sequelize's migration system or a standalone tool like Knex help manage schema changes over time? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Node.jsDatabases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Intermediate
5What is the N+1 query problem in the context of an ORM like Mongoose or Sequelize, and how do you avoid it? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Node.jsDatabases & ORMs (MongoDB/Mongoose, SQL/Sequelize)Advanced
6How should passwords be securely stored in a Node.js application's database, and why is bcrypt commonly used? Node.js › Authentication & AuthorizationNode.jsAuthentication & AuthorizationBeginner
7What is caching, and why is it commonly used to improve the performance of a Node.js application? Node.js › CachingNode.jsCachingBeginner
8What is the difference between a relational (SQL) database and a NoSQL database, and how does this affect a Node.js application's data layer? Node.js › DatabasesNode.jsDatabasesBeginner
9How do you connect a Node.js application to Redis using the official node-redis client? Node.js › Caching with RedisNode.jsCaching with RedisBeginner
10How would you set up a basic GraphQL server in Node.js using Apollo Server, and what are schema and resolvers? Node.js › GraphQL with Node.jsNode.jsGraphQL with Node.jsBeginner