Introduction

The NEB Grade XII Computer Science examination for 2082 (2025), Set ‘D’ (Sub Code 4281’D’), was set for regular and partial students whose registration numbers begin with 78, 79, 80, or 81, carrying full marks of 50 across a comparatively tight 2-hour sitting. Computer Science at this level covers genuinely diverse ground — database management, web technologies, object-oriented programming, C programming, system analysis and design, networking, and emerging technologies all appear in a single paper, and this particular set is a clean, representative example of how NEB distributes marks across that full range.

What stands out about this paper is how many of its MCQs are built around a specific, precise technical fact rather than a general concept — knowing that ALTER (not CREATE) is the correct SQL command for modifying an existing table’s structure, recognizing that a PHP variable name can never begin with a digit, and identifying that int number(int a); is a function declaration rather than a definition, since it has no accompanying function body. This kind of precision-testing continues into the short-answer and long-answer sections, where students are asked to write working JavaScript and PHP code, explain the mechanics of call-by-value versus call-by-reference with genuine technical accuracy, and design a complete C program using both arrays and structures together.

Database management and web technologies form one strong pillar of this paper, tested through SQL commands, DDL/DML distinctions, normalization, and both JavaScript and PHP coding questions. Programming in C forms an equally strong pillar, culminating in a substantial Group C question requiring a complete working program that reads and displays ten customers’ records using arrays of structures. System analysis and design, object-oriented programming, networking, and emerging technologies like AI and cloud computing round out a paper that genuinely samples across the full breadth of the Grade XII Computer Science syllabus rather than concentrating narrowly on one or two favorite topics.

In this article, we’ll break down the complete question pattern, map out exactly where the marks were concentrated unit by unit, work through the reasoning behind every MCQ answer, discuss the approach and provide working code or explanations for each descriptive question, and lay out a preparation strategy built specifically around what this paper demands. We’ve also answered the questions students most frequently ask about this exam.

Exam Overview

Full Question Paper

Question Pattern Analysis

This paper follows NEB’s standard three-group structure, scaled to Computer Science’s 50-mark format:

Group A — Multiple Choice Questions (9 × 1 = 9 marks) All 9 MCQs are compulsory, distributed separately 30 minutes after the exam begins, and span database management, web scripting languages (JavaScript and PHP), C programming, object-oriented programming, system analysis, and emerging technology. Several questions require precise technical recall rather than general familiarity — the exact SQL command for a specific task, the exact syntax rule that makes a PHP variable name invalid, and the exact terminology distinguishing a function declaration from a definition.

Group B — Short Answer Questions (5 × 5 = 25 marks) Questions 10 to 14 cover database concepts (with an “Or” choice between DDL/DML differences and normalization), practical coding questions (with an “Or” choice between JavaScript and PHP), object-oriented programming concepts, system analysis methodology, and artificial intelligence applications in education.

Group C — Long Answer Questions (2 × 8 = 16 marks) Questions 15 and 16 test data communication and transmission media in depth, and a substantial C programming question requiring a complete program using arrays and structures together (with an “Or” choice on function components and parameter-passing mechanisms).

A clear thread runs through this paper: nearly every unit is tested at least twice, once through a quick MCQ and once through a more substantial short or long-answer question, meaning students genuinely need working knowledge across the full syllabus rather than deep expertise in just a couple of favorite topics.

Topics Covered

Based on a full review of all 16 questions, this paper draws from the following core areas of the NEB Grade XII Computer Science syllabus:

• Database Management Systems — primary keys, SQL commands (CREATE, ALTER, SELECT, UPDATE), DDL versus DML, normalization (2NF and 3NF)
• Networking and Data Communication — secure communication protocols (HTTPS), transmission media (guided and unguided) with their advantages and disadvantages
• Web Technologies and Scripting — JavaScript control structures and coding practice, PHP variable naming rules and MySQL database connectivity
• Programming in C — function declarations versus definitions and calls, arrays combined with structures, function components, call-by-value and call-by-reference
• Object-Oriented Programming — the data-centric emphasis of OOP compared to procedural approaches, classes and inheritance with examples
• System Analysis and Design — types of feasibility study (specifically technical feasibility), requirement gathering and its methods
• Emerging Technologies — cloud computing service models (IaaS, PaaS, SaaS), artificial intelligence and its applications in education

Unit-Wise Weightage

Grouping the 50 marks by broad Computer Science unit shows how this paper distributed its emphasis:

