Browse papers

NEB Class 12 Science Computer Science Question Paper 2081

NEB Class 12SCIENCEregular
50marks
120min
16questions
A

Group 'A'

Multiple Choice Questions. Rewrite the correct option of each question in your same answer sheet.

9 questions·1 marks each
1mcq1 marks

Which one of the followings given statement correct ?

  • a

    Select * from enp where eopid = 103;

  • b

    Select from enp where eopid = 103;

  • c

    Select eopid where enp = 103 from emp;

  • d

    Select eopid where eopid = 103 and table = emp;

sqldatabases
2mcq1 marks

Which database system normally offers better performance for geographically dispersed users ?

  • a

    Centralized database system

  • b

    Distributed database system

  • c

    NoSQL database system

  • d

    Relational database system

databasesdistributed-systems
3mcq1 marks

Which of the following is an example of a public IPV4 address ?

  • a

    192.168.1.1

  • b

    172.16.10.1

  • c

    10.10.10.10

  • d

    203.0.113.10

networkingip-addressing
4mcq1 marks

What is the correct syntax for a 'for-loop' in JavaScript ?

  • a

    for (var i = 0; i < 5; i++) {}

  • b

    for (i = 0; i < 5; i++) {}

  • c

    for (var i = 0; i < 5) {}

  • d

    for (var i < 5; i++) {}

javascriptloops
5mcq1 marks

Which PHP function is commonly used to execute SQL queries on a database connection established using mysqli extension ?

  • a

    mysqli_query ( )

  • b

    pdo_query ( )

  • c

    mysql_query ( )

  • d

    pgsql_query ( )

phpmysqlidatabases
6mcq1 marks

What is the correct syntax to declare a structure in C ?

  • a

    struct { }

  • b

    define struct { }

  • c

    struct [ ]

  • d

    struct <name> { }

c-programmingstructures
7mcq1 marks

In C, which operator is used to get the address of a variable ?

  • a
  • b

    &

  • c

    ->

  • d

    .

c-programmingoperatorspointers
8mcq1 marks

Which OOP feature allows a class to inherit properties and behavior from another class ?

  • a

    Inheritance

  • b

    Encapsulation

  • c

    Polymorphism

  • d

    Abstraction

oopinheritance
9mcq1 marks

Which model of SDLC is characterized by a linear progression of phases from requirements gathering to maintenance ?

  • a

    Waterfall model

  • b

    Agile model

  • c

    Spiral model

  • d

    RAD model

sdlcsoftware-engineering
B

Group 'B'

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

5 questions·5 marks each
10short5 marks

Evaluate the advantages of DBMS compared to traditional file-based data storage systems. [5]

OR

How does Second Normal Form (2NF) differ from First Normal Form (1NF), and what are the key benefits of achieving 2NF in database design ? Explain. [2+3]

dbmsdatabases
11short5 marks

Write a JavaScript function that checks if a number is even or odd and print the result. [1+4]

OR

What is purpose of the mysqli_connect ( ) function in PHP ? Describe its usage and parameters. [2+3]

javascriptphp
12short5 marks

Write short note on class and object in OOPs with a real-word example. [2.5+2.5]

oopclass-object
13short5 marks

How do various requirement gathering techniques help in achieving a careful grasp of user needs and system requirements during SDLC's analysis phase ? [5]

sdlcrequirements-gathering
14short5 marks

Give five examples of AI applications in the education. [5]

artificial-intelligenceeducation
C

Group 'C'

Long answer questions.

2 questions·8 marks each
15long8 marks

How does the star network topology differ from the bus network topology in terms of its architectural layout and data transmission methodology in modern computing environments ? [8]

networkingnetwork-topology
16long8 marks

Write a C program that uses structures to represent details of five books (title, author, publisher and price) and prints them out. [8]

OR

Discuss the concept of binary file handling in C programming and explain how putw ( ) and getw ( ) functions facilitate binary input/output operations. Give examples. [8]

c-programmingstructuresfile-handling