Model Question Set 1 i. Artificial intelligence ii.

Cloud computing
iii. Virtual reality iv. Big data
Group ‘A’ Group ‘B’
(Multiple Choice Questions) (Short Answer Questions)
1. Select the best alternative. (9x1=9) Answer the following questions. [5x5=25]
a. The remaining attributes from the candidate key which is not selected as 2. Differentiate between Centralised database and distributed database. [5]
primary key becomes ……………… key. OR
i. Foreign ii. Alternate iii. Composite iv. Primary List the different types of database model and explain any two of them.

b. Which SQL query is used to display the records whose name ends with N 3. What is server side scripting? Write a program in JavaScript to display the
from the table named 'Employees'? factorial of the given number using function. [2+3]
i. SELECT * FROM Employees WHERE name LIKE '%N';
ii. SELECT * FROM Employees WHERE name LIKE 'N%'; 4. What is OOP? Write down the advantages and disadvantages of OOP.
iii. SELECT * FROM Employees WHERE name = '%N'; [1+4]
iv. . SELECT * FROM emp WHERE name = 'N%'; OR
Differentiate between client server network and peer to peer network.
c. Which of the following transmission media uses light to transfer data?
i. UTP ii. STP iii. Coaxial Cable iv. Optical fiber 5. Explain the various stages of SDLC.

d. Which of the following is the correct syntax to display "Hello World" in 6. Explain Artificial Intelligence and Cloud Computing with their
PHP? application.? [1+4]
i. display "Hello World" ii. printf "Hello World"
iii. echo "Hello World" iv. alert "Hello World" Group ‘C’
(Long Answer Questions)
e. Every PHP statements are written within ……….. tag. Answer the following questions. [2x8=16]
i. <php ii. <php? iii. ?> iv.<?php 7. a. What is pointer ? Write down the advantages of pointer. [3]
b. Write a program that reads Name, Post and Salary of ‘n’ employees and
f. Which of the following mode allows the user to add records in the existing display the record in appropriate format using Structure. [5]
file? 8. What is network topology Explain the different types of computer
i. w ii. r iii. e iv. a network with its features. [2+6]
OR
g. The ability of an object to take on many forms is called …………… Draw the block diagram of communication system and explain each of its
i. inheritance ii.polymorphism iii. class iv. encapsulation components. [8]
The End
h. What are the different methods of data gathering?

i. brainstorming ii. interview iii. Focus group iv. All

i. …………. is an artificial environment created by using multimedia

technology that makes user interact in a simulated environment.
Model Question Set 2 i. …………. is a term used to describe a collection of data that is huge in size
and yet growing exponentially with time.
Group ‘A’ i. Large Data ii. Cloud computing
(Multiple Choice Questions) iii. Virtual reality iv. Big data
1. Select the best alternative. (9x1=9) Group ‘B’
a. Each column in a table is known as ………….. which gives the smallest (Short Answer Questions)
unit of information. Answer the following questions. [5x5=25]
i. Attribute ii. Record iii. Tuple iv. Primary 2. Explain Candidate key, Primary key and Alternate key with examples. [5]
OR
b. Which statement is used modify the data types of the field? Explain the different types of DDL with examples
i. Update ii. Alter iii. Modify iv. Set
3. Write the features of JavaScript? Write a program in PHP to display the
c. Which topology uses terminator at the either end of the cable? product of any three numbers. [2+3]
i. Bus ii. Star iii. Mesh iv. Ring OR
Explain the different types of operators used in PHP.
d. Which of the following is the correct syntax in JavaScript?
i. var n= “enter the number”; 4. What is OOP? Differentiate between OOP and POP. [1+4]
ii. var n=prompt(Enter the number”) ;
iii. var n = (Enter the number”)prompt ; 5. Explain water fall model with its advantages and disadvantages. [5]
iv. All
6. Write short notes on big data and E-governance. [5]
e. Which of the following statement is used to store information in the file?
i. fscanf ii. gets iii. printf iv.fprintf Group ‘C’
(Long Answer Questions)
f. The length of IPV6 address is …………… bits Answer the following questions. [2x8=16]
i. 32 ii. 64 iii. 128 iv. 256 7. Define Structure in C. Write a program to create a file named “emp.txt”
and store Name, Address and Salary of employees. The program should
g. Which of the following is not the features of OOP? also display all the records that are stored in the file. [2+6]
i. It follows the bottom up approach of execution. 8. Explain the different layers of OSI reference model. [8]
ii. It divides the large program into objects. OR
iii. Data is secured as data can be hidden in three modes public, private, and What is IP address? Differentiate between IPV4 and IPV6.

protected. The End

iv. The priority is given to function rather than the data.

h. DFD stands for ……………

