Class 12 Computer Science notes and question bank — NEB Exam

Computer Science

Class 12 - 7 Chapters

Sub. code 4281

NEB — GRADE XII

2079

Old Question

Class 12 Computer Science Old Question 2079

The 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 Hoursपूर्णाङ्क (Full Marks) : 50

Pass Marks : 20

सबै प्रश्नको उत्तर दिनुहोस् । (Attempt All Questions)

This old question paper is for Class 12 Computer Science, 2079 (subject code 4281), carrying full marks of 50 with a pass mark of 20, to be completed within 2 Hours. Model answers are available for questions that have one — reveal them with a free account (a few reveals) or a paid plan (unlimited).

Group A

Rewrite the correct option of each question in your answer sheet.

9 marks[9*1 = 9]
1.
[1]

Which of the following SQL statement is used to DELETE rows from a database table?

a.

DELETE  

b.

REMOVE

c.

DROP   

d.

CLEAR

2.
[1]

A field that is used to uniquely define a particular record in a table is called:

a.

Primary Key

b.

Entity

c.

Relationship  

d.

Constraints

3.
[1]

What does "MAC" stands for in MAC Address?

a.

Mandatory Access Control

b.

Media Access Control

c.

Micro Access Control

d.

Media Access Certificate

4.
[1]

Correct syntax for referring to an external JavaScript:

a.

<script src="myscript.js"></script>

b.

<script href="myscript.js"></script>

c.

<js href="myscript.js"></js>

d.

<js src="myscript.js"></js>

5.
[1]

Correct way of defining a variable in PHP:

a.

$variable name = value;

b.

$variable_name = value;

c.

$variable_name = value

d.

$variable name as value;

6.
[1]

What is the output of C program?

void main(){

int b = 25;

// b memory location = 1234;

int *p; p = &b; printf("%d %d", &b, p);

}

a.

25 25

b.

1234 1234

c.

25

d.

1234 25

7.
[1]

Which feature of OOP is illustrated the code reusability?

a.

Polymorphism  

b.

Abstraction  

c.

Encapsulation  

d.

Inheritance

8.
[1]

Which of following is the discovering requirement from a user in the requirement collection process?

a.

Feasibility study

b.

Requirement Elicitation

c.

Requirement Specification

d.

Requirement validation

9.
[1]

What devices are detecting and responding to changes in an environment that are embedded in smart phones and an integral part of the Internet of Things (IoT)?

a.

Wi-Fi

b.

Barcode  

c.

RFID  

d.

Sensors

Group B

Short answer question

25 marks[5*5 = 25]
10.
[5]
a.

Differentiate the centralized and distributed database system.

Or
a.

What are the purposes of normalization? Give an example of 2NF.

11.
[5]
a.

Write a program to find the factorial of any given number using Javascript.

Or
a.

How do you fetch data from database in PHP and display it in form? Describe.

12.
[5]

Compare the OOPs and procedural programming language.

13.
[5]

What are the major activities performed to design the software? Describe.

14.
[5]

Explain the popular five application areas of AI.

Group C

Long answer question

16 marks[2*8 = 16]
15.
[5 + 3]

Compare the star and ring topology with pros and cons. Which of data communication cable is more appropriate to design the local area network? Describe.

16.
a.
[2 + 6]

What is structure? Write a program to input roll, name and age of 5 students and display them properly using structure.

Or
a.
[8]

Write a C program to enter ID, employee name, name and post of the employee and store them in a data file named "emp.txt". Display each record on the screen in an appropriate format.

Computer Science — Old Question 2079NEB Exam

Paper Overview & Analysis

2079

Year

Old Question

Type

50

Full Marks

20

Pass Marks

2 Hours

Duration

16

Question Items

Question Type Breakdown

MCQ9
Short Answer5
Long Answer2

Group Breakdown

Group A9 questions · 9 marks
Group B5 questions · 25 marks
Group C2 questions · 16 marks

Chapter Breakdown

DBMS Concept2 items2 marks
Concept of Network and Data Communication2 items9 marks
Web Technology - II (CSS, JavaScript, PHP)2 items2 marks
Programming II2 items9 marks
OOP Concept1 item1 mark
Software Process Model1 item5 marks
Recent Trends in ICT1 item5 marks

Chapter breakdown covers 11 of 16 question items on this paper — the rest aren't tagged to a chapter yet.