All fields

“SQL/Sequelize)” in Information Technology

40 questions across 1 technology.

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
11What is job idempotency, and why is it critical when designing background job processing? Node.js › Background Jobs & QueuesNode.jsBackground Jobs & QueuesIntermediate
12How would you cache the result of a database query in Node.js while ensuring the cache is properly invalidated when the underlying data changes? Node.js › CachingNode.jsCachingIntermediate
13What is negative caching, and why might you deliberately cache the fact that a lookup returned 'not found'? Node.js › CachingNode.jsCachingIntermediate
14What is SQL injection, and how does using parameterized queries in Node.js prevent it? Node.js › DatabasesNode.jsDatabasesIntermediate
15What is the N+1 query problem, and how does it commonly arise in a Node.js application using an ORM? Node.js › DatabasesNode.jsDatabasesIntermediate
16What is the difference between a one-to-many and a many-to-many relationship in a relational database, and how is each modeled? Node.js › DatabasesNode.jsDatabasesIntermediate
17How does Docker Compose simplify local development for a Node.js application that depends on a database and a cache? Node.js › Docker & DeploymentNode.jsDocker & DeploymentIntermediate
18What is the try/catch/finally pattern's 'finally' block used for, and how does it behave with async/await? Node.js › Error HandlingNode.jsError HandlingIntermediate
19What is the difference between a validation error and a business-logic error, and how might a Node.js application handle each differently? Node.js › Error HandlingNode.jsError HandlingIntermediate
20How would you set up a basic GraphQL server in Node.js using Apollo Server, defining a schema and resolvers? Node.js › GraphQLNode.jsGraphQLIntermediate
21How would you implement 'Sign in with GitHub' using Passport's OAuth strategy in an Express application? Node.js › Authentication & Authorization (JWT, OAuth, Passport)Node.jsAuthentication & Authorization (JWT, OAuth, Passport)Intermediate
22What Redis data structures beyond simple string values are useful for a Node.js application, and what are they typically used for? Node.js › Caching with RedisNode.jsCaching with RedisIntermediate
23What is the Repository pattern, and how does it help decouple business logic from a specific database technology? Node.js › Architecture & Design PatternsNode.jsArchitecture & Design PatternsAdvanced
24What is the CQRS (Command Query Responsibility Segregation) pattern, and when is it appropriate to introduce in a Node.js system? Node.js › Architecture & Design PatternsNode.jsArchitecture & Design PatternsAdvanced
25What is Multi-Factor Authentication (MFA), and how would you implement Time-based One-Time Password (TOTP) support in a Node.js app? Node.js › Authentication & AuthorizationNode.jsAuthentication & AuthorizationAdvanced
26What is the principle of least privilege, and how does it apply to designing an authorization system for a multi-tenant Node.js SaaS application? Node.js › Authentication & AuthorizationNode.jsAuthentication & AuthorizationAdvanced
27What is job de-duplication in a queue system, and how would you prevent the same logical job from being enqueued multiple times? Node.js › Background Jobs & QueuesNode.jsBackground Jobs & QueuesAdvanced
28What are the main cache invalidation strategies (TTL, write-through, cache-aside), and when is each appropriate? Node.js › CachingNode.jsCachingAdvanced
29What is Redis's EXPIRE and how do TTL-based keys interact with Redis's own memory eviction policies under memory pressure? Node.js › CachingNode.jsCachingAdvanced
30How would you implement a write-behind (write-back) caching strategy, and what durability risk does it introduce? Node.js › CachingNode.jsCachingAdvanced
31What is a database transaction, and how would you implement one in Node.js to ensure multiple related writes either all succeed or all fail together? Node.js › DatabasesNode.jsDatabasesAdvanced
32How would you implement idempotent notification sending to avoid sending a duplicate email if a background job is retried? Node.js › Email & NotificationsNode.jsEmail & NotificationsAdvanced
33How would you design a notification preference center allowing users to control which types of notifications they receive via which channels? Node.js › Email & NotificationsNode.jsEmail & NotificationsAdvanced
34How would you process a very large CSV file in Node.js without loading the entire file into memory? Node.js › File System & File ProcessingNode.jsFile System & File ProcessingAdvanced
35How would you implement file locking in Node.js to prevent two processes from writing to the same file simultaneously? Node.js › File System & File ProcessingNode.jsFile System & File ProcessingAdvanced
36What is the N+1 query problem in GraphQL specifically, and how does DataLoader solve it? Node.js › GraphQLNode.jsGraphQLAdvanced
37How would you write automated tests for GraphQL resolvers in Node.js, testing them independently of the full HTTP/schema execution layer? Node.js › GraphQLNode.jsGraphQLAdvanced
38How does Docker Compose simplify running a Node.js application alongside its dependencies (like a database and Redis) during local development? Node.js › Docker & Containerization for Node.jsNode.jsDocker & Containerization for Node.jsAdvanced
39What is the N+1 query problem specific to GraphQL, and how does DataLoader solve it? Node.js › GraphQL with Node.jsNode.jsGraphQL with Node.jsAdvanced
40How does distributed data ownership work in microservices -- specifically, why shouldn't multiple services share direct access to the same database? Node.js › Microservices Architecture with Node.jsNode.jsMicroservices Architecture with Node.jsAdvanced