Browse papers

NEB Class 12 Science Computer Science Question Paper 2082 (Set B)

NEB Class 12SCIENCEsupplementary
50marks
120min
16questions
A

Group 'A' (Multiple choice questions)

Rewrite its (MCQ) correct option (answer) in the same answer sheet. (Provided after 30 minutes.)

9 questions·1 marks each
1mcq1 marks

Which SQL query will display all records from table "ADDRESS" in descending order according to the lastname?

  • A

    SELECT *FROM ADDRESS ORDER BY lastname ASC;

  • B

    SELECT * FROM ADDRESS ORDFR BY lastname DESC;

  • C

    SELECT * FROM ADDRESS SORT BY lastname DESC;

  • D

    SELECT * FROM ADDRESS ORDER BY lastname.

sqldatabase
2mcq1 marks

Why is normalization important in database design?

  • A

    It increases data redundancy, and improves storage efficiency.

  • B

    It reduces data redundancy, eliminates anomalies, and improve data integrity.

  • C

    It makes databases slower and harder to query

  • D

    It is only useful for hierarchical databases

databasenormalization
3mcq1 marks

What type of transmission medium includes physical cables such as twisted pair, coaxial, and fiber optic?

  • A

    Guided

  • B

    Terrestrial

  • C

    Electromagnetic

  • D

    unguided

networkingtransmission-medium
4mcq1 marks

Choose the correct datatype of the following variable in JavaScript. Let a = 4.5

  • A

    Decimal

  • B

    Number

  • C

    Integer

  • D

    Float

javascriptdatatype
5mcq1 marks

What type of language is PHP?

  • a

    Client-side scripting

  • b

    Machine level scripting

  • c

    Server-side

  • d

    User-side scripting

php
6mcq1 marks

Which of the following is a correct function declaration in C?

  • A

    int function (a, b);

  • B

    void function (int x, int y);

  • C

    func (int x, y);

  • D

    int func (int x, int y)

c-programmingfunction-declaration
7mcq1 marks

What is the primary benefit of using inheritance in oop?

  • A

    Code reusability

  • B

    Error correction

  • C

    Design pattern

  • D

    Debugging

oopinheritance
8mcq1 marks

The method of testing smallest functional units of code is called ...........

  • A

    Functional Testing

  • B

    Method Testing

  • C

    Unit Testing

  • D

    System Testing

software-testingunit-testing
9mcq1 marks

What is an example of a SaaS application in cloud?

  • A

    Amazon Ec2.

  • B

    Microsoft Azure.

  • C

    Google Docs.

  • D

    VMware.

cloud-computingsaas
B

Group 'B' (Short answer questions)

Attempt all the questions.

5 questions·5 marks each
10short5 marks

What is Normalization? Explain 2 NF. [2+3][2+3]

OR

Write two DDL Commands and three DML Commands in SQL with Syntax. [2+3][2+3]

databasenormalizationsql
11short5 marks

Write a program in JavaScript to input Age of a person and display whether the person is eligible for voting or not. (If Age is greater than or equal to 18 years, eligible for voting otherwise not eligible)

OR

Write a PHP function which is commonly used to establish a connection to a MySQL database with an example.

javascriptphpmysql
12short5 marks

Write short notes on "class" and "Polymorphism" in Object Oriented programming.

oopclasspolymorphism
13short5 marks

Explain Agile method of software development.

software-engineeringagile
14short5 marks

Explain the three "Vs" of big data.

big-data
C

Group 'C' (Long answer questions)

Attempt all the questions.

2 questions·8 marks each
15long8 marks

a) Write four difference between Client Server and Peer to Peer network. [4][4]

b) Explain simplex and full-duplex with diagram. [4][4]

networkingtransmission-modes
16long8 marks

Write a C program to enter information of 10 clients, including accountID, accountname, address, and balance, and display the information using a structure. [4+4][4+4]

OR

Describe file handling modes on C. Write a C program to create and write data into a file. [4+4][4+4]

c-programmingstructurefile-handling