Sub. code 4281
NEB — GRADE XII
2083
Old Question
Computer Science Question Paper 2083 (Old Question)
The candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.
Pass Marks : 20
सबै प्रश्नको उत्तर दिनुहोस् । (Attempt All Questions)
This old question question paper is for Class 12 Computer Science, 2083 (subject code 4281), carrying full marks of 50 with a pass mark of 20, to be completed within 2 Hours. Answers with step-by-step solutions are available for every question below.
Group A
Multiple Choice Questions
Records in database are also known as:
Data
Fields
Tuples
Keys
Which SQL statement displays the name and address of all students who live either in Kathmandu or Bhaktapur from the students table?
SELECT * FROM students WHERE address = "Kathmandu" OR address = "Bhaktapur";
SELECT name, address FROM Students WHERE address = "Kathmandu" OR "Bhaktapur";
SELECT * FROM students WHERE address = "Kathmandu" OR "Bhaktapur";
SELECT name, address FROM students WHERE address = "Kathmandu" OR address = "Bhaktapur";
The full form of OSI is:
Open Service Implementation
Open System Internet
Open Service Interconnection
Open System Interconnection
Which JavaScript method is used to write HTML output?
document.write()
document.output()
console.log()
document.writeHTML()
5. What will be the output of the following PHP code?
echo b;
?>
0
1
2
5
What does ++X do in a C program?
Returns value then increments
Increments then returns value
Decrement value
Returns original value
Which of the following feature allows the same method name to be used for different types/number of parameters in OOPs concept?
Abstraction
Encapsulation
Polymorphism
Inheritance
Which model follows a strict linear sequential phase order?
Agile
Waterfall
Prototype
Scrum
A device automatically adjusts room temperature based on real-time sensor data and internet connectivity. Which technology does this represent?
Desktop computing
Cloud storage
IoT (Internet of Things
Traditional Embedded System
Group B
Short Answer Questions
Compare the hierarchical database model and the relational database model. Write two advantages of each model.
Describe 2NF with example.
Write a JavaScript program that accepts three numbers as input and finds the smallest among them.
Write a PHP script that connects to a MySQL database named school, retrieves all records from the student table, and displays them in an HTML table.
What is OOP (Object Oriented Programming)? Describe any four features of OOP.
Explain about technical and economic feasibility.
Explain the basic concept of cloud computing with any three advantages.
Group C
Long Answer Questions
Explain twisted pair cable, coaxial cable and optical fibre cable.
Write a C program to input a number and check whether it is positive, negative or zero using a user-defined function.
Write a C program to generate the Fibonacci series of the first two numbers, 7 and 14, up to 10 terms using a user-defined function.
Write a C program that reads the student's roll number, name, section and mark of 10 students using an array of structure and display.