(XII) NEB Computer 2079 (2022) QP

Sub Code 4281 'A' NEB GRADE XII 2079 ( 2022 ) Computer Science New Course ( For regular students ) Candidates are required to give their answers in their own words as far as practicable . The figures in the margin indicate full marks. Time : 2 hrs . Full Marks : 50 Attempt all the questions . Group ' A ' Rewrite the correct options of each questions in your answer sheet 9×1=9

  1. Which of the following SQL statement is used to DELETE rows from a database table ?
    1. DELETE
    2. REMOVE
    3. DROP
    4. CLEAR
  2. A field that is used to uniquely define a particular record in a table is called :
    1. Primary Key
    2. Entity
    3. Relationship
    4. Constraints
  3. What does " MAC " stands for in MAC Address ?
    1. Mandatory Access Control
    2. Media Access Control
    3. Micro Access Control
    4. Media Access Certificate
  4. What is the correct syntax for referring to an external JavaScript script ?
    1. < script src = " myscript.js " > < / script >
    2. < script href = " myscript.js " > < / script >
    3. < js href = " myscript.js " > < / js >
    4. < js src = " myscript.js " > < / js >
  5. Which of the following is the correct way of defining a variable in PHP ?
    1. A ) $variable name = value ;
    2. B ) $variable_name = value ; C ) $variable_name = value D ) $variable name as value ;
    3. What is the output of C program ?
      4. void main () { int b = 25 ; // b memory location = 1234 ; int *p ; p = & b ; printf ( " % d % d " , &b , p ) ; }
      1. A) 25 25 B) 1234 1234 C ) 25 1234 D ) 1234 25
      2. Which feature of OOP is illustrated the code reusability ?
        1. A ) Polymorphism B ) Abstraction C ) Encapsulation D ) Inheritance
        2. Which of following is the discovering requirement from a user in the requirement collection process
          1. A) Feasibility study B) Requirement Elicitation C) Requirement Specification D) Requirement validation
          2. What devices are detecting and responding to changes in an environment that are embedded in smart phones and an integral part of the Internet of Things ( IoT ) ?
            1. A) Wi - Fi B) Barcode C) RFID D) Sensors Group ' B ' Short answer questions 5x5 = 25
            2. Differentiate the centralized and distributed database system . OR What are the purposes of normalization ? Give an example of 2NF .
            3. Write a program to find the factorial of any given number using Javascript . OR How do you fetch data from database in PHP and display it in form ? Describe .
            4. Compare the OOPs and procedural programing language .
            5. What are the major activities performed to design the software ? Describe .
            6. Explain the popular five - application areas of AI . Group ' C ' Long answer questions 8x2 = 16
            7. 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 . 5 + 3
            8. What is structure ? Write a program to input roll , name and age of 5 students and display them properly using structure . ( 2 + 6 )
              9. #include<stdio.h> struct student { int roll; char name[30]; int age; }s[5]; int main() { int i; for(i=0;i<5;i++) { printf("Enter student roll,name and age : "); scanf("%d%s%d",&s[i].roll,s[i].name,&s[i].age); } printf("-------Output-------\n "); for(i=0;i<5;i++) { printf("%d\t%s\t%d\n",s[i].roll,s[i].name,s[i].age); } return 0; }
              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 .
              The End