2081 Supplementary Examination SET A and SET B

 

NEB - GRADE XII

2081 (2024)

Computer Science

Supplementary Examination

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.                                                          SET A                                                   Full Marks: 50

Group 'A'

Multiple choice questions                                                                     [9x1=9]  

1) Which SQL Query selects all records from a table named "Address" where the value of the column "Address" has its second last letter ending with an "a"?

A) SLELECT * FROM Address WHERE Address = 'a'

B) SELECT * FROM Address WHERE Address LIKE 'a_%'

C) SELECT * FROM Address WHERE Address LIKE '% a'

D) SELECT * FROM Address WHERE Address LIKE '%a_%'

 

2) What is used for data security in the database?

A) Data integrity

B) Data encryption

C) Data auditing

D) Data authentication

 

3) Which SQL command is used to define the field ID of the table student as PRIMARY KEY which has already been created with the schema (ID, Name, DOB, Address)?

A) ALTER TABLE Student ADD PRIMARY KEY (ID);

B) INSERT INTO Student ID PRIMARY KEY (ID);

C) ALTER TABLE Student ADD ID PRIMARY KEY;

D) INSERT INTO Student ADD ID PRIMARY KEY;

Note: A) ALTER TABLE Student ADD PRIMARY KEY (ID); Although this is close, it is not the correct syntax. It would be correct if the ID was not already created.

 

4) What type of transmission media is commonly used in LAN networks due to its cost-effectiveness and flexibility?

A) Twisted pair cable

B) Microwave

C) Digital subscriber line

D) Satellite

 

5) What is a scripting language that runs for the browser of the user's Computer?

A) Object-oriented programming

B) Server-side scripting language

C) Client-side scripting Language

D) Structure programming Language

 

6) Predict the correct output of the following PHP code.

                       <?php $ x=30; $y = 30; 

                       if ($x>$y) echo "CDC, Nepal.";

                       else echo "NEB, Nepal."; ?>

A) 30 is not greater than 30.                                                              

B) CDC, Nepal                          

C) NEB, Nepal.                                         

D) No output.

7) Analyse the expected output of the provided in JavaScript snippet. 

                       <script> var p=120, Q=O; document. Write (P/Q); </script> 

A) Garbage value                          B) 0                           C) 120                               D) Infinity is pointed

 

8) Which feature of OOPs is used to derive the attributes and methods from base class?

A) Encapsulation                        

B) Inheritance                         

C) Polymorphism                                

D) Data hiding

 

9) What is the Primary focus of the maintenance phase in the SDLC?

A) Conducting performance testing.

B) Enhancing system functionality based on user feedback.

C) Developing new features and modules for the system.

D) Documenting system requirements and specifications.

 

Group 'B'

Short answer questions                                                                          [5×5=25]

10. Evaluate the normalization process in relational databases. Provide examples to illustrate 2NF normalization form.

OR

Write the SQL DDL statement to create an employee table with the mentioned schema with the following attributes.

Field	Data type	Constraints
Employee ID	INT	PRIMARY KEY
Name	CHAR(30)
Address	CHAR(20)
Gender	CHAR(2)
Post	CHAR(15)

11. Write a JavaScript code snippet, along with HTML, that displays the multiplication table of an entered number.

OR

Develop a PHP code to add a record like (601, Raju, M, 12-06-2002, Kathmandu) in the table named info_stud having structure (reg_no integer, name character 25, gender character 1, dob character 10, address character 25) of the database named "School".

12. Define the term "Class". Explain the concept of encapsulation. How does it help in achieving data hiding in object-oriented programming?

13. How does the System Development Life Cycle (SDLC) facilitate the efficient planning and execution of software development projects?

14. Define Robotics. Explain the application of Robotics in various fields such as industry and healthcare.

 

Group 'C'

Long answer questions                                                                                    [2×8=16]

15. a) Why do network designers prefer to use switches in a LAN network? Explain briefly with any three suitable reasons.

b) Why do people prefer star topology as a LAN to set up in an organization like a bank? Give any three suitable reasons/purposes.

 

16. a) Write a C program to check whether the given number is positive or negative using a user-defined function.

      b) Write a C program to find the product of two numbers using a pointer.

OR

        Write a C program to store 10 student records with fields for roll numbers, names, and marks in computer    science. Process and display the roll numbers, names, and marks of students.

 

THE END

 

 

 

 

 

NEB - GRADE XII
2081 (2024)
Computer Science
Supplementary Examination

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.                                                          SET B                                                   Full Marks: 50

Group ‘A’

Multiple choice questions                                                                     [9x1=9]  

1.       The statement in SQL which allows to change the definition of a table is:
a) Delete
b) Update
c) Create
d) Alter

2.       Which of the following key is considered unique in a table?
a) Candidate key
b) Primary key
c) Super key
d) Foreign key

3.       With SQL, how will you select records of those employees from a table named "staff" whose salary is less than 20000?
a) Select * from staff where salary is less than 20000;
b) Select * from staff where salary <20000;
c) Select * from staff where salary <= 20000;
d) Select * from staff where salary >20000;

4.       The full form of OSI is:
a) Operating System Interconnection
b) Operating System Information
c) Open System Interface
d) Open System Interconnection

5.       What type of language is PHP?
a) Client-side scripting
b) Server-side scripting
c) User-side scripting
d) Machine level

6.       Which JavaScript method is used to write HTML output?
a) console.log()
b) document.output()
c) document.write()
d) document.writeHTML()

7.       Which sign is used to declare variables in PHP?
a) @
b) *
c) ^
d) $

8.       Which of the following is not an OOPs concept?
a) Inheritance
b) Polymorphism
c) Data Abstraction
d) Exception

9.       What is the primary goal of the system Testing phase in SDLC?
a) Creating system design
b) Gathering requirement
c) Identifying and fixing defects
d) Writing code

Group 'B'

Short answer questions                                                                             [5×5=25]

10. List the different types of database models. Explain the Relational Database model in brief.
    OR
    Write any five differences between centralized and distributed database models.
11. Write a program in JavaScript to find the largest number among three numbers.
    OR
    Write a PHP program to swap two numbers.
12. How are programmers benefited from inheritance and polymorphism features of OOPs?
13. Explain the importance of the system analysis phase of SDLC.
14. Define the terms Big Data and IoT (Internet of Things).

 

Group 'C'

Long answer questions                                                                                               [2×8=16]

15. Explain client-server and peer-to-peer network architecture with their diagrams. Write any two advantages and disadvantages of each.
16. Create a structure named "player" to store details pname, game, age, and salary. Write a C program to input details for five players and display their information in proper format.
    OR
    Write a C program that illustrates the use of fprintf() and fscanf() functions of file handling.

 

THE END