Browse papers

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

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 of the following is the purpose of using primary key in database ?

  • a

    To uniquely identify a record

  • b

    To store duplicate record

  • c

    To backup data

  • d

    To enhance database size

databaseprimary-key
2mcq1 marks

A company needs to modify an existing table by adding a new column for employee email addresses. For this, which SQL command should be used ?

  • a

    CREATE

  • b

    ALTER

  • c

    SELECT

  • d

    UPDATE

sqlddlalter-table
3mcq1 marks

Which protocol is used for secure communication over a computer network ?

  • a

    HTTP

  • b

    FTP

  • c

    HTTPS

  • d

    Telnet

networkingprotocolhttps
4mcq1 marks

Which control structure in JS (Java Script) is used to execute a block of code repeatedly based on a given condition ?

  • a

    For loop

  • b

    if-else

  • c

    switch - case

  • d

    function

javascriptcontrol-structureloop
5mcq1 marks

Select the invalid variable name in PHP.

  • a

    $name

  • b

    $_name

  • c

    $1name

  • d

    $name123

phpvariable-naming
6mcq1 marks

The statement

int number ( int a); is a ...

  • a

    function call

  • b

    function definition

  • c

    function declaration

  • d

    function execution

c-programmingfunction-declaration
7mcq1 marks

In which of the following programming, the emphasis is given on data rather than on procedures ?

  • a

    Procedural programming

  • b

    Structural programming

  • c

    Object-oriented programming

  • d

    Declarative programming

oopprogramming-paradigm
8mcq1 marks

Which type of feasibility study evaluates whether a system can be developed with the available technology ?

  • a

    Operational feasibility

  • b

    Social feasibility

  • c

    Technical feasibility

  • d

    Economical feasibility

software-engineeringfeasibility-study
9mcq1 marks

Which of the following is NOT a type of cloud computing service ?

  • a

    Infrastructure as a Service (IaaS)

  • b

    Platform as a Service (PaaS)

  • c

    Software as a Service (SaaS)

  • d

    Hardware as a Service (HaaS)

cloud-computingservice-models
B

Group 'B'

Short answer questions.

5 questions·5 marks each
10short5 marks

Write any three differences between DDL and DML. Give examples of each. [3+2]

OR

What is normalization ? Explain 2NF and 3NF. [2+3]

databasesqlnormalization
11short5 marks

Write JavaScript code to input any three numbers and find the smallest number among them. [5]

OR

Write a PHP script to connect to a MySQL database. [5]

javascriptphpmysql
12short5 marks

Write short notes on class and inheritance in oops with example. [5]

oopclassinheritance
13short5 marks

What is Requirement Gathering ? Explain different Requirement Gathering methods. [1+4]

software-engineeringrequirement-gathering
14short5 marks

What is AI ? Explain application areas of AI in education. [5]

artificial-intelligenceai-applicationseducation
C

Group 'C'

Long answer questions.

2 questions·8 marks each
15long8 marks

What is transmission medium ? Explain its major types with advantages and disadvantages. [2+6]

networkingtransmission-medium
16long8 marks

Write a C program that reads the account_number, name and address of ten customers from users and displays the account_number, name and address of these customers using Array and structure. [8]

OR

What are the components of a function of C ? Describe the Call - by - value and Call - by - reference and passing the function parameters. [4+4]

c-programmingarraystructure