NEB Grade 12 Computer Science 2082 | Questions & Solved Answers

 

NEB-GRADE XII

2082 (2025) Computer Science

Sub.Code: 4281'D'

(For regular and partial students whose first two digits of registration

number starts from 78, 79, 80 and 81)

Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.

Time: 2 hrs.

Full Marks: 50

Multiple choice questions.

Group 'A' [9x1=9]   4281'D'

1. Which of the following is the purpose of using primary key in database? 

A) To uniquely identify a record

B) To store duplicate record

C) To backup data

D) To enhance database size

Ans:A) To uniquely identify a record

2. A company needs to modify an existing table by adding a new column for employee email addresses. For this, which SQL command should be used?

 A) CREATE

B) ALTER 

C) SELECT 

D) UPDATE

Ans:-B) ALTER 

3. Which protocol is used for secure communication over a computer network?

A) HTTP

B) FTP

C) HTTPS

D) Telnet

Ans:C) HTTPS

4. Which control structure in JS (Java Script) is used to execute a block of code repeatedly based on a given condition?

A) For loop

B) if-else

C) switch case 

D) function

Ans:-A) For loop

5. Select the invalid variable name in PHP.

A) Sname

B) $_name

C) $1name

D) $name123

Ans:C) $1name

6. The statement int number (int a); is a ...

A) function call

C) function declaration

B) function definition

D) function execution

Ans:-C) function declaration

7. In which of the following programming, the emphasis is given on data rather than on procedures ?

A) Procedural programming

C) Object-oriented programming

B) Structural programming

D) Declarative programming

Ans:C) Object-oriented programming

8. Which type of feasibility study evaluates whether a system can be developed with the available technology?.

A) Operational feasibility

B) Social feasibility

C) Technical feasibility

D) Economical feasibility

Ans:-C) Technical feasibility

9. Which of the following is NOT a type of cloud computing service ?

A) Infrastructure as a Service (IaaS)

B) Platform as a Service (PaaS)

C) Software as a Service (SaaS) 

D) Hardware as a Service (HaaS)

Ans:-D) Hardware as a Service (HaaS)

Group 'B'[5x5=25]

Short answer questions

10. Write any three differences between DDL and DML. Give examples of each.                        [3+2]

            OR

What is normalization? Explain 2NF and 3NF.                                                                                  [2+3]

11. Write JavaScript code to input any three numbers and find the smallest number among them.

            OR                                                                                                                                           [5]

Write a PHP script to connect to a MySQL database.                                                                             [5]

12. Write short notes on class and inheritance in oops.                                                                          [5] 

13. What is Requirement Gathering? Explain different Requirement Gathering

methods.                                                                                                                                             [1+4]

14. What is AI? Explain application areas of AI in education.                                                         [5]

Group 'C'

Long answer questions[2x8=16]

15. What is transmission medium? Explain its major types with advantages and disadvantages. [2+6] 

16. Write a C program that reads the account_number, name and address of ten customers from users and displays the account_number, name and address of these customers using Array and structure.

 OR                                                                                                                                                    [8]

What are the components of a function of C? Describe the Call - by - value and Call - by - reference and passing the function parameters.                                                                                                 [4+4]