i. Data Function Diagram ii. Data Flow Diagram
iii. Digital Function Diagram iv. Digitally Flow Diagram
Model Question Set 3
i. ……………….. is the delivery of on-demand computing services from
Group ‘A’ applications to storage and processing power typically over the Internet.
(Multiple Choice Questions) i. Artificial intelligence ii. Cloud computing
1. Select the best alternative. (9x1=9) iii. Virtual reality iv. Big data
a. ……….. database model organizes data more like a graph and can have Group ‘B’
more than one parent node. (Short Answer Questions)
i. Relational ii. Hierarchical iii. Network iv. Object Oriented Answer the following questions. [5x5=25]
2. Write the SQL query for the following operations.
b. Which of the following is not the feature of 1NF?
i. It should only have single(atomic) valued attributes/columns. Table name: Employee
ii. All the columns in a table should have unique names. Emp Id Name Post Address Age Salary
iii. It should not have Partial Dependency.
iv. The order in which data is stored, does not matter. 1011 Ramesh Manager Kathmandu 60 65000

c. Which device selects the best and appropriate path in a netork?? 326 Bhuvan Officer Pohara 45 55000
i. Hub ii. Bridge iii. Modem iv. Router
2100 Shyam Programmer Kathmandu 40 90000
d. Which of the following is the features of JavaScript?
i. JavaScript is an interpreter based programming language. 532 Sawal DBA Bhaktapur 33 68000
ii. JavaScript is a lightweight scripting language because it is designed for
executing the scripts in the user’s browser software.
590 Dinesh DBA Dharan 40 50000
iii. It can easily be integrated with HTML
iv. All
156 Niliska Manager Surkhet 39 70000
e. Which of the following statement is used to delete the file?
i. kill ii. delete iii. remove iv.erase a. Display all the records of Employees whose Post is Manager.

f. The length of IPV4 address is …………… bits b. Display Emp Id, Name and Age of staffs.
i. 32 ii. 64 iii. 128 iv. 256
c. Update the Salary of Staffs by 10% whose Post is DBA
g. ……………. is a group of objects which shares some common properties
and behaviors. d. Delete the record whose age is greater than 58.
i. Polymorphism ii. Class iii. Abstraction iv. Encapsulation e. Display Name, Post and Salary whose Name starts with ‘S’.

h. ERD stands for …………… 3. What is PHP? Write the features of PHP. [5]
i. Entity Relative Diagram ii. Enormous Relative Digital OR
iii. Extensive Relationship Diagram iv. Entity Relationship Diagram
Explain different data types used in JavaScript.

4. Explain inheritance and polymorphism on OOP. [5]

5. Explain prototype and agile model with its advantages and

disadvantages. [5]

6. Write short notes on M-Commerce and E-Medicine. [5]

Group ‘C’
(Long Answer Questions)
Answer the following questions. [2x8=16]
7. a. Differentiate between Structure and Union. [4]
b. Write a program to display the factorial of the given number using
recursion.

8. What is computer network? Write the advantages and disadvantages of

computer network? [8]
OR
What is network toplogy? Explain any four topology with neat diagram.
The End
Model Question Set 4 (Short Answer Questions)
Answer the following questions. [5x5=25]
Group ‘A’ 2. Explain 1NF and 2NF with examples. [5]
(Multiple Choice Questions) OR
1. Select the best alternative. (9x1=9) What is computer network? Differentiate between LAN and WAN.[1+4]
a. Which of the following attributes can be further divided into other
attributes? 3. Write the advantages of using function? Write a program in C to display the
i. Simple ii. Complex iii. Composite iv. Multi valued greatest number among three numbers using function. [2+3]

b. Which SQL query is used to delete the record of Employees whose Age is 4. Define Php. Write a program in Php to display the factorial of the given
greater than 58 from table named “Employees” ? number. [2+3]
i. DELETE FROM Employees WHERE Age>58 ; OR
ii. DROP FROM Employees WHERE Age>58 ; Define JavaScript. Write a program in JavaScript to display the factors of
iii. ERASE FROM Employees WHERE Age>58 ; the given number. [2+3]
iv. ALTER FROM Employees WHERE Age>58 ;
5. Explain POP and OOP with adantages . [5]
c. Identify the odd one from the list.
i. Microwave ii. Infrared iii. Radiowave iv. Optical fiber
6. What is mobile computing? Write its advantages. [5]
d. Which of the following variable name is valid in PHP? Group ‘C’
i. sum ii. $Sum1 iii. _Sum iv. $1Sum (Long Answer Questions)
Answer the following questions. [2x8=16]
e. Which of the following is the data type used in JavaScript? 7. Write a program to input Roll number, Name and Gpa of ‘n’ students
i. var ii. const iii. let iv. All and display the record whose Gpa is greater than 3.5 in appropriate
f. Which device converts digital signal into analog and vice versa? format using Structure. [8]
i. Modem ii. Repeater iii. Bridge iv. Gateway 8. a. Explain simplex, half duplex and full duplex mode with examples.
[4]
g. …………. is a virtual networking simulation software designed to learn b. What is transmission media? Differentiate between bounded and
and understand various concepts in computer networks.
i. Remote login ii. Packet tracer iii. Simulator iv. Matlab unbounded transmission media with examples. [4]

h. Which SQL query is used to modify the existing records in the database? The End
i. Truncate ii. Alter iii. Update iv. Modify

i. Which of the following database model organizes the data in the table in the
form of row and columns.
i. Network ii. Relational iii. Hierarchical iv. Object Oriented
Group ‘B’