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. |