This is a notably even distribution compared to subjects like Chemistry or Mathematics, where one or two units typically dominate — here, Programming in C and Networking share the top spot, but every other unit still contributes a solid, comparable share of the total marks. This suggests that in Computer Science specifically, breadth of preparation across all syllabus units matters just as much as depth in any single one.

Unit-Wise Discussion

Database Management Systems (Q1, Q2, Q10): The primary key MCQ tests the core purpose of this database concept — uniquely identifying each record, rather than any of the incorrect distractors related to duplication, backup, or database size. The ALTER command MCQ tests precise SQL vocabulary, distinguishing table-structure modification (ALTER) from table creation (CREATE), data retrieval (SELECT), and data modification (UPDATE). Q10 goes deeper, asking for the conceptual and practical differences between DDL and DML with examples, or alternatively, a definition of normalization along with an explanation of its second and third normal forms — both classic, high-frequency database theory questions.

Networking and Data Communication (Q3, Q15): The HTTPS MCQ tests recognition that this protocol, unlike HTTP, FTP, or Telnet, specifically provides secure, encrypted communication over a network. Q15 is the paper’s most substantial networking question, requiring a full explanation of transmission media — both guided (wired) and unguided (wireless) types — along with their respective advantages and disadvantages, a topic that rewards organized, comparative revision over scattered fact recall.

Web Technologies — JavaScript and PHP (Q4, Q5, Q11): The JavaScript MCQ tests recognition that loop structures (specifically the for loop among the given options) are used for repeated execution based on a condition, distinct from decision structures like if-else and switch-case. The PHP MCQ tests a precise syntax rule — variable names in PHP must begin with a letter or underscore, never a digit, making $1name invalid. Q11 shifts to practical coding, asking students to either write JavaScript code that finds the smallest of three input numbers, or write a PHP script that connects to a MySQL database — both genuinely practical, testable coding skills.

Programming in C (Q6, Q16): The function declaration MCQ tests precise terminology — recognizing that a statement with a function signature but no accompanying body (like int number(int a);) is a declaration, not a call, definition, or execution. Q16 is the paper’s most substantial programming question, requiring a complete working C program that combines arrays and structures to store and display ten customers’ account details — a genuinely comprehensive test of practical C programming ability. Its alternative shifts to more conceptual territory, asking for the components of a C function alongside a detailed explanation of call-by-value and call-by-reference parameter passing.

Object-Oriented Programming (Q7, Q12): The OOP MCQ tests the fundamental distinction between object-oriented programming’s data-centric emphasis and procedural programming’s focus on procedures or functions as the primary organizing principle. Q12 asks for a written explanation of classes and inheritance with an example, testing whether students can move beyond definitions to demonstrate the “is-a” relationship and code reusability that inheritance provides.

System Analysis and Design (Q8, Q13): The feasibility study MCQ tests recognition that technical feasibility specifically evaluates whether a system can be built using currently available technology, distinct from operational, social, or economic feasibility, which each assess different dimensions of a proposed system’s viability. Q13 asks for a definition of requirement gathering along with an explanation of its various methods — a foundational system analysis and design topic that anchors the entire early stage of the system development life cycle.

Emerging Technologies (Q9, Q14): The cloud computing MCQ tests recognition that Infrastructure, Platform, and Software as a Service (IaaS, PaaS, SaaS) are the three standard, widely recognized cloud service models, while “Hardware as a Service” is not one of the conventionally taught categories. Q14 asks for a definition of artificial intelligence alongside its specific application areas within education — a topic that rewards students who can name concrete, real-world AI applications (like personalized learning and intelligent tutoring systems) rather than only defining AI in the abstract.

Difficulty Analysis

This paper sits at a moderate difficulty level, with its challenge coming primarily from the breadth of precise technical knowledge required across many different sub-fields of computer science, rather than from any single conceptually difficult topic. Group A demands genuine technical precision rather than general familiarity — several MCQs hinge on a single specific rule or exact terminology (the PHP variable naming rule, the function declaration versus definition distinction) that’s easy to get wrong without careful, specific revision. Group B is comfortably scorable for well-prepared students, though the coding questions (Q11) require actual working syntax knowledge rather than just conceptual understanding, and Q12’s request for an “example” alongside the class and inheritance explanation means a purely definitional answer would likely lose marks. Group C is the most demanding section — Q16’s C programming question requires combining two separate concepts (arrays and structures) correctly within a single working program, a task that’s considerably harder than demonstrating either concept in isolation, while Q15’s transmission media question rewards students who have organized their revision by comparing multiple media types systematically rather than only remembering isolated facts about each one.

