(XII) Marking Scheme of NEB Computer 2079(2022)

 

                                                                      NEB – GRADE XII

2079(2022)                                                           Sub. Code: 4281 “A”

Computer Science (New Course)                                      Full Marks: 50

Marking Schema

Group A: Correct option of Multiple-choice questions (1 Marks for correct option)

Q No

Options

Correct Answer

Q No

Options

Correct Answer

1

A

DELETE

6

B

1234   1234

2

A

Primary Key

7

D

Inheritance

3

B

Media Access Control

8

B

Requirement  Elicitation

4

A

<script src= “myscript.js”></script>

9

D

Sensors

5

B

$variable_name=value;

 

 

 

Group B: Short answer questions (5×5=25) Contents Area and Marks Schema:

Q.N0 10 :

Differentiate the centralized and distributed database system

Full Marks(5)

·         Data Storage and server in single location vs server location – 1 mark

·         Single server vs multiple node – 1 mark

·         Central Data storage vs data fragmentation – 1 mark

·         Diagram of centralized vs distributed – 1mark

·         Risk/benefit/control concept of both database -1 mark

Based on the above partial points and concepts will be scored partial marks.

Q. No. 10 : OR

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

Full Marks(5)

·         Concept of removing the data redundancy -1 mark

·         Concept of removing of insert, update, delete anomalies -1 mark

·         Functional dependency concepts - 2 marks

Above partial points and concepts will be scored partial marks.

Q. No. 11:

Write a program to find the factorial of any given number using Java Script

Full Marks(5)

·         Properly start the Java Script and close  - 1 Mark

·         Write a script to find factorial of given any number-4 mark

Above partial script of factorial and concept will be scored partial marks

Q. No. 11: OR

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

Full Marks(5)

·         PHP and MySQL database connection class or procedure – 2 marks

·         Data fetch PHP script such as example of mysqli_connect() , mysqli_query() , mysqli_fetch_assoc() or similar use of function – 2 mark

·         SQL Select statement in a script to access data – 1 mark

Above partial script and code will be scored partial marks.

Q. No. 12:

Compare the OOPs and procedural programming language.

Full Marks(5)

·         Code in model/function vs class object – 1 mark

·         OOPs features Vs Procedural language features – 2 marks

·         Code reusability/flexibility/modification concept-1 mark

·         Example of both programming languages – 1 mark

Above partial points will be scored partial marks.

Q. No. 13:

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

Full Marks(5)

·         List or points of software design activities such as architecture designing, database design, user interface design, algorithmic designing-2 marks

·         Case tools handling or similar design activities concepts or diagram names- 3 marks

Above partial points will be scored partial marks

Q. No. 14:

Explain the popular five application areas of AI.

Full Marks(5)

·         List of AI applications such as machine learning, robotics, natural language processing, and machine vision etc or similar types of application in any five areas of AI. (0.5×5=2.5 marks) and each area very short description. (0.5×5=2.5)

Above partial points will be scored partial marks.

 

 

 

 

 

Group C: Long Answer Questions (2×8=16)               Contents Area and Marks Schema:

Q. No. 15 :

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.

Full Marks(4+4)

·         Compare star and ring topology with figure – 2 marks

·         Star and Ring topology pros and cons – 2 mark

·         Concept of  local area network- 1 mark

·         Appropriate partial cable such as UTP or CAT-6 with description (cost, distance, technology)- 3 marks

Above partial points will be scored partial marks.

Q. No. 16:

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

Full Marks (2+6)

·         Define structure- 2mark

·         Input and display 5 students data using structure including loop with complete C executable code – 6 marks

Above partial concept of structure ; looping code and used logic in C will be scored partial marks range of 1-6 marks

Q. No. 16 : OR

Write a C program to enter ID, employee_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. (5+3)

Full Marks(5+3)

·         Code for showing the pointer and file opening mode – 2 marks

·         Code for entering and store C programming code allocated 5 marks using file handling functions – 3 marks

·         Code for Display data in C programming using file handling functions – 3marks

Above partial concept of file handling and used logic in C will be scored partial marks range of 1-6 marks.