Full-Stack Development Certification — Questions and Answers
Question 1: What does 'test coverage' primarily measure?
- Number of test cases written
- Percentage of code executed by tests (Correct answer)
- Number of bugs found per test
- Time taken to run the test suite
Correct answer: Percentage of code executed by tests
Test coverage measures the percentage of source code lines, branches, or paths that are exercised during test execution.
Question 2: When should you use `expect.assertions(n)` in a Jest async test?
- To skip assertions if a condition is not met
- To set the timeout for the async operation
- To run assertions in parallel for performance
- To ensure a specific number of assertions ran, catching cases where async callbacks were never called (Correct answer)
Correct answer: To ensure a specific number of assertions ran, catching cases where async callbacks were never called
`expect.assertions(n)` prevents silent test passes when async callbacks are never invoked by requiring exactly n assertions to have been called.
Question 3: What is a 'Definition of Done' and why does it matter for stakeholder communication?
- A list of tasks the developer personally considers complete
- The date the feature was merged into the main branch
- A shared, agreed-upon checklist that both the team and stakeholders use to determine if a feature is truly finished (Correct answer)
- A project manager's sign-off email
Correct answer: A shared, agreed-upon checklist that both the team and stakeholders use to determine if a feature is truly finished
A shared Definition of Done prevents misaligned interpretations of 'complete' and reduces last-minute rejection of delivered work.
Question 4: What is the Virtual DOM in React?
- A DOM stored in a database
- A shadow DOM implementation
- An in-memory representation of the real DOM used to batch and optimize updates (Correct answer)
- A virtual machine that runs the DOM
Correct answer: An in-memory representation of the real DOM used to batch and optimize updates
React maintains a virtual DOM in memory, diffs it with the previous version, and only applies the minimum necessary changes to the real DOM.
Question 5: Which React hook is used to perform side effects such as data fetching or subscriptions in a functional component?
- useState
- useReducer
- useEffect (Correct answer)
- useContext
Correct answer: useEffect
useEffect runs after every render by default and is used for side effects like API calls, subscriptions, and DOM mutations.
Question 6: Which SQL command is used to remove all rows from a table without logging individual row deletions, making it faster than DELETE?
- DROP TABLE
- DELETE FROM
- REMOVE FROM
- TRUNCATE TABLE (Correct answer)
Correct answer: TRUNCATE TABLE
TRUNCATE TABLE removes all rows with minimal transaction log usage compared to DELETE, making it significantly faster for clearing large tables.
Question 7: What does the Angular CLI command `ng generate component header` do?
- Installs the Angular header package
- Creates a new component with its template, styles, spec, and module declaration (Correct answer)
- Compiles the header component for production
- Generates a routing module for the header
Correct answer: Creates a new component with its template, styles, spec, and module declaration
ng generate component creates the .ts, .html, .css, and .spec.ts files and automatically declares the component in the nearest module.
Question 8: In Vue 3, which Composition API function creates a reactive reference to a primitive value?
- ref() (Correct answer)
- computed()
- watch()
- reactive()
Correct answer: ref()
ref() wraps a primitive value in a reactive object, accessible via .value in script and auto-unwrapped in templates.
Question 9: What is the primary difference between a clustered and a non-clustered index?
- Non-clustered indexes are faster for all query types
- A clustered index determines the physical order of data in the table; non-clustered does not (Correct answer)
- Clustered indexes are stored in RAM; non-clustered are on disk
- Clustered indexes can only be created on primary keys
Correct answer: A clustered index determines the physical order of data in the table; non-clustered does not
A clustered index physically reorders table rows to match the index order, while a non-clustered index is a separate structure that points to the actual row data.
Question 10: Which normal form eliminates partial dependencies on a composite primary key?
- Second Normal Form (2NF) (Correct answer)
- Boyce-Codd Normal Form (BCNF)
- Third Normal Form (3NF)
- First Normal Form (1NF)
Correct answer: Second Normal Form (2NF)
2NF removes partial dependencies, ensuring every non-key attribute is fully dependent on the entire composite primary key.
Question 11: Which CSS layout model uses a two-dimensional grid of rows and columns to position elements?
- Float layout
- CSS Grid (Correct answer)
- Flexbox
- CSS Multi-column
Correct answer: CSS Grid
CSS Grid is a two-dimensional layout system that lets developers define both rows and columns to precisely place and align elements.
Question 12: What is the CAP theorem in distributed databases?
- A protocol for encrypting database connections
- The principle that a distributed system can only guarantee two of: Consistency, Availability, Partition tolerance (Correct answer)
- A formula for calculating optimal cache size
- A rule for normalizing database schemas
Correct answer: The principle that a distributed system can only guarantee two of: Consistency, Availability, Partition tolerance
The CAP theorem states that in a distributed data store, you can only simultaneously guarantee two out of three properties: Consistency, Availability, and Partition tolerance.
Question 13: In Git, what command merges a feature branch into the current branch while preserving a linear commit history via replay?
- git rebase (Correct answer)
- git stash
- git merge
- git cherry-pick
Correct answer: git rebase
git rebase replays commits from one branch on top of another, creating a linear history without a merge commit.
Question 14: Which of the following traits improves a full-stack developer?
- React, Javascript, Node.js
- Java, Spring Boot, Angular
- Ability to learn new skills quickly, Problem solving talents (Correct answer)
- MongoDB, Express, Angular, Node.js
Correct answer: Ability to learn new skills quickly, Problem solving talents
Explanation: <br> The ability to learn new skills quickly and problem-solving talents are essential for a full-stack developer. In addition, other skills that can make a full-stack developer better include strong programming fundamentals, good knowledge of front-end and back-end technologies, proficiency in multiple programming languages, experience in using different databases, familiarity with version control systems like Git, good communication skills, ability to work in a team, and an understanding of software development principles and best practices.
Question 15: What is an ORM (Object-Relational Mapper) used for in full-stack development?
- Replicating data across multiple database servers
- Optimizing SQL query execution plans
- Mapping database tables to programming language objects to simplify data access (Correct answer)
- Compressing database backups
Correct answer: Mapping database tables to programming language objects to simplify data access
An ORM abstracts database interactions by mapping tables to classes and rows to objects, allowing developers to query databases using their programming language instead of raw SQL.
Question 16: Which file format does GitHub Actions use to define CI/CD workflows?
- JSON (.json)
- YAML (.yml) (Correct answer)
- XML (.xml)
- TOML (.toml)
Correct answer: YAML (.yml)
GitHub Actions workflows are defined in YAML files stored in .github/workflows/, specifying triggers, jobs, and steps for automated pipelines.
Question 17: Which tool is most commonly used to bundle JavaScript modules in modern React applications?
- Prettier
- Babel
- ESLint
- Webpack (Correct answer)
Correct answer: Webpack
Webpack is the default bundler used by Create React App, combining modules, assets, and dependencies into optimized bundles.
Question 18: What is tree-shaking in the context of modern JavaScript bundlers?
- Eliminating dead code (unused exports) from the final bundle at build time (Correct answer)
- Restructuring the component tree for better rendering performance
- Shaking out race conditions in asynchronous code
- Recursively traversing the DOM to remove unused elements
Correct answer: Eliminating dead code (unused exports) from the final bundle at build time
Tree-shaking statically analyzes ES module imports and removes any exported code that is never imported, reducing bundle size.
Question 19: What is the difference between a Docker image and a Docker container?
- Images are for Linux; containers are for Windows
- Images store data; containers store code
- An image is a static blueprint; a container is a running instance of that image (Correct answer)
- Images run in the cloud; containers run locally
Correct answer: An image is a static blueprint; a container is a running instance of that image
A Docker image is an immutable snapshot of the filesystem and configuration, while a container is a live, running process created from that image.
Question 20: When a colleague's pull request has a major architectural flaw, the most professional code review approach is to:
- Comment with a specific explanation of the issue and suggest an alternative approach (Correct answer)
- Rewrite the entire PR yourself
- Approve it to avoid conflict and log a tech debt ticket
- Reject it without explanation to save time
Correct answer: Comment with a specific explanation of the issue and suggest an alternative approach
Professional code reviews provide specific, constructive feedback with alternatives to help colleagues improve and unblock the work.
Question 21: In Tailwind CSS, what does the utility class `md:flex` mean?
- Apply medium-strength flexbox settings
- Apply flex layout on screens 768px and wider (Correct answer)
- Apply flex layout only on small screens
- Add a medium gap between flex children
Correct answer: Apply flex layout on screens 768px and wider
Tailwind uses responsive prefixes like md: to apply utilities only when the viewport meets the corresponding breakpoint (≥768px by default).
Question 22: What SQL clause is used to filter results after a GROUP BY aggregation?
- LIMIT
- FILTER
- HAVING (Correct answer)
- WHERE
Correct answer: HAVING
HAVING filters groups after aggregation, while WHERE filters rows before grouping occurs.
Question 23: Which React API is used to avoid prop drilling by sharing state across many components without passing props explicitly?
- useRef
- Context API (Correct answer)
- useCallback
- useMemo
Correct answer: Context API
React's Context API creates a global store accessible by any component in the tree via useContext, eliminating the need to pass props through every level.
Question 24: What is the purpose of environment variables in a deployed application?
- To configure the shell environment of the developer's machine
- To store configuration values like API keys and database URLs separately from code, enabling the same code to run in different environments (Correct answer)
- To set hardware resource limits for the process
- To define CSS variables for theming
Correct answer: To store configuration values like API keys and database URLs separately from code, enabling the same code to run in different environments
Environment variables externalize configuration from code, allowing the same Docker image or build artifact to behave differently in dev, staging, and production by injecting environment-specific values at runtime.
Question 25: What is a database view?
- A visual diagram of the database schema
- A read-only replica of the main database
- A virtual table defined by a SQL query that can be queried like a regular table (Correct answer)
- A cached snapshot of query results stored on disk
Correct answer: A virtual table defined by a SQL query that can be queried like a regular table
A view is a stored SQL query that acts like a virtual table, allowing complex queries to be simplified and reused without duplicating data.
Question 26: What does a 'spy' test double do differently from a 'stub'?
- Spies record calls and arguments while optionally delegating to the real implementation; stubs just return preset values (Correct answer)
- There is no practical difference between spies and stubs
- Spies replace the real function; stubs do not
- Stubs record calls; spies only replace return values
Correct answer: Spies record calls and arguments while optionally delegating to the real implementation; stubs just return preset values
A spy wraps the real function to record call metadata, whereas a stub replaces the function with a fixed-return implementation.
Question 27: In software research, what is the difference between internal validity and external validity?
- Internal validity applies to unit tests; external validity applies to integration tests
- Internal validity concerns sample size; external validity concerns p-values
- Internal validity means the study measures what it claims; external validity means findings generalize to other contexts (Correct answer)
- They are synonyms for reliability and validity respectively
Correct answer: Internal validity means the study measures what it claims; external validity means findings generalize to other contexts
Internal validity asks 'did we measure the right thing correctly?' while external validity asks 'do these results apply beyond this study's conditions?'
Question 28: A team uses feature flags to gradually roll out a new checkout flow to 5% of users. This is an example of which risk management technique?
- Risk mitigation through controlled exposure (Correct answer)
- Risk avoidance
- Risk acceptance
- Risk transfer
Correct answer: Risk mitigation through controlled exposure
Canary releases via feature flags limit blast radius by exposing new code to a small subset of users, reducing potential impact.
Question 29: Which state management library uses a single immutable state tree and pure reducer functions?
- Recoil
- MobX
- Zustand
- Redux (Correct answer)
Correct answer: Redux
Redux enforces a single source of truth with a read-only state tree modified only by pure reducer functions dispatched via actions.
Question 30: What is the primary purpose of maintaining an Architecture Decision Record (ADR)?
- To document the context, decision, and consequences so future developers understand why choices were made (Correct answer)
- To satisfy compliance auditors
- To replace code comments
- To track sprint velocity
Correct answer: To document the context, decision, and consequences so future developers understand why choices were made
ADRs preserve the reasoning behind architectural decisions, preventing future teams from revisiting settled debates without new evidence.
Question 31: When documenting an API for external developers (third-party consumers), which element is most commonly overlooked but critically important?
- The database schema behind the endpoints
- Error response formats with meaningful codes and descriptions (Correct answer)
- The list of HTTP methods supported
- The programming language used in the backend
Correct answer: Error response formats with meaningful codes and descriptions
Detailed error response documentation helps consumers handle failures gracefully, which is frequently omitted despite being critical for integration success.
Question 32: When designing a many-to-many relationship in a relational database, what is the standard approach?
- Store a JSON array of related IDs in one of the tables
- Duplicate rows in both tables to represent each relationship
- Create a junction (bridge) table with foreign keys to both related tables (Correct answer)
- Use a BLOB column to store serialized relationship data
Correct answer: Create a junction (bridge) table with foreign keys to both related tables
A junction table (also called a bridge or associative table) holds foreign keys referencing both related tables, properly representing the many-to-many relationship in normalized form.
Question 33: What does HTTPS provide that plain HTTP does not?
- Authentication of the client's identity
- Compression of all transmitted assets
- Encryption via TLS, ensuring data confidentiality and integrity between client and server (Correct answer)
- Faster data transfer speeds
Correct answer: Encryption via TLS, ensuring data confidentiality and integrity between client and server
HTTPS uses TLS to encrypt traffic, preventing eavesdroppers from reading or tampering with data in transit between the browser and server.
Question 34: What D3 JS selector techniques are there?
- Select()
- All of these (Correct answer)
- Append()
- Html()
Correct answer: All of these
D3.js utilizes several fundamental selector and manipulation techniques to interact with the Document Object Model (DOM). `select()` and `selectAll()` are used to choose elements, while `append()` is used to add new elements to the selection. Additionally, `html()` is a method used to get or set the inner HTML content of selected elements. All these methods are essential for dynamically creating and updating visualizations based on data.
Question 35: What is the purpose of regular risk reviews in Full-Stack Development practice?
- To identify new risks, evaluate control effectiveness, and update mitigation strategies (Correct answer)
- To satisfy auditors only
- To generate reports
- To reduce workload
Correct answer: To identify new risks, evaluate control effectiveness, and update mitigation strategies
This is fundamental to Full-Stack Development practice. To identify new risks, evaluate control effectiveness, and update mitigation strategies represents the professional standard for risk management in the Full-Stack Development certification framework.
Question 36: What is the purpose of a database index?
- To automatically backup table data
- To speed up data retrieval operations at the cost of additional storage (Correct answer)
- To encrypt sensitive columns
- To enforce referential integrity between tables
Correct answer: To speed up data retrieval operations at the cost of additional storage
Indexes create a data structure that enables the database engine to locate rows faster, trading storage space for query performance.
Question 37: What is a 'controlled component' in React forms?
- A form validated by an external library
- A component managed by the Angular control flow
- A component wrapped in React.memo to control re-renders
- A form element whose value is driven by React state (Correct answer)
Correct answer: A form element whose value is driven by React state
In a controlled component, form input values are stored in React state and updated via onChange handlers, making React the single source of truth.
Question 38: What is the main advantage of code splitting in a React application?
- It enables server-side rendering
- It reduces initial bundle size by loading code only when needed (Correct answer)
- It separates business logic from UI components
- It splits CSS from JavaScript
Correct answer: It reduces initial bundle size by loading code only when needed
Code splitting with React.lazy and dynamic import() defers loading of non-critical modules until they are actually needed, improving initial load time.
Question 39: What does the React hook `useMemo` primarily help with?
- Persisting values across component unmounts
- Synchronizing state with localStorage
- Memoizing expensive computed values to avoid recalculation on every render (Correct answer)
- Memoizing callback functions to maintain referential equality
Correct answer: Memoizing expensive computed values to avoid recalculation on every render
useMemo caches the result of an expensive computation and only recalculates when its dependencies change, preventing unnecessary work on re-renders.
Question 40: Which caching strategy serves a cached response immediately and then updates the cache in the background from the network?
- Network-first
- Stale-while-revalidate (Correct answer)
- Cache-only
- Cache-first
Correct answer: Stale-while-revalidate
Stale-while-revalidate returns the cached (potentially stale) response instantly while simultaneously fetching a fresh version for the next request.
Question 41: What does the principle of 'least privilege' mean in backend security?
- Users should have the fewest possible UI permissions
- APIs should restrict the number of fields returned
- Administrators should use non-admin accounts by default
- Each component or user should have only the minimum permissions needed to perform its function (Correct answer)
Correct answer: Each component or user should have only the minimum permissions needed to perform its function
Least privilege limits damage from breaches or bugs by ensuring that a compromised component or account can only access what it absolutely needs.
Question 42: What is a JWT (JSON Web Token) primarily used for in a full-stack application?
- Compressing API response payloads
- Encrypting database passwords
- Storing session data server-side
- Transmitting claims securely between parties for authentication/authorization (Correct answer)
Correct answer: Transmitting claims securely between parties for authentication/authorization
JWTs encode claims in a signed, compact token so servers can verify identity without storing session state.
Question 43: In component-driven development, what is the purpose of 'prop drilling'?
- A technique to optimize rendering by memoizing props
- Passing data through intermediate components that don't use it to reach a deeply nested child (Correct answer)
- Injecting services into components via dependency injection
- Drilling holes in DOM nodes for event bubbling
Correct answer: Passing data through intermediate components that don't use it to reach a deeply nested child
Prop drilling refers to threading props through multiple layers of components solely to pass data to a deeply nested component that actually needs it.
Question 44: Which PostgreSQL feature allows you to store and query JSON data natively?
- XML column with XPATH queries
- BLOB column type
- JSONB column type (Correct answer)
- TEXT column with manual parsing
Correct answer: JSONB column type
PostgreSQL's JSONB type stores JSON in a binary format that supports indexing and efficient querying, making it ideal for semi-structured data.
Question 45: What is the goal of Continuous Integration (CI) in software development?
- Automatically building and testing code on every commit to detect integration issues early (Correct answer)
- Continuously integrating third-party APIs into the codebase
- Monitoring production application uptime continuously
- Deploying code to production on every merge
Correct answer: Automatically building and testing code on every commit to detect integration issues early
CI pipelines automatically run builds and tests whenever code is pushed, giving teams fast feedback and catching bugs before they reach the main branch.
Question 46: How has digital technology transformed Full-Stack Development practice?
- It has had no impact
- It only affects large organizations
- It has replaced all traditional methods
- It has enhanced data collection, analysis, communication, and operational efficiency (Correct answer)
Correct answer: It has enhanced data collection, analysis, communication, and operational efficiency
This is fundamental to Full-Stack Development practice. It has enhanced data collection, analysis, communication, and operational efficiency represents the professional standard for technology in the Full-Stack Development certification framework.
Question 47: What is the purpose of a `.dockerignore` file?
- To exclude files and directories from being copied into the Docker image during the build (Correct answer)
- To ignore Docker version warnings
- To specify which containers Docker should not start
- To block certain Docker commands from running
Correct answer: To exclude files and directories from being copied into the Docker image during the build
.dockerignore works like .gitignore, preventing files like node_modules or .env from being included in the build context sent to the Docker daemon, keeping images smaller and more secure.
Question 48: What is the purpose of the CSS `rem` unit?
- A relative unit based on the root element's font size (Correct answer)
- An absolute unit equal to 1 pixel
- A viewport-relative unit based on screen height
- A relative unit based on the parent element's font size
Correct answer: A relative unit based on the root element's font size
rem (root em) is relative to the font size of the HTML root element, making it consistent regardless of nesting depth unlike the em unit.
Question 49: What is the consequence of non-compliance for Full-Stack Development professionals?
- No significant consequences
- Potential fines, license revocation, legal liability, and reputational damage (Correct answer)
- Just additional paperwork
- Only verbal warnings
Correct answer: Potential fines, license revocation, legal liability, and reputational damage
This is fundamental to Full-Stack Development practice. Potential fines, license revocation, legal liability, and reputational damage represents the professional standard for regulatory in the Full-Stack Development certification framework.
Question 50: In database design, what is a foreign key?
- A column that references the primary key of another table (Correct answer)
- A composite key made from multiple columns
- An encrypted version of the primary key
- A key that uniquely identifies each row in a table
Correct answer: A column that references the primary key of another table
A foreign key is a column (or set of columns) in one table that references the primary key of another table, enforcing referential integrity.
Question 51: What is the event loop in Node.js and why does blocking it cause problems?
- A background thread for CPU-intensive tasks; blocking it degrades memory
- A single-threaded mechanism that processes I/O callbacks; blocking it halts all request handling (Correct answer)
- A scheduler for cron jobs; blocking it delays scheduled tasks only
- A loop that polls the database every second; blocking it stops data refresh
Correct answer: A single-threaded mechanism that processes I/O callbacks; blocking it halts all request handling
Node.js uses a single event loop thread; synchronous CPU-bound code blocks it and prevents any other requests from being processed.
Question 52: What does a 'load test' specifically measure compared to a 'stress test'?
- Load tests find breaking points; stress tests measure expected-traffic performance
- Load tests measure frontend performance; stress tests measure backend performance
- Load tests measure system behavior under expected traffic; stress tests push beyond capacity to find breaking points (Correct answer)
- They are identical tests with different names
Correct answer: Load tests measure system behavior under expected traffic; stress tests push beyond capacity to find breaking points
Load testing validates performance under anticipated production traffic, while stress testing intentionally exceeds capacity to find failure modes and recovery behavior.
Question 53: A team implements automated dependency scanning in their CI pipeline using tools like Snyk or Dependabot. This primarily addresses which risk category?
- Performance degradation risk
- Third-party library vulnerability risk (Correct answer)
- Database schema drift risk
- UI regression risk
Correct answer: Third-party library vulnerability risk
Automated dependency scanning continuously monitors for known CVEs in third-party packages, directly addressing supply chain vulnerability risk.
Question 54: How do Full-Stack Development professionals build trust with clients or stakeholders?
- Through competitive pricing only
- Through consistent competence, transparency, reliability, and ethical behavior (Correct answer)
- Through marketing only
- By always agreeing with clients
Correct answer: Through consistent competence, transparency, reliability, and ethical behavior
This is fundamental to Full-Stack Development practice. Through consistent competence, transparency, reliability, and ethical behavior represents the professional standard for communication in the Full-Stack Development certification framework.
Question 55: What does the SOLID principle 'Open/Closed Principle' mean for a full-stack developer?
- Software entities should be open for extension but closed for modification (Correct answer)
- Functions should be open for reading but closed for writing
- APIs should be open to all users but closed to anonymous requests
- Code should be open-source and closed to licensing restrictions
Correct answer: Software entities should be open for extension but closed for modification
The Open/Closed Principle states that you should add new behavior by extending code rather than modifying existing, tested code.
Question 56: In a single-page application (SPA), what is the role of a client-side router such as React Router?
- It compiles TypeScript to JavaScript
- It sends requests to multiple backend servers
- It intercepts URL changes and renders the appropriate component without a full page reload (Correct answer)
- It caches API responses in the browser
Correct answer: It intercepts URL changes and renders the appropriate component without a full page reload
Client-side routers listen for URL changes and swap rendered components, enabling navigation without network round-trips for new HTML.
Question 57: What does 'mobile-first' CSS design mean?
- Writing CSS only for mobile devices and ignoring desktop
- Using max-width media queries to strip out desktop styles on mobile
- Writing base styles for small screens and adding complexity with min-width media queries (Correct answer)
- Building a separate mobile site at a different URL
Correct answer: Writing base styles for small screens and adding complexity with min-width media queries
Mobile-first means the default CSS targets small screens, and min-width media queries progressively enhance the layout for larger screens.
Question 58: What is the difference between Continuous Delivery and Continuous Deployment?
- They are the same term used interchangeably
- Continuous Delivery deploys to production; Continuous Deployment stops at staging
- Continuous Delivery automates up to a manual approval gate; Continuous Deployment deploys to production automatically without manual approval (Correct answer)
- Continuous Delivery covers testing; Continuous Deployment covers building
Correct answer: Continuous Delivery automates up to a manual approval gate; Continuous Deployment deploys to production automatically without manual approval
Continuous Delivery ensures code is always releasable and may require a human click to deploy; Continuous Deployment goes further by automatically deploying every passing build to production.
Question 59: What is the main role of a CSS preprocessor like SASS?
- To compile HTML templates into JavaScript
- To extend CSS with variables, nesting, mixins, and functions that compile to standard CSS (Correct answer)
- To auto-prefix CSS properties for browser compatibility
- To optimize and minify CSS for production
Correct answer: To extend CSS with variables, nesting, mixins, and functions that compile to standard CSS
SASS adds programming constructs like variables, nesting, and mixins to CSS, which are compiled into standard CSS before deployment.
Question 60: In SQL, what is the difference between `INNER JOIN` and `LEFT JOIN`?
- INNER JOIN works on indexed columns only; LEFT JOIN works on all columns
- They are identical in behavior
- INNER JOIN returns only matching rows; LEFT JOIN returns all rows from the left table including unmatched (Correct answer)
- INNER JOIN returns all rows from both tables; LEFT JOIN returns only matching rows
Correct answer: INNER JOIN returns only matching rows; LEFT JOIN returns all rows from the left table including unmatched
INNER JOIN returns only rows where there is a match in both tables, while LEFT JOIN returns all rows from the left table and matched rows from the right.
Question 61: Which database isolation level prevents dirty reads but still allows non-repeatable reads?
- Read Committed (Correct answer)
- Repeatable Read
- Serializable
- Read Uncommitted
Correct answer: Read Committed
Read Committed ensures a transaction only reads committed data (no dirty reads), but another transaction can modify data between reads within the same transaction.
Question 62: What is the primary use case for AWS S3?
- Running containerized microservices
- Managing DNS records and domain routing
- Hosting relational databases
- Storing and serving static files, images, backups, and large objects at scale (Correct answer)
Correct answer: Storing and serving static files, images, backups, and large objects at scale
Amazon S3 is an object storage service optimized for storing unstructured files like images, videos, backups, and static website assets with high durability and availability.
Question 63: What is a CDN (Content Delivery Network) and how does it benefit a full-stack application?
- A globally distributed network of edge servers that cache and serve static content from locations closer to users, reducing latency (Correct answer)
- A private network for database replication across regions
- A DNS provider that routes users to the fastest available server
- A container orchestration system for globally distributed apps
Correct answer: A globally distributed network of edge servers that cache and serve static content from locations closer to users, reducing latency
CDNs cache static assets (images, JS, CSS) at geographically distributed edge nodes, so users download content from a nearby server rather than a distant origin, improving load times.
Question 64: In MongoDB, what is the equivalent of a table in a relational database?
- Document
- Collection (Correct answer)
- Schema
- Index
Correct answer: Collection
In MongoDB, a collection is a grouping of documents analogous to a table in relational databases, though collections have no enforced schema by default.
Question 65: Which of the following best describes 'server-side rendering' (SSR)?
- The browser builds the HTML using JavaScript after page load
- JavaScript runs in a Node.js worker thread on the client
- The server generates the full HTML page before sending it to the client (Correct answer)
- Static HTML files are pre-built at deploy time
Correct answer: The server generates the full HTML page before sending it to the client
In SSR, the server processes the request and sends a fully rendered HTML document to the browser.
Question 66: What is the significance of a code of conduct for Full-Stack Development professionals?
- It is merely symbolic
- It establishes expected behaviors and ethical standards that protect the public and profession (Correct answer)
- It limits professional freedom
- It applies only to new practitioners
Correct answer: It establishes expected behaviors and ethical standards that protect the public and profession
This is fundamental to Full-Stack Development practice. It establishes expected behaviors and ethical standards that protect the public and profession represents the professional standard for professional standards in the Full-Stack Development certification framework.
Question 67: What is horizontal scaling in cloud infrastructure?
- Increasing CPU and RAM on a single server
- Increasing disk storage on an existing server
- Replicating a database across multiple regions
- Adding more server instances to distribute load across multiple machines (Correct answer)
Correct answer: Adding more server instances to distribute load across multiple machines
Horizontal scaling (scaling out) adds more instances behind a load balancer to handle increased traffic, contrasting with vertical scaling which upgrades a single instance.
Question 68: Which SQL JOIN type returns all rows from the left table even if there is no match in the right table?
- FULL OUTER JOIN
- RIGHT JOIN
- INNER JOIN
- LEFT JOIN (Correct answer)
Correct answer: LEFT JOIN
A LEFT JOIN returns all rows from the left table and matched rows from the right table, filling NULLs where no match exists.
Question 69: What does `docker-compose up` do?
- Uploads images to Docker Hub
- Starts all services defined in a docker-compose.yml file as a multi-container application (Correct answer)
- Updates Docker to the latest version
- Scales a single container to multiple replicas
Correct answer: Starts all services defined in a docker-compose.yml file as a multi-container application
docker-compose up reads the docker-compose.yml file and starts all defined services (e.g., app + database + cache) together with their configured networking and volumes.
Question 70: Which HTML5 attribute makes a form input accessible to screen readers by associating a label with it?
- aria-label
- for / id pair on label and input (Correct answer)
- placeholder
- title
Correct answer: for / id pair on label and input
Connecting a <label for='id'> to an <input id='id'> programmatically associates them, allowing screen readers to announce the label when the input is focused.
Question 71: Which cloud deployment model gives the customer the most control over the underlying infrastructure?
- SaaS (Software as a Service)
- IaaS (Infrastructure as a Service) (Correct answer)
- FaaS (Function as a Service)
- PaaS (Platform as a Service)
Correct answer: IaaS (Infrastructure as a Service)
IaaS provides raw virtual machines, networking, and storage, giving teams full control over the OS, runtime, and middleware at the cost of more management responsibility.
Full-Stack Development Certification
Validates proficiency across the complete web development stack, covering frontend technologies, backend systems, database design, API development, and DevOps practices. Based on the W3Schools Full Stack Developer Certificate format.
Exam Rules
- You can skip questions and return to them later
- Flag questions for review before submitting
- No feedback shown until you submit the entire exam
- Unanswered questions count as wrong — answer everything
- 10 pretest questions are mixed in and don't affect your score
- Timer auto-submits when time runs out
- Your progress is auto-saved every 30 seconds