MCQ Explanations (Group A)

Q1. Purpose of a primary key in a database The correct answer is To uniquely identify a record. A primary key is a column (or combination of columns) whose values must be unique across all rows in a table, ensuring that every record can be distinctly identified and referenced, including from other related tables.

Q2. SQL command to add a new column to an existing table The correct answer is ALTER. The ALTER TABLE command is specifically used to modify an existing table’s structure, including adding, modifying, or dropping columns, distinct from CREATE (which builds a new table), SELECT (which retrieves data), and UPDATE (which modifies existing data values).

Q3. Protocol used for secure communication over a network The correct answer is HTTPS. HTTPS (HTTP Secure) encrypts data transmitted between a client and server using SSL/TLS, unlike HTTP, FTP, and Telnet, which transmit data without this encryption layer.

Q4. JavaScript control structure for repeated execution based on a condition The correct answer is For loop. Loop structures like the for loop are specifically designed to execute a block of code repeatedly while a given condition holds true, distinct from if-else and switch-case (which handle conditional branching, not repetition) and functions (which encapsulate reusable code blocks but don’t inherently repeat execution).

Q5. Invalid variable name in PHP The correct answer is $1name. PHP variable names must begin with a letter or an underscore immediately after the dollar sign — they can never begin with a digit, making $1name syntactically invalid, while $name, $_name, and $name123 are all valid.

Q6. Classification of the statement int number(int a); The correct answer is function declaration. This statement specifies the function’s name, return type, and parameter type without providing an actual function body, which is precisely what distinguishes a declaration (or prototype) from a full definition.

Q7. Programming paradigm emphasizing data over procedures The correct answer is Object-oriented programming. OOP organizes code around objects that bundle data (attributes) together with the methods that operate on that data, placing data at the center of the design, in contrast to procedural programming’s emphasis on sequences of procedures or functions.

Q8. Feasibility study evaluating whether a system can be built with available technology The correct answer is Technical feasibility. This specific type of feasibility study assesses whether the necessary technology, tools, and technical expertise exist or are accessible to successfully implement a proposed system, distinct from operational, social, or economic feasibility, which evaluate different dimensions entirely.

Q9. Not a recognized type of cloud computing service The correct answer is Hardware as a Service (HaaS). The three standard, widely recognized cloud computing service models are Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS); HaaS is not one of the conventionally taught cloud service categories in this syllabus.

Group B and C Answer Discussion

Q10 (DDL versus DML / Or: Normalization): DDL (Data Definition Language) commands define and modify the database’s structure — including CREATE, ALTER, and DROP — and are typically auto-committed, meaning their changes become permanent immediately and generally cannot be rolled back. DML (Data Manipulation Language) commands, including INSERT, UPDATE, DELETE, and SELECT, manipulate the actual data stored within tables and can typically be rolled back before being committed. A third distinguishing difference is scope: DDL affects the overall schema (tables, indexes, constraints), while DML affects only the data rows within existing tables. In the alternative, normalization is the process of organizing a database’s tables to reduce data redundancy and improve data integrity. Second Normal Form (2NF) requires that a table already be in First Normal Form (with atomic values and no repeating groups) and that every non-key attribute be fully functionally dependent on the entire primary key, eliminating partial dependency in tables with composite keys. Third Normal Form (3NF) requires that a table already be in 2NF and additionally have no transitive dependency, meaning non-key attributes depend only on the primary key and not indirectly on other non-key attributes.

Q11 (JavaScript smallest number / Or: PHP MySQL connection): A JavaScript solution for finding the smallest of three input numbers reads three values (commonly via prompt() and converts them using parseFloat()), then compares them using a chain of if-else conditions to identify and display the minimum value:

let a = parseFloat(prompt("Enter first number:"));
let b = parseFloat(prompt("Enter second number:"));
let c = parseFloat(prompt("Enter third number:"));
let smallest;
if (a <= b && a <= c) {
    smallest = a;
} else if (b <= a && b <= c) {
    smallest = b;
} else {
    smallest = c;
}
document.write("Smallest number is: " + smallest);

In the alternative, a PHP script connecting to a MySQL database typically uses the mysqli_connect() function with the server name, username, password, and database name as parameters, followed by a check to confirm the connection succeeded:

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mydatabase";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>

Q12 (Class and inheritance in OOP): A class is a blueprint or template that defines the attributes (data members) and methods (behaviors) that its objects will have, while an object is a specific instance created from that class. Inheritance is a mechanism through which a new class (the derived or child class) acquires the attributes and methods of an existing class (the base or parent class), enabling code reuse and establishing an “is-a” relationship between the two. For example, a base class Animal might define a name attribute and a makeSound() method, while a derived class Dog inherits these from Animal and can add its own additional attributes or methods, such as a breed attribute or a more specific bark() method — demonstrating how inheritance allows the child class to reuse and extend the parent class’s functionality rather than rewriting it from scratch.

Q13 (Requirement gathering and its methods): Requirement gathering is the process of identifying, collecting, and documenting the needs and expectations of stakeholders for a new or modified system, typically conducted during the early stages of the system development life cycle, and it forms the essential foundation for all subsequent design and development work. Common methods include interviews (direct one-on-one or group discussions with stakeholders), questionnaires or surveys (structured written questions distributed to a larger group of users for broader input), observation (directly watching users perform their existing tasks to identify real-world requirements and pain points), and document analysis (reviewing existing records, reports, or manuals to extract relevant requirements) — each method suited to different project contexts, stakeholder availability, and the level of detail required.

Q14 (Artificial intelligence and its applications in education): Artificial Intelligence is the branch of computer science focused on building systems capable of performing tasks that typically require human intelligence, such as learning, reasoning, problem-solving, and language understanding. In education specifically, AI applications include personalized or adaptive learning systems that tailor content and pacing to each individual student’s needs and progress, intelligent tutoring systems that provide instant, targeted feedback and additional practice, automated grading and assessment tools that reduce teachers’ manual workload, AI-powered chatbots and virtual assistants that answer student queries and provide administrative support, and predictive analytics systems that identify at-risk students early enough for meaningful intervention.

Q15 (Transmission media): A transmission medium is the physical or wireless pathway through which data signals travel between a sender and a receiver in a communication network. Guided (wired) media include twisted pair cable (inexpensive and flexible, but susceptible to electromagnetic interference and limited in bandwidth and distance), coaxial cable (better shielded than twisted pair with higher bandwidth, though more expensive and less flexible), and fiber optic cable (offering very high bandwidth, immunity to electromagnetic interference, and long-distance transmission with minimal signal loss, though costly to install and requiring specialized equipment and expertise). Unguided (wireless) media include radio waves (able to penetrate walls and support mobile communication, though prone to interference and security concerns), microwave transmission (supporting high bandwidth over long distances, but requiring a clear line of sight and vulnerable to weather conditions), and satellite communication (covering very large or remote geographic areas effectively, though introducing higher latency and requiring expensive setup and maintenance).

Q16 (C program with arrays and structures / Or: Function components and parameter passing): The main question requires a complete C program that defines a Customer structure containing an account number, name, and address, declares an array of ten such structures, reads each customer’s details in a loop, and then displays all ten records in a second loop:

#include <stdio.h>

struct Customer {
    int account_number;
    char name[50];
    char address[100];
};

int main() {
    struct Customer cust[10];
    int i;

    for (i = 0; i < 10; i++) {
        printf("Enter account number for customer %d: ", i + 1);
        scanf("%d", &cust[i].account_number);
        printf("Enter name for customer %d: ", i + 1);
        scanf("%s", cust[i].name);
        printf("Enter address for customer %d: ", i + 1);
        scanf("%s", cust[i].address);
    }

    printf("\nCustomer Details:\n");
    for (i = 0; i < 10; i++) {
        printf("Account Number: %d, Name: %s, Address: %s\n",
               cust[i].account_number, cust[i].name, cust[i].address);
    }

    return 0;
}

In the alternative, the essential components of a C function are its name, return type, parameter list, and function body (the block of statements that executes when the function is called). Call-by-value passes a copy of the actual argument’s value into the function, meaning any changes made to the parameter inside the function do not affect the original variable in the calling code, since the function operates on an entirely separate copy in memory. Call-by-reference, implemented in C through pointers, instead passes the memory address of the actual argument, meaning changes made inside the function directly modify the original variable, since the function operates on the same memory location rather than a copy — a distinction that becomes essential whenever a function needs to genuinely modify data belonging to the calling code rather than just read it.

Student Preparation Tips

1. Revise SQL commands by exact purpose, not just by name. Confusing CREATE, ALTER, SELECT, and UPDATE is a common and entirely avoidable mistake — build a quick reference table mapping each command to its specific purpose (structure creation, structure modification, data retrieval, data modification) and drill it until it’s automatic.
2. Practice writing actual working code for both JavaScript and PHP, not just reading about syntax. Q11’s “Or” choice shows that either language could appear, so practicing small, complete programs (input handling, basic logic, database connection) in both languages pays off directly.
3. Get comfortable combining arrays and structures in C, not just using them separately. Q16 specifically requires both together, which is a meaningfully harder skill than using either concept in isolation — practice writing a few complete programs that store multiple structured records in an array.
4. Build a clear mental model of call-by-value versus call-by-reference with a worked example each time. Simply stating the definitions often isn’t enough for full marks — practicing a concrete before-and-after example (like the ones shown above) demonstrates genuine understanding far more convincingly.
5. Organize transmission media revision by comparing types side-by-side. Rather than memorizing isolated facts about each medium, build a table comparing guided versus unguided media across bandwidth, cost, interference susceptibility, and typical use case — this structure makes Q15-style comparative questions much faster to answer.
6. Don’t underprepare system analysis and design topics like feasibility studies and requirement gathering. These conceptual, less code-heavy topics are easy to deprioritize in favor of programming practice, but they carry equal marks and are tested with the same regularity.
7. Practice explaining OOP concepts with a concrete example every time. Q12 specifically asks for an example alongside the explanation of class and inheritance, and this pattern — theory plus example — is common enough across NEB Computer Science papers that it’s worth building into your default answer structure for any conceptual question.
8. Revise emerging technology topics (AI, cloud computing) with specific, real-world application examples. Being able to name concrete applications (like intelligent tutoring systems for AI, or specific IaaS/PaaS/SaaS providers for cloud computing) demonstrates stronger understanding than definitions alone and is what separates a complete answer from a partial one.

Frequently Asked Questions

Q1. What is the full marks and time duration for the NEB Grade XII Computer Science 2082 Set D paper? The paper carries full marks of 50 and is to be completed within 2 hours, with the MCQ section (Group A) distributed 30 minutes after the exam begins.

Q2. How many groups are there in this Computer Science paper, and how are marks distributed? There are three groups: Group A (9 MCQs, 1 mark each = 9 marks), Group B (5 short-answer questions, 5 marks each = 25 marks), and Group C (2 long-answer questions, 8 marks each = 16 marks).

Q3. Which unit carries the highest weightage in this Computer Science paper? Programming in C and Networking/Data Communication are tied for the highest weightage at roughly 18% each, closely followed by Database Management Systems and Web Technologies at around 14% each — a notably even spread compared to some other subjects.

Q4. What programming languages should students be prepared to code in for the NEB Computer Science exam? Based on this paper, students should be comfortable writing working code in C (for Group C’s programming questions), and at least one of JavaScript or PHP (since Group B’s coding question offers a choice between the two) — practicing basic input handling, conditional logic, and for JavaScript/PHP specifically, database connectivity, is time well spent.

Q5. Are “Or” choice questions common in NEB Computer Science, and how should students use them? Yes, this paper includes “Or” choices in Q10, Q11, and Q16. Students should quickly assess which option they’re more confident in — particularly for Q11, where the choice is between two different programming languages entirely — before committing to one.

Q6. How important is database management for the NEB Computer Science board exam? Quite important — this paper tests database concepts through both a quick MCQ format (primary keys, SQL commands) and a more substantial short-answer question (DDL/DML differences or normalization), showing that both surface-level SQL knowledge and deeper database design theory are fair game.

Q7. Is this question paper suitable for practice by students preparing for a different set (A, B, C, etc.)? Yes. While registration numbers determine which exact set a student receives, the syllabus, unit weightage, and overall difficulty level remain consistent across sets, making this Set D paper valuable practice material regardless of which set a student is actually assigned.

Conclusion

The NEB Grade XII Computer Science 2082 Set D paper reflects a genuinely well-rounded test of the full syllabus, with Programming in C and Networking sharing the top weightage, closely followed by Database Management Systems, Web Technologies, Object-Oriented Programming, System Analysis and Design, and Emerging Technologies all contributing comparable shares. What distinguishes this paper is its consistent demand for precise technical accuracy — exact SQL command names, exact PHP syntax rules, and exact C terminology — over broad conceptual familiarity, meaning students who revise Computer Science with attention to specific detail will be considerably better positioned than those who only skim for general understanding. Students preparing for their own examination should use the MCQ reasoning and descriptive answer discussion above, including the worked code examples, as a template for practicing this specific style of precision-focused, broadly distributed question set.