This page includes the curriculum created by the Curriculum Development Center (CDC), notes for the reference study, and old and model test questions. Its user interface is very simple to use. By selecting the tabs, you can go to various units and chapters, model questions.

Title	Computer II
Course code	Com. 428
Nature of course	Theory + Lab
Full marks	75 + 25
Pass marks	27 + 13
Credit Hrs	5 hrs
Elective/Compulsory	Elective

Syllabus
Note
Old Question
Unit-Wise Question

Secondary Education Curriculum
2078
Computer

Working hrs: 160

1. Introduction

The world has witnessed a radical change in the field of Information and Communication Technology (ICT) in recent and this process is still going on. The relevance of computer education has been increasing day by day. Realizing the same the curriculum of computer science for Grades 11 and 12 has been developed according to the National Curriculum Framework, 2076. The study of this course will help the students to enter the job market. This will also provide basis for the students to pursue their further study in the field.

This curriculum comprises of an introduction to basic computer system, the basic number system and Boolean logic, computer software and operating system, application package, multimedia and network. It also includes contents of web technology, programming, information security and cyber law, digital society and computer ethics and recent trends in ICT. The course itself is of practical nature and the pedagogical approaches in delivering the course should consider the balance between theory and practice. The same applies in case of student evaluation procedure too.

The curriculum has been divided to different sections: level-wise competences, grade-wise learning outcomes, scope and sequence of contents with their elaboration, some indication to learning facilitation process and student assessment.

2. Level-wise competencies

Use operating system, word processor, spread sheet and apply in real-life and educational contexts.
Design website using new web technologies.
Demonstrate the programming concept and logic into software development process.
Use Database concept in basic SQL level.
Apply networking concept into LAN and wireless network.
Define OOPs concept and trace the recent trends of technological enhancement in 21st century.

Scope and Sequence of Contents

1. Database Management System (DBMS) (12hrs)

Introduction to data, database, Database system, DBMS
Field, Record, Objects, Primary Key, Alternate key, Candidate key
Advantages of using DBMS
DDL (Data Definition Language) and DML (Data Manipulation Language)
Database Model: Network Model, Hierarchical Model, Relational database model
Concept of Normalization: 1NF, 2NF, 3NF
Centralized Vs. Distributed Database
Database Security

2. Data Communication and Networking (15hrs)

Basic elements of Communication System:
Concept of Communication System
Block Diagram of communication System /Model
Elements of Data Communication/Transmission
Simplex, Half duplex and Full duplex communication mode
Concept of LAN and WAN
Transmission Medium: Guided and Unguided
Transmission impairments terminology (Jitter, Singing, Echo, Crosstalk, Distortion, Noise, Bandwidth, Number of receivers)
Basic concept of Networks Architecture: Client Server and Peer-to-peer
Some Basic Terms and Tool Used in Computer
Network: IP Address, Sub Net Mask and Gateway, MAC address, Internet, Intranet, Extranet
Network Tool: Packet tracer, Remote Login Network Connecting Devices: NIC, Modem, router, switch
Network Topologies: Bus, Ring and star topology
Basic Concept OSI Reference Model
Internet Protocol Addressing

3. Web Technology II (12hrs)

Introduction
Server side and Client-Side Scripting
Introduction of internet technology
Adding Java script to HTML page
Java script fundamental
Java Script Data types
Variables and operators
Functions and control structure if-else, if-elseif, switch-case, for, while, do while loop
Object based programming with Java Script and Event handling
Image, event and form objects
Form validation, Query
Server Side Scripting using PHP
Introduction to PHP: Hardware and Software Requirements
Object oriented programming with server side scripting
Basic PHP syntax
PHP data types

4. Basic Programming in PHP (12hrs)

Operators (Arithmetic, logical, comparison, operator precedence)
Variables Manipulation
Database Connectivity
Connecting server side script to database
Making SQL queries
Fetching data sets getting data about data
Creating SQL database with server side scripting
Displaying queries in tables

5. Programming in C (10hrs)

Review of C programming concept
Functions
Concept of library and user defined functions and advantages
function definition, prototype, call and return statements
Accessing a Function by passing values
Concept of storage: automatic and external
Concept of Recursion: factorial and Fibonacci problems
Structures and Unions
Structure: Definition, Declaration, Initialization and Size of Structure.
Accessing member of structure
Array of structure
Union: Definition, Declaration
Difference between union and structure.
Pointers
Definition of Pointer
Address (& and indirection (*) operator
Pointer Expression and Assignment
Call by values and call by reference
Working with Files
Concept of Data File
Sequential and Random File
File manipulation function: putw, getw, putc, getc, fscanf, forintf
Opening, Reading, Writing and Appending data file

6. Object-Oriented Programming (OOP) (10hrs)

Programming paradigms: procedural, structural and object oriented Features of
OOP: Class, Object, Polymorphism and Inheritance Advantages of 00P
Application of 00P

7. Software Process Model (SPM) (10hrs)

Software Project Concept
Concept of software development process
Concept SDLC life cycle
System Analyst Vs Software Engineer
Requirement Collection Methods
Concept of system design
Software and quality
Software development model: waterfall, prototype, agile

8. Recent Trends in Technology (8hrs)

Concept of Artificial Intelligence (AI) and Robotics
Concept of Cloud Computing
Concept of Big Data
Concept of Virtual Reality
Concept of e-com, e-medicine, e-gov.
Concept of Mobile Computing
Concept of Internet of things (loT)

1. Database Management System (DBMS)
2. Data Communication and Networking
3. Web Technology II
4. Basic Programming in PHP
5. Programming in C
6. Object-Oriented Programming (OOP)
7. Software Process Model (SPM)
8. Recent Trends in Technology

Fullscreen

2079 Model
2078 Model
Set a
Set b
Set c
Set d
Set e
Set f
Set g
Set h

4281.-Computer-Science Download

Model Question NEB
Subject : Computer Science (428)
Class XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub)
Time: 3 Hours

Group ‘A’

Multiple Choice questions (9 * 1=9)

Tick the correct answer.

1. Which of the statements are used in DDL?
A)Create, alter and drop B) Create, insert and select
C) Insert, update and delete D) Delete, alter and drop
2. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
A) SELECT * FROM Persons WHERE FirstName=‟a‟
B) SELECT * FROM Persons WHERE FirstName LIKE „a%
C) ‟SELECT * FROM Persons WHERE FirstName LIKE „%a‟
D) SELECT * FROM Persons WHERE FirstName=‟%a%‟
3. Which of the following statements is true about a star network topology?
A) Each device is connected to a switch or hub
B) Each device is connected to each other
C) Each device is connected in a trunk
D) Each device is connected to a terminal
4. Which of the following is the correct syntax to display “Stay Safe” in an alert box using JavaScript?
A) alert-box(“Stay Safe”);            B) confirm(“Stay Safe”);
C) msgbox(“Stay safe”);               D) alert(“Stay Safe”);
5. What is the use of tag ?
A) To insert an image                    B) To create a link
C) To create a hyperlink               D) To create a list
6. What is the output of given C program?
void main()
{
char str1[] = “FIRST”;
char str2[20]; strcpy(str2,str1);
printf(“%s %s “,str1,str2);
printf(“%d”, (str1!=str2));
printf(“%d”, strcmp(str1,str2));
}
A) FIRST FIRST 0 0                    B) FIRST FIRST 1 1
C) FIRST FIRST 1 0                     D) FIRST FIRST 0 1
7. Where is a class derived in inheritance?
A) Superclass         B) Subclass                C) Subsetclass        D) Relativeclass
8. Which of these is the correct order of the SDLC?
A) Analysis, Design, Coding, Testing, Implementation
B) Analysis, Design, Testing, Implementation, Coding
C) Implementation, Coding, Analysis, Design, Testing
D) Design, Testing, Implementation, Coding, Analysis
9. Why is cloud computing popular nowadays?
A) Cost-sharing and easily accessible
B) As modern technology and costly
C) Accessible and freely available
D) Affordable to all

Group B

Short Answer Questions (5 * 5=25)

Explain 2NF and 3NF with examples.
OR
Demonstrate the basic DML statement with an example.
Write a function to add any two numbers in Javascript.
OR
Demonstrate the external CSS implemented in the web page.
Describe any five features of OOPs.
What are the different stages of software planning? Describe.
Define the concept of AI and IoT. (2+3)

Group C

Long Answer Questions (2 ´8=16)

6. How do you implement the Class C IP address in the local area network? Describe.
7. Write a program to enter ten integer numbers into an array, sort and display them in ascending order.
OR
Write a program to read the marks of any 5 students in a subject and count how many students are pass and fail.

Model Questions – 1
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

NIC card is used for LAN connection.
a. True b. False
Spiral is a …………. .
a. SoftwareTesting phase
b. System Development model
c. None of the above
Who carries out the coding part?
a. Programmer b. System Analyst c. Client d. None
Physical layout of computer in network is called………
a. Network
b. internet
c. Topology
d. None of the above
…………is a component of multimedia.
a. Speaker c. Monitor
b. Sound card d. All of them
……….. data type contains numbers having decimal point.
a. Char b. Int c. Float d. None
To use the strcpy() function, which header file should be included?
a. conio b. stdio c. string d. math
The last value of the series in looping is called …….
a. Test Expression b. initialization
c. Increment/decrement d. All of them
Which operator is logical OR operator?
a. || b. ! c. && d. None

Group ‘B’

II. Write short answers to the following questions. [5*5=25]
1. Who is a DBA? What are his good qualities?
2. Write a function simple(p,t,r) in C to compute Simple Interest.
3. What is IoT? List any 3 of its applications.
4. What is Cyber Law? Explain hacking.
5. What is client server network? Explain with a diagram.

Group ‘ C’

III. Give long answer to the following questions (Any two): [8×2=16]

Write codes for JavaScript to create a mark sheet using if structure and find the Grades based on the following :
Percentage                       Grade
>= 90                          A+
>=80 and <90                   A
>=70 and <80                   B+
>=60 and <70                   B
>=50 and <60                  C+
<50                                C
Explain types of Computer Network on the basis of area it covers.
Write a C program to input name, address and salary of a person and store it in a data file “employee.dat”.

Model Questions – 2
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub )
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

The ………… is the physical path over which a message travels.
a. protocol b. medium c. signal d. None
The key that uniquely identifies a record is called
a. Field name b. Unique key c. Primary key d. Key record
Systems are modified whenever
a. User’s requirement change.
b. New computers are introduced in the market
c. New software tools become available in the market
d. Other similar organization modify these system
………… is used to input records in MS-Access.
a. Report b. Table c. Form d. None
Network that covers the longest distance is called ……….. .
a. LAN b. MAN c. WAN d. HAN
………….. can hold dissimilar data.
a. array b. structure c. pointer d. variable
Which operator is used to compute the integer division?
a. / b. \ c. % d. None
Which loop is pre-test loop?
a. for loop b. while loop c. do while loop d. None

II. Write short answers to the following questions: [5×5=25]

What is a database? What are the objectives of a database?
What is transmission media? Explain any two different types of transmission media.
Write a structure in C to initialize item, quantity and rate and calculate total amount.
Describe switch case structure in JavaScript with syntax and one example
What is a pre-test loop? Write JavaScript codes to print given series. 1,4,9,16…..100 .

III. Give long answer to the following questions (Any two): [8×2=16]

Using Switch case , Write JavaScript codes to serve the following Book List:
Computer Science
Account
Economics
Math’s
Social
English.
Explain the different network connecting devices.
Write a C program to read marks of any 10 students in computer science and count how many have scored above 80.

Model Questions – 3
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

Who carries out the analysis phase?
1. Programmer b. System Analyst c. Client d. None
Decision tree is a tool to :
a. Design System
b. Test The system
c. Selling the system
d. None of the above
is message sending through electronic medium.
a. Internet c. Post
b. Email d. Hardcopy.
One- Dimensional array has …………. row or column.
a. 2 b. 1 c. 4 d. 5
To use the strlen() function, which header file should be included?
a. conio b. stdio c. string d. math
Relational Operators are :
a. Comparison of data b. addition of variables
c. Logical treatment d. All of them
Which operator is logical AND operator?
a. || b. ! c. && d. None
Which loop is post-test loop?
a. while loop b. do while loop c. for loop d. None
In C, int data type has memory allocation of :
a. 4 bytes b. 2 bytes c. 8 Bytes d.1 bytes

II. Write short answers to the following questions: [5 * 5=25]

Who is a System Analyst? List out the roles of System Analyst.
Explain waterfall model of System Development Life Cycle with a diagram. Write a program to determine whether an input number is odd or even.
Explain JavaScript if structure with the help of example program.
Write C- program to input number (from 1-7) and determine day of the week (e.g. 1 for Sunday).
What is a loop? Write JavaScript codes to display fibonacci series upto 10th term (1 1 2 3 5…10th term).

III. Give long answer to the following questions: [8 * 2=16]

WAP to create a mark sheet using if structure and find the Grades based on the following :
Marks                               Grade
M<100 and > 90                  A+
M<90 and >=80                   A
M<80 and > 70                    B+
M<70 and >=60                   B
M<60 and > 50                   C+
M<50 and >=40                   C
M<40 and > =30                  D+
M<30 and >=20                   D
Explain the types of array? Write a program to multiply two 2X2 arrays and display the result.
Write a C program to input name, address and salary of a person and store it in a data file “items.dat”. Also open the file and display the contents.

Model Questions – 4
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

MS-Access is ……………… .
a. Relational Database Management System.
b. Word Processing Software
c. Presentation Software
d. None of the above
Table is ……………. MS-Access.
a Primary Element b. Filtered information c. Data Collection d. None
An illegal activity done through internet that harms other intellectual right is :
a. Murder. b. Suicide. c. Cyber Crime. d. Virus.
………. can hold similar data.
a. array b. structure c. pointer d. variable
Which operator is used to compute the integer division?
a. / b. \ c. % d. None
Which loop is pre-test loop?
a. for loop b. while loop c. do while loop d. None
In C, ‘7’ is a?
a. Numeric constant b. Character constant c. Number d. None
Which of the following falls in control structure?
a. switch case b. loops c. if else d. All of them
Which of the following is valid for JavaScript
a. Var sname; b. Int sname; c. Char sname; d. None;

Group ‘B’

II. Write short answers to the following questions: [5´5=25]

What is feasibility study? Explain its types.
Explain spiral model of System Development Life Cycle with a diagram.
What is AI? Explain the application areas of AI.
WAP to input number (from 1-7) and determine day of the week (e.g. 1 for Sunday).
Write JavaScript codes to return name of the students starting from A.

Group ‘ C’

III. Give long answer to the following questions: [8´2=16]

Using Switch case , Write a program JavaScript codes to serve the following Book :
Computer Science
Account
Economics
Math’s
Social
Define an array. Write a program to add two 2X2 arrays.
Write a C program to add name, address and salary of a person into a data file “students.dat”. Also open the file to read the contents.

Model Questions – 5
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

C is a ………..
a. Relational Database Management System
b. Structured programming language
c. Presentaion software.
d. None of above
Query is ……. in MS-Acess.
a. Object b. Required output c. Data collection d. None of the above
The component of multimedia is :
a. Speaker b. Sound card c. Microphone d. All of above
…………. can hold dissimilar data.
a. array b. structure c. pointer d. variable
OR logical operator in C is denoted by:
a. / b. || c. % d. None
For menu driven program, we use ……………. control structure.
a. for b. while c. switch d. do
A character constant must inside .
a. ‘ ‘ b. ” ” c. { } d. ( )
Which data type holds numbers with decimal point?
a. int b. float c. char d. All of them
Which of the following displays a box in JavaScript?
a. document.write b. alert c. printf; d. None;

Group ‘B’

II. Write short answers to the following questions: [5 * 5=25]

Explain the roles of a DBA.
Why is system maintenance necessary in SDLC?
What is Virtual Reality? Write any two applications of VR.
WAP to input number (from 1-12) and determine name of the month (e.g. 1 for January).
Write JavaScript codes to find sum, product and difference of 56 and 72.

Group ‘C’

III. Give long answer to the following questions: [8* 2=16]

Describe ‘Sequence’, Selection’ and ‘Loop’ with flowchart. Write a program to check if a number is odd or even. Define an array. Write a program to add two 2X2 arrays.
Write a program which asks the user to input ‘n’ terms of number and find out the greatest and smallest number among those numbers.

Model Questions – 6
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

Library function pow() belongs to which header file?
a. stdio.h b. conio.h c. math.h d. string.h
Which of the following is/are the main goals of a distributed database?
a. Interconnection of database
b. Incremental growth
c. Reduced communication overhead
d. All of the above
An unauthorized user is a network …… issue:
a. Performance b. Reliability c. Security d. All
What is the full form of SQL?.
a. Structured Query List
b. Simple Query Language
c. Structured Query Language
d. None
PHP is an example of …… scripting language.
a. Server side b. Client side c. Browser side d. None
Using encapsulation data security is …….
a. Not ensured b. Ensured to some extend c. Purely ensured d. Very low
If the mode in file in C includes b after the initial letter, what does it indicate?
a. text file b. big text file c. binary file d. blueprint text
Library function getch() belongs to which header file?
a. math.h b. string.h c. conio.h d. ctype.h
Which of the following keyword is used for creating a function in JavaScript?
a. Void b. Int c. Main d. Function

Group ‘B’

II. Write short answers to the following questions : [5 * 5=25]

What is a primary key? What are the features of good primary keys?
What are documentation techniques? Explain with examples.
What is cloud computing? What are its components?
Describe the different mode of file handling concept in C.
Write JavaScript codes to find sum, product and difference of 56 and 72.

Group ‘C’

III. Give long answer to the following questions : [8 * 2=16]

Describe fprintf and fscanf file handling functions. Write a program which writes “welcome to Nepal” in a file.
Write a function to input two numbers and display their sum when the user click on ‘ADD’ button in JavaScript.

Model Questions – 7
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

Who carries out the analysis phase?
a. Programmer b. System Analyst c. Client d. None
Decision tree is a tool to :
a. Design System b. Test The system
c. Selling the system d. None of the above
…………. is message sending through electronic medium.
a. Internet b. Email c. Post d. Hardcopy.
One- Dimensional array has ……….. row or column.
a. 2 b. 1 c. 4 d. 5
To use the strlen() function, which header file should be included?
a. conio b. stdio c. string d. math
Relational Operators are :
a. Comparison of data b. addition of variables
c. Logical treatment d. All of them
Which operator is logical AND operator?
a. || b. ! c. && d. None
Which loop is post-test loop?
a. while loop b. do while loop c. for loop d. None
In C, int data type has memory allocation of :
a. 4 bytes b. 2 bytes c. 8 Bytes d.1 bytes

Group ‘B’

II. Write short answers to the following questions: [5 * 5=25]

Who is a System Analyst? List out the roles of System Analyst.
Explain waterfall model of System Development Life Cycle with a diagram.
What is computer crime? Explain plagiarism.
Explain JavaScript if structure with the help of example program.What is a loop?
Write JavaScript codes to display fibonacci series upto 10th term (1 1 2 3 5…10th term).

Group ‘C’

III. Give long answer to the following questions: [8 * 2=16]

WAP to create a mark sheet using if structure and find the Grades based on the following :
Marks                               Grade
M<100 and > 90                  A+
M<90 and >=80                   A
M<80 and > 70                    B+
M<70 and >=60                   B
M<60 and > 50                   C+
M<50 and >=40                   C
M<40 and > =30                  D+
M<30 and >=20                   D
Explain the types of array? Write a program to multiply two 2X2 arrays and display the result.

Model Questions – 8
Subject : Computer Science
GRADE: XII

Full Marks: 50 (9 marks Obj + 41 Marks Sub
Time: 2 Hours

Group ‘A’

I. Choose the best alternative: [1×9=9]

MS-Access is .
a. Relational Database Management System. b. Word Processing Software
c. Presentation Software d. None of the above
Table is ……… MS-Access.
a Primary Element b. Filtered information
c. Data Collection d. None
An illegal activity done through internet that harms other intellectual right is :
a. Murder. b. Suicide. c. Cyber Crime. d. Virus.
…………. can hold similar data.
a. array b. structure c. pointer d. variable
Which operator is used to compute the integer division?
a. / b. \ c. % d. None
Which loop is pre-test loop?
a. for loop b. while loop c. do..while loop d. None
In C, ‘7’ is a?
a. Numeric constant b. Character constant c. Number d. None
Which of the following falls in control structure?
a. switch case b. loops c. if else d. All of them
Which of the following is valid for JavaScript
a. Var sname; b. Int sname; c. Char sname; d. None;

Group’ B’

II. Write short answers to the following questions: [5 * 5=25]

What is feasibility study? Explain its types.
Explain spiral model of System Development Life Cycle with a diagram.
WAP to determine whether an input number is exactly divisible by 7 or not.
Write JavaScript codes to display odd numbers from 1-59.
Write the syntax of do loop. Write JavaScript codes upto 10th term (7, 10, 13…10th term) using do loops.

Group ‘ C’

III. Give long answer to the following questions : [8 * 2=16]

Using Switch case , Write a program JavaScript codes to serve the following Book :
Computer Science
Account
Economics
Math’s
Social
English.
Define an array. Write a program to add two 2X2 arrays.
OR
Write a C program to add name, address and salary of a person into a data file “students.dat”. Also open the file to read the contents.

MULTIPLE CHOICE QUESTIONS [1 Marks]

1. Which of the following SQL statement is used to Delete rows from the Database table? a. DELETE b. REMOVE c. DROP d. CLEAR	2079 Set A Q.No 1
2. A field that is used to define particular rows from a database table uniquely is called. a. Primary Key b. Entity c. Relationship d. Constraints	2079 Set A Q.No 2
3. ……is not the data types of MS-Access. a. Number b. Text c. Memo d. Form	N/A
4. ……is the DBMS a. Fox-Pro b. MS Excel c. Lotus-123 d. All of the above	N/A
5. The primary key does not accept……….. a. Text b. Number c. Null Value d. None of the above	N/A
6. In Ms Access, we enter data using ……. a. Form b. Table c. Report d. Both a and b	N/A
7. Data/Time occupies ……. bytes of memory. a. 4 b. 2 c. 8 d. 16	N/A

SHORT ANSWER QUESTIONS [5 Marks]

8. Differentiate the centralized and distributed database systems.	2079 Set A Q.No 10
9. What is the purpose of normalization? Give an example of 2NF.	2079 Set A Q.No 10 or
10. Describe 1NF, 2NF, and 3NF normalization concepts to database design.	2079 Set D Q.No 4
11. What are the importance of normalization in DBMS? Explain.	2076 GIE Set A Q.No. 7
12. Explain E-R diagram in DBMS.	2076 GIE Set A Q.No. 8
13 Describe the normalization in DBMS ?	2076 GIE Set B Q.No. 7
14. Differentiate between centralized and distributed database.	2076 GlE Set B Q.No. 10
15. Explain the different types of data integrity in DBMS.	2076 Q.No. 7
16. What is SQL? Describe the DML with an example.	2076 Q.No. 8
17. What is database: model? Explain relational model.	2075 GIE Q.No. 8
18. Differentiate between centralized and distributed database.	2075 Set A Q.No 8
19. Explain the advantages of Database Management System.	2075 Set B Q.No 8
20. Explain the benefits of decentralized database models.	2075 Set B Q.No 11
21. What is Relational Database Management System? Explain.	2074 Supp Q.No. 7
22. Explain DML and DDL.	2074 Supp Q.No. 8
23. Explain the data integrity with example.	2074 Set A Q.No. 7
24. Describe the normalization in database.	2074 Set A Q.No. 8
25. What are 1NF and 2NF normalization principle in database? Explain.	2074 Set B Q.No. 8
26. What is data security? Explain.	2073 Supp Q.No. 8
27. What is normalization? Explain first and second normal form with example.	2073 Supp Q.No. 14
28. What is DBMS? Explain data integrity with suitable example.	2073 Set C Q.No. 7
29. Define OML and DDL with example.	2073 Set C Q.No. 8
30. What is DBMS? Differentiate between centralized and distributed database.	2073 Set D Q.No. 8
31. Explain Relational database model.	2073 Set D Q.No. 9
32. Define DBMS. List out the objectives of DBMS.	2072 Set C Q.No. 7
33. What is Relational database model? List the advantages and disadvantages of Relational database model.	2072 Set C Q.No. 8
34. Describe the terms ‘SQL’ and ‘DML’.	2072 Set C Q.No. 9
35. Describe any two database model with diagram.	2072 Set D Q.No. 10
36. What is normalization? Write the advantages of normalization.	2072 Set E Q.No. 7
37. What are the advantages of RDBMS.	2072 Set E Q.No. 14 OR
38. Who is database administrator? List the roles of database administrator.	2071 Supp Q.No 10
39. What is database? List out the advantages of Database Management System.	2071 Set C Q.No 7
40. Describe the centralized and distributed database systems.	2071 Set C Q.No 9
41. What is RDBMS? List out the function of RDBMS.	2071 Set D Q.No 8
42. Explain the database models with clear diagrams.	2070 Supp Q.No 7
43. What is DBMS? List out the functions of DBMS.	2070 Supp Q.No 8
44. What is Hierarchical database model? List out the advantages and disadvantages of Hierarchical database model.	2070 Set C Q.No 7
45. Explain the centralized and distributed database models.	2070 Set C Q.No 9
46. Differentiate between DBMS and RDBMS with examples	2070 Set D Q.No 8
47. What is database ? List the major uses of database application software.	2069 Q.No.8
48. Explain the database model with suitable examples	2069 Q.No.10
49. Define the term ROSMS. State the guiding principles used in database design.	2068 Cancelled Q.No. 7 , 2057 Q.no 3
50. What is data integrity? State and describe different types of data integrity.	2068 Cancelled Q.No. 9
51. What is normalization? How it is used in data analysis? Explain.	2068 Cancelled Q.No. 11
52. What do you understand by the term data integrity? Why it is important in designing a database?	2068 Q.No. 4
53. Explain the benefits of centralized database.	2068 Q.No. 9
54. What is normalization? Explain the normalization process with examples.	2067 Q.No. 8 , 2065 Q.No. 6
55. What do you understand by the term data integrity? Why it is important thing to be considered while designing a database? Explain.	2067 Q.No. 11
56. Define database and DBMS. Explain the advantages of Database system over flat-file system.	2066 Q.No. 7
57. What are the advantages of distributed database system over centralized database system?	2066 Q.No 10
58. What is data model? Explain about different data modelling techniques.	2066 Supp Q.No. 6
59. Differentiate between database and database	2064 Q.No. 4
60. Explain the benefits of centralized database. What are the major responsibilities of a Database Administrator? Explain in detail.	2064 Q.No. 8
61. Define database administrator. Explain the duties and responsibilities of a database administrator.	2063 Q.No. 4
62. What is normalization? Explain the normalization process with examples.	2063 Q.No. 8
63. Who is database administrator? Explain the benefits of centralized database system.	2061 Q.No. 4
64. Give two advantages of using a database rather than a number of separate files. What are major responsivities Of a database administrator?	2060 Q.No. 7
65. Why is normalization needed? Explain normalization process with examples.	2060 Q.No. 9
66. Differentiate between Database and DBMS. Explain the top down methodology of Database design.	2059 Q.No. 4
67. Explain the benefits of Centralized Database. What are major responsibilities of a Database Administer? What are the objectives of system analysis?	2059 No. 11
68. Name the different models of DBMS. Write short notes on any three of the following (a) SQL (b) Data Dictionary (c) ERD (d) DDL	2058 No. 2
69. What are Domains and Tuples? What are the characteristics of a good data model ?	2058 Q.No. 3
70. What is prototyping? Write short notes on ay two of the following: (a) Normalization of data (b) Data security (c) RDBMS	2058 Q.No. 8
71. What is the role of Database Administrator. What are the duties and responsibilities of a System Analyst ?	2058 Q.No. 9

LONG ANSWER QUESTIONS [8 Marks]

72. What is normalization? Write its advantages. Explain second and third normal form with example.	2075 GIE Q.No. 5
73. What is normalization? Explain first second and third normal form with example.	2075 Set A QNo. 5
74. What are the importance of normalization? Explain second and third normal form with example.	2075 Set B QNo. 5
75. What do you understand by the term data integrity? Why it is an important thing to be considered while designing a database. State and describe different types of data integrity.	2062 Q.No. 2 OR
76. a. What do you understand by the term data integrity? Why is it important thing to be considered while designing a database? State and describe different types of data integrity.	2059 Q.No 2

WRITE SHORT NOTES ON

77. Data Security	2076 GIE Set A Q.No. 15b , 2074 Set B Q.No. 15a , 2071 Supp Q.No. 15(ii)
78. Primary Key	2076 Q.No 15a
79. DBMS	2073 Set C Q.No. 15a
80. Normalization	2073 Set D Q.No. 15b , 2071 Set C Q.No. 15b 2070 Set D , Q.No. 15a , 2064 Q.No. 12b , 2062 Q.No. 12(c)
81. Data dictionary	2070 Set C Q.No. 15b , 2068 O.No. 12a , 2057 Q.No. 7(a)
82. DML	2059 Q.No 5(a)
83. Date modelling	2057 Q.No 4(c)
84. Advantage of DBMS	2057 Q.No 4(b)

MULTIPLE CHOICE QUESTIONS [1 Marks]

1.What does “MAC” stands for in MAC Address? a. Mandatory Access Control b. Media Access Control C. Micro Access Control d. Media Access Certificate	2079 Set A Q.No. 3
2. ……. refers to the sending, receiving, and processing of information by electronic means. a. computer b. communication C. software d. Program	N/A
3. Which refers to the communication media? a. UTP cable b. Fiber optic cable c. Satellite d. All of the above	N/A
4. Which one is not network topology? a. Star b. Ring c. Client Server d. BUS	N/A
5. Which is not a guided media? a. UTP Cable b. STP Cable c. Satellite d. Fiber Optic	N/A
6. Which device is necessary to operate the Internet? a. CD-ROM b. ISP c. Modem d. All of the above	N/A

SHORT ANSWER QUESTIONS [5 Marks]

7. Compare the star and ring Topology	2077 set D Q.No. 5
8. What is computer network? List out hardware equipments to establish the computer network	2076 GIE Set A Q.No. 9
9. Differentiate between LAN and , WAN.	2076 GIE Set A Q.No. 10
10. Describe the different types of communication media in the Networking.	2076 GIE Set B Q.No. 9
11. Define network topology. Explain the Ring Topology.	2076 Q.No. 9
12. Describe the wireless network system. List out devices and equipment necessary for Wi-Fi network.	2076 Q.No. 10
13. What is topology? Explain Ring topology.	2075 GIE Q.No. 9
14. Differentiate between bounded and unbounded transmission media.	2075 GIE Q.No. 10
15. Differentiate between peer-to-peer and client/server network.	2075 Set A Q.No. 9
16. What is transmission media? Write advantages of optical fiber cable.	2076 Set A Q.No. 10
17. What is transmission media? Explain any two different types of transmission media.	2075 Set B Q.No. 10
18. What are the functions of router and switch?	2074 Supp Q.No. 9
19. Describe the Star topology with suitable diagram.	2074 Set A Q.No. 9
20. What is optical fiber cable in networking System?	2074 Set A Q.No. 10
21. Explain Unshielded Twisted Pair (UTP).	2074 Set B Q.No. 9
22. Differentiate between LAN and WAN.	2074 Set B Q. No. 10
23. Explain peer-to-peer and client/server network.	2073 Supp Q.No. 9
24. Describe the Bus and Star topology with suitable diagram.	2073 Set C Q.No. 9
25. Differentiate between guided and unguided networking media.	2073 Set C Q.No. 10
26. Explain Bus and Star topology with advantages and disadvantages.	2073 Set D Q.No. 10
27. Define computer network and explain its uses.	2072 Set C Q.No. 10
28. Describe ‘simplex’, ‘half duplex’, and ‘full duplex’ with example.	2072 Set C Q.No. 11
29. What is Networking? List the advantages of Networking.	2072 Set D Q. No. 9 , 2070 Set C Q. No. 8
30. Describe Network topologies with diagram.	2072 Set D Q.No. 11
31. What is computer network? Write the advantages and disadvantages of computer network.	2072 Set E Q.No. 8
32. What is computer network? Explain its uses.	2071 Supp Q.No. 7
33. What is Network topology? Describe any two network topologies with clear diagram.	2071 Set C Q.No. 8
34. Describe the ‘Coaxial cable and ‘Satellite’ with examples.	2071 Set C Q.No. 10
35. What is Network? List out the benefits of Networks?	2071 Set D Q.No. 10
36. Define computer networks and explain their uses.	2070 Supp Q.No. 9
37. Describe ‘Simplex’, ‘half duplex’ and ‘full duplex’ channel of communications with examples.	2070 Supp Q.No. 10
38. Explain any two transmission media with appropriate diagrams.	2070 Set C Q.No. 10
39. Describe the types of network topologies with clear diagrams.	2070 Set D Q.No. 10
40. What are the types of LAN topologies? Explain with diagrams.	2069 Q.No. 7
41. What is local area network? Explain different types of topologies with diagrams.	2068 Cancelled Q.No. 6 , 2065 Q. No. 4 2062 Q. No. 6
42. What are the types of LAN topology? Explain with diagram.	2068 Q.No. 10
43. What is network topology? Explain the different types of network topologies with diagram.	2067 Q.No. 6
44. Define Network Architecture. Explain client-server and peer-to-peer networking.	2066 Q.No. 4
45. Explain about OSI/ ISO model of networking.	2066 Q.No. 6
46. What is the purpose of transmission media? Explain its types.	2066 Supp Q.No. 5
47.What is networking? Distinguish between star topology and ring topology of networking principles with the help of clean diagram.	2064 Q. No. 10
48. What is networking? Explain the advantages and disadvantages of networking.	2063 Q. No. 10
49. What are the different types of LAN topology? Explain.	2061 Q. No. 7
50. What is network topology? What are the different types of LAN topology? Explain.	2060 Q.No. 5
51. What do you mean by transmission media? Write short notes on UP cable and fibre optical cable.	2060 Q.No. 10
52. Differentiate between Internet and intranet. Explain the term normalization in terms of database design.	2059 Q.No. 7
53. What do you mean by topology? What do you understand by the following terms (any two); (a) Client-Server Network (b) Workstation (c) Protocol	2058 Q.No. 4
54. What is a local area network? List the different types of topologies with diagrams	2057 Q.No. 3

LONG ANSWER QUESTIONS [8 Marks]

55. 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.

2079 Set A Q.No. 15

WRITE SHORT NOTES ON

56. Router	2076 GIE Set B Q.No, 15b 2075 GIE Q. No. 15b
57. IP address	2076 Q. No. 15b
58. Wi-Fi	2075 Set A Q. No. 15 2073 Set D Q.No. 15a
59. LAN	2074 Supp O.No. 15a
60. TCP/\|P	2074 Set A Q. No. 15b 12073 Supp Q.No. 15a
61. Bluetooth	2074 Set B Q. No. 15b
62. DML	2073 Supp Q. No. 15b
63. Network protocols	2073 Set C Q.No. 15b
64. Satellite	2072 Set E Q.No. 15a 2069 Q. No. 15b 2067 Q. No. 12 b 2062 Q.No. 12b
65. Protocol	2071 Supp Q. No. 15(i)
66. Coaxial Cable	2069 Q. No. 15a 2067 Q.No. 12 a 2062 Q. No. 12(a)
67. Packet switching	2068 Cancelled Q. No. 12 (b)
68. Network protocol	2066 Supp Q. No. 12b
69. (i) Client server network (ii) Workstation (ii) Protocol	2063 Q.No. 7
70. Fiber-optic Cable	2061 Q.No. 8(b)
71. Bus-Topology	2059 Q.No. 5(b)
72. Transmission media	2059 Q. No. 5(c)

MULTIPLE CHOICE QUESTIONS [1 Marks]

1. What is the correct syntax for referring to an external JavaScript script? a.<script src=”myscript.js”></script> b. <script href-“myscript.s”></script> c. <js href=’myscriptjs”> </js> d. <js src=*myscript.is”><js>	2079 Set A Q.No. 4
2. Which of the following is the correct way of defining a variable in PHP? a. $variable name = value; b. $variable_name = value; c. $variable_name = value d. $variable name as value;	2079 Set A Q.No. 5
3. Java script is………… a. procedural oriented language b. object oriented programming language c. Firmware d. None of the above	N/A
4. Data types in java script are a. primary and secondary b. primitive and non-pitcase c. local and universal d. None of the above	N/A
5. PHP stands for a. Hypertext Pre-processor b. program hyper processor c. Process hyper program d. None of the above	N/A
6. concat() is ……… a. integer method b. string method C. image method d. None of the above	N/A
7. ………….. is an identifier whose value may change during de execution of the program. a. constant b. function c. variable d. None of the above	N/A

SHORT ANSWER QUESTIONS [5 Marks]

8. Write a program to find the factorial d any given number using JavaScript.	2079 Set A Q. No. 11
9. How do you fetch data fren database in PHP and display it in form? Describe.	2079 Set A Q.No. 11 OR
10. Write short notes on Internet technology.	N/A
11. Differentiate between server-side and client-side scripting.	N/A
12. Explain different data types used in JavaScript.	N/A
13. What is Query? Write down its uses.	N/A
14. What is PHP? Explain its uses and advantages.	N/A
15. Write down the basis PHP syntax and an example of a PHP program.	N/A
16. Explain the different operators used in a PHP.	N/A
17. Write a PHP program to display the largest among three numbers.	N/A

LONG ANSWER QUESTIONS [8 Marks]

18. What is Object-based programming? Explain different JavaScript objects.	N/A
19. Write down the server-side script to create a database, connect with it, create a table and insert data in it.	N/A

MULTIPLE CHOICE QUESTIONS [1 Marks]

SHORT ANSWER QUESTIONS [5 Marks]

LONG ANSWER QUESTIONS [8 Marks]

WRITE SHORT NOTES ON

MULTIPLE CHOICE QUESTIONS [1 Marks]

1. What is the output of C program? void main(){ int b=25; //b memory location=1234; int p; p=&b; print (%d %d”, &b, P); } a. 25 25 b. 1234 1234 c. 25 1234 d. 1234 25	2079 Set A Q.No. 6
2. ………is a reserved word that has standard and predefined meanings in C. a. variable b. identifier c. keyword d. None of the above	N/A
3. …….. is a quantity that doesn’t change during program execution a. variable b. constant c. data type d. None of the above	N/A
4. ……… is a symbolic name, which is used to store different types of data in the computer’s memory and may change during the program execution. a. variable b. constant C. identifier d. None of the above	N/A
5. …….. is a symbol that instructs C to perform some operation or action on one or more operands. a. operand b. operation c. operator d. None of the above	N/A
6. ……….. is something that an operator acts on. a. operand b. operation c. operator d. None of the above	N/A

SHORT ANSWER QUESTIONS [5 Marks]

7. What is variable? List the major data types which is used in C program.	2077 Set D Q.No. 6
8. What is structure in C Program? Explain.	2076 GIE Set A Q.No. 11
9. List out the different types of operator in C. Describe the logical operator with example.	2076 GIE Set B Q.No. 11
10. Define pointer in C with example.	2076 GIE Set B O No. 12
11.Describe the different mode of the file handling concept in C.	2076 Q.No. 12
12. Explain the file handling concept. in C.	2074 Supp Q.No. 11 2074 Set B Q.No. 11
13. Describe the different mode of tile handling concept of C.	2074 Set A Q. No. 12
14. Describe the different mode of file handling concept in C.	2073 Set C Q.No. 12
15. Differentiate between array and structure with example.	2072 Set C Q.No. 12
16. Explain the array and structure with examples.	2071 Supp Q.No. 9
17. Differentiate between array and structure.	2089 Q.No. 8 or 2061 Q.No. 10
18. In event driven programming what is event handler? Explain the term ‘recession’.	2059 Q.No. 10

LONG ANSWER QUESTIONS [8 Marks]

19. What is structure? Write a program to input roll, name and age of 5 students and display them properly using structure.	2079 Set A o No. 16
20. 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.	2079 Set A O. No, 16 OR
21. Describe the pointer with example.	2077 Set D Q. No. 3a
22. Define the terms, class and objects.	2076 GIE Set A Q.No. 1a
23. How do you define function in C program? Write a program to find out given number is negative or positive using function.	2076 GIE Set A Q.No. 3
24. What is file handling concept in C? Write a program to enter name and salary of employee and write it in a file “employee. txt”	2076 GIE Set A Q.No. 5
25. Write a program to read the marks of any 5 students in a subject and count how many students are passed or failed. (Pass marks = 35)	2076 GIE Set B Q. No. 2
26. Describe the function in C. Write a program to find out factorial of given number using function.	2076 GIE Set B Q.No. 3]
27. Explain the structure in C. Write a program to enter the 5 student name, age and sex using structure and display.	2076 GIE Set B Q.No. 5
28. What is user defined function? Write a program to input length and breadth of a pond and find its area by using user defined function.	2076 Q.No. 1
29. What is structure? Write a program to input employee id, name, address and post of 20 employees and display them properly.	2076 Q.No. 4
30. What is the importance of file pointer in file handling? Explain with an example.	2076 Q.No. 5a
31. What is function? Write the advantages of function. Differentiate between library and user-defined function with example.	2075 GIE Q.No. 3
32. Write a program to enter name, post and age of 10 employee’s using structure and display in proper format.	2075 GIE Q.No. 4
33. Write a program to input 10 integer numbers into an array and display the sum of the numbers.	2075 Set A Q.No. 2
34. What is function? Explain any four string functions with example.	2075 Set A Q.No. 3
35. Write a program to input name, roll, and reg. no. of 10 student’s using structure and display in proper format.	2075 Set A Q. No. 4
36. What is function? Write a program to read the principle, time and rate. Find the simple interest using function.	2075 Set B Q.No. 3
37. Write a program to store 50 records of students using fields, std. no., name and mark. Display the name of student and mark.	2075 Set B Q.No. 4
38. What are the importance of function in C program? Write a program to find out given number is odd or even using function.	2074 Supp Q.No. 3
39.What are the string function in C? Write a program to print the given text in reverse order.	2074 Supp Q.No. 4
40.Describe the structure in C. Write a program to enter the 5 subject marks and calculate sum and print using structure.	2074 Supp Q.No. 5
41. Describe the function in C. Write a program to find the sum of n integer number using function.	2074 Set A Q.No. 4
42. Write a program to input the 5 employee’s name and salary using structure and display the records in proper format.	2074 Set A Q.No. 5
43. What are the methods of function declaration and call in C? Write a program to find out given number is odd or even using function.	2074 Set B Q.No. 3
44. What is structure in C? Write a program to enter the 20 employee’s name, age and salary using structure and print them.	2074 Set B Q.No. 5
45. Differentiate between array and structure.	2073 Supp Q.No. 16
46. Define control structure. Write a program to find the sum, difference and greater of two integer numbers using switch case statement.	2073 Supp Q. No. 3
47. Write a program to multiply two integer numbers using functions.	2073 Supp Q.No. 4a
48. a. What is pointer? Define address of() and indirection (*) operator. b. Write a program to enter name, address and salary of a employee and store it in a file “staff.dat”	2073 Supp Q.No. 5
49. Describe the function in C. Write a program to find the sum of ‘n’ integer number using function in C	2073 Set C Q.No. 4
50.Differentiate between structure and union. Write a program to input the employee name and post of five employees and display the records in proper format using structure.	2073 Set C Q.No. 5
51.Write a program to add two integer numbers using function.	2073 Set D Q.No. 4a
52. a. What is pointer? Write its advantages. b. Write a program to enter name, post and salary of a employee and write it in a file “employee.dat.”	2073 Set D Q.No. 5a
53. What is function? List out the advantages of functions.	2072 Set C Q.No. 4a
54. a. Describe fscanf and fprintf function. b. Write a program which asks name, age, roll-number of student and write it in a file student dat.	2072 Set C Q.No. 5
55. Differentiate between Structure and Union.	2072 Set D Q.No. 4a
56. a. Describe any two file handling functions. b. Write a program to display name, age and address reading from file “record.dat”	2072 Set D Q.No. 5
57. What is a function? Write a function to add two integer number.	2072 Set E Q.No. 3
58. Write a program which reads name, department and age from a file named “employed. dat” and display them on the monitor.	2072 Set E Q.No. 5
59. What is ‘fscanf” function? Write a program to display name, age and address reading from a file named “record.dat general factorial of a given number using recursive lunching.	2071 Supp Q.No. 3
61. Describe any five file handing function with examples.	2071 Set C a No. 3
62. What is pointer? Describe the benefits of pointer with examples.	2071 Set D Q. NO. 3
63. Write a program which reads name, roll number and age from a file named “student.dat” and display them.	2071 Set D Q. No. B
64. Describe the types of loop with flowchart and examples.	2070 Supp Q.No. 21
65. Write a program which asks the user to input ‘n’ terms of number and find out the greatest and smallest number among those numbers.	2070 Supp Q. No. 3
66. Differentiate between array and structure with suitable examples.	2070 Supp Q.No. 4
67. Write a program which asks name, age roll number of students and write them in a file xyz dat. fiG	2070 Supp Q.No. 5
68. Describe any five “string handline functions” with examples.	2070 Set c Q.No. 2
69. Describe array, structure and pointer with examples.	2070 Set C Q.No. 3
70. Describe fprintf and fscanf file handing functions. Write a program which writes “welcome to Nepal in a file.	2070 Set C Q.No. 5
71. Differentiate between structure and union with suitable examples.	2070 Set D Q.No. 3
72. What is recursion? Write a program to calculate factorial value of given number using recursive. function.	2070 Set D Q.No. 4
73. Write a program which reads name, department and age from a file named “employee. dat” and display them.	2070 Set D Q.No. 5
74. Write a program which reads name. department and age from a file named “employee.dat” and display the on the monitor.	2069 Q.No. 5
75. What do you mean by “local”, “global and “static” variables? Explain with examples.	2068 Q.No. 1d)
76. What is an array? Wite down the similarities and differences of array with pointer.	2068 Q.No. 2a
77. a. Write program to sort an array of ‘n’ elements it descending order. b. Write a program to enter ‘name”, “roll-no’ and ‘marks’ 10 students and store them in file. Read and display the same from the file.	2068 Q.No. 3
78. a. What is recursive function? Write a program to calculate the factorial of an integer using recursion. b. Define pointer. Discuss the relation between the point and array with suitable examples.	2068 Cancelled Q. No. 2
79. Wite a program to open a new. and read roll-no, name, address and phone number of students until the user says “no”, after reading the data, write it to the file then display the content of the file.	. 2088 Cancelled Q.No. 3a
80. Wite a recursive function to calculate the factorial of any integer number.	2067 Q.No. 15
81. a. How do you declare an array? Write a program to arrange the elements of an array in ascending order. b. What is the difference between library function and user-defined function? Write a program using user-defined function to calculate y raise to power x.	2067 Q.No. 21
82. a. Differentiate between array and structure with suitable example. b. Write a program to delete and rename the data file using removed and rename command.	2067 Q. No. 3
83. a. Write a program to show data writing and reading operation to/from a data file. b. Explain the importance of pointer in C-Programming. Illustrate pointer operations with examples. Show the relationship between array and pointers with example.	2066 Supp Q.No. 3
84. a. Write a program to store name and mark of 20 students. Sort the data according with mark in descending order and display them. b. Write a program to find the sum of ‘n’ integer numbers using function.	2066 Q.No. 2
85. a. Write a program to store std-no, name and mark of n’ students in a data file. Display the records in appropriate format reading from the file. b. Differentiate array and structure with examples.	2066 Q.No. 3
86. Write differences between structure and union with syntax.	2065 Q.No. 26
87.Write a program to enter name, roll-number. and marks of 10 students and store them in the file.	2065 Q.No. 3a
88. Write a program for reading a data fie.	2064 Q. No. 10
89. Write a program to delete and rename data file using remove and rename command.	22064 Q.No. 3a
90. Write a C program to calculate the factorial of a given number using functions.	2063 Q.No. 16
91. a. Differentiate between structure and pointer with examples. b. Write a C program design a menu based system which has the following features: (i) Appending record (ii) Reading record (iii) Delete record (iv) Quit	2063 Q.No. 3
92. Write a C program that will read successive records from the new data file and display each record on the screen in an appropriate format.	2062 Q.No. 36
93. Write a program that reads different names and addresses into the computer and rearrange the names into alphabetical order using the structure variables.	2061 Q.No. 16
94. a. Write a program using C language that reads successive records from the new data file and display each record on the screen in an appropriate format. b. What is pointer? Explain the meaning of each of the following declarations: (i) int p; (ii) int p[10]; (iii) int () [10]; (iv) int p [void]; (v) int * P(char *a);	2061 Q.No. 3
95. A higher secondary school has asked you.to write a HLL program to help them analyze their class test scores. The program must firm ask for the number of students ‘n’ and should have a looping structure that loops through ‘n’ times to accept, valuable and store the data in any array. The structure for each student is given below: Field name field type size Validation rules Roll numeric 2.0 1-99 Name alphabetic 25.0 Marks numeric 2.1 0.0-10.0 The program must: a. Print out the data for students who have failed (obtained marks < 4.0). b. Print out the data for students scoring more than 7.9. c. Print out the average class mark	2058 Q.No. 3

MULTIPLE CHOICE QUESTIONS [1 Marks]

1. Which feature of OOP is illustrated the code reusability? a. Polymorphism c. Encapsulation b. Abstraction d. Inheritance	2079 Set A Q.No. 7
2. OOP stands for. a. Operator overloading programming. b. Object-Oriented Programming. c. Object overloading programming. d. None of the above.	N/A
3. ……..is a concept or thing with defined boundaries that are relevant to the problem we are dealing with. a. object b. class C. variable d. None of the above	N/A
4. ………. is a collection or group of similar objects that have the same properties, common behaviour, and relationships. a. object b. class C. constant d. None of the above	N/A
5. .. is a property that allows the reuse of an existing class to build a new class. a. class b, operation c. inheritance d. Object	N/A
6. .. is the process that allows selective hiding of data and functions in a class. a. class b. inheritance c. encapsulation d. Polymorphism	N/A

SHORT ANSWER QUESTIONS [5 Marks]

7. Compare the OOPs and Procedural programming language.	2079 Set A Q.No. 12
8. Distinguish between OOP and Procedural language.	2O75 GIE Q.No. 11
9.What are the importance of OOP?	2075 Set A Q.No. 11
10. What is OOP? Write the application of OOP.	2073 Supp Q.No. 10
11 Explain class and object.	2073 Set D Q.No 11
12. What is OOP? List the characteristics of OOP.	2072 Set D Q.No 12
13.Explain the terms polymorphism and inheritance.	2071 Supp Q.No. 14 , 2067 QNo. 9 , 2063 Q.No. 5 , 2061 Q.No. 11
14. What is OOP? List the advantages of OOP.	2074 Set C Q.No. 12 , 2070 Supp Q.No. 12
15. Describe the importance of OOP.	2074 Set D Q.No. 14
16. What is procedural oriented programming? Explain.	2070 Set C Q.No. 12
17.Explain polymorphism and inheritance with examples.	2070 Set D Q.No. 11
18. Write the advantages and disadvantages of OOP.	2069 Q.No. 14
19. What is object-oriented programming? How it is different from the procedure oriented programming?	2068 Cancelled Q.No. 5
20. Why polymorphism and inheritance are important concepts of OOP? Explain.	2068 Q.No. 6
21. Explain the characteristics of objects oriented programming.	2066 Supp Q.No. 11
22. Define the terms polymorphism and inheritance with examples.	2065 Q.No. 8
23. Why polymorphism and inheritance are important concepts of OOP? Explain.	2062 Q.No. 8
24. Name the tools that are used in program design. Polymorphism and Inheritance are important concepts of OOP. What d you understand by there two terms?	2058 Q.No 5
25. What is a Logical operator? Give two “examples of their use. Compared to procedure-oriented programming what advantage does not events driven programming offer?	2058 Q.No. 6
26. What is object-oriented programming? How is it different from the procedure oriented programming?	[2057 Q.No. 8

LONG ANSWER QUESTIONS [8 Marks]

Define the terms inheritance and polymorphism.	2075 GIE Q.No. 1b
Define the terms class and object.	2075 Set A Q.No. 1b
Write the importance of OOP.	2075 Set B Q.No. 2a

WRITE SHORT NOTES ON

30. Inheritance	2075 Set B Q.No. 15 , 2066 Q.No 12a
31. Polymorphism	2063 Q.No. 6c

MULTIPLE CHOICE QUESTIONS [1 Marks]

1. Which of following is the discovering requirement from a user in the requirement collection process? a. Feasibility study b. Requirement Elicitation c. Requirement Specification d. Requirement validation	2079 Set A Q.No. 8
2. A set of programs written for a computer to perform a particular task is called a. hardware b. software c. Both a and b d. None of the above	N/A
3. …… defines a sequence of tasks that must be carried out to build new software. a. computer b. Hardware c. Software development process d. None of the above	N/A
4. SDLC stands for… a. Scheme Development Life Cycle b. Software/System Development Life Cycle c. Software/System Design Life Cycle d. Scheme Design Life Cycle	N/A
5… . is also called a Preliminary Investigation or Need Analysis Phase, a. System design b. System study c. System development d. System testing	N/A
6. ……… is to determine whether the whole process of system analysis leading to computerization would be worthwhile for the organization or not. a. Feasibility study b. System design c. System development d. Testing	N/A

SHORT ANSWER QUESTIONS [5 Marks]

7. What are the major activities performed to design the software? Describe .	2079 Set A Q.No. 13
8. What are roles of system analyst in SDLC phase ?	2076 GIE Set A Q.No. 6
9. What are the importance of SDLC in software development process ?	2076 GIE Set B Q.No 6
10. What are the major functions of DBA ? Explain.	2076 GIE Set B Q.No 8
11. Define SDLC. Describe the feasibility analysis methods.	2076 Q.No. 6
12. Explain system system analysis phase of SDLC.	2075 GIE Q.No. 6
13. Define the terms DFD and E-R diagram	2075 GIE Q.No. 7 , 2075 Set A Q.No. 7
14. Who is system analyst? Explain the role of system analyst.	2075 Set A Q.No. 6 2073 Set D Q.No. B 2065 Q. NO. 5
15. List out different stages of system development life cycle and explain any two stages of them.	2075 Set B Q.No. 6
16. Describe the major role and responsibilities of system analyst in SDLC phase.	2075 Set B Q.No. 7
47. What is E-R diagram? Write the meaning of graphical symbols used in E-R diagram.	2075 Set B Q.No. 9
18. List the steps of SDLC. Explain System Analysis Phase.	2074 Supp Q.No. 6
19. Describe the waterfall model to explain the SDLC.	2074 Set A Q.No. 6
20. What are the software development process phases in SDLC? Explain any one phase.	2074 Set B Q.No. 6
21. What are the role of DBA ? Explain.	2074 Set B Q.No. 7
22. Explain the system development phase.	2073 Supp Q.No. 6
23. Explain DFD and E-R diagram.	2073 Supp Q.No. 7
24. What are the major activities in SDLC with based on waterfall model?	2073 Set C Q.No. 6
25. Write the importance and necessity of. SDLC.	2073 Set D Q.No. 7
26. Describe SDLC with diagram.	2072 Set C Q.No. 6
27. Describe the components of feasibility study.	2072 Set D Q.No. 6
28. Who is system analyst? List out characteristics of system analyst.	2072 Set D Q.No. 7
29. Describe system flowchart with diagram. (5]	2072 Set D Q.No. 8
30. What is feasibility study? Explain different levels of feasibility study.	2072 Set E Q. No. 6 2070 Set C Q.No. 6 2068 Q. No. 5 2067 O.NO. B) 2064 Q.No. 9 12062 Q.No. 5
31.What is E-R diagram? Explain the advantage of E-R diagram in system design.	2072 Set E Q.No. 9
32. Write the importance of SDLC.	2072 Set E Q.No. 13
33. What is feasibility study? Why it is necessary before designing a system?	2071 Supp Q.No. 6
34. What is expert system? Explain the fields of expert system.	2071 Supp Q.No. 11 OR
35. What is system analysis and design? Describe briefly.	2071 Set C Q.No. 6
36. Describe different levels of feasibility study.	2071 Set D Q.No. 6
37. Who is system. analyst? List out the rolls of system analyst.	2071 Set D Q.No. 7 12070 Set D Q.No. 7
38. Explain SDLC with appropriate diagram.	2070 Supp Q. No. 6
39. What is system? Explain the basic elements of system.	2070 Set D QNo. 6
40. Explain different stages of system development life cycle with clear figure.	2069 Q.No. 6
41. What is E-R diagram? Explain the advantages of E-R diagram in system design.	2069 Q.No. 9
42. What is feasibility study? Why feasibility study is important in system analysis phase? Explain.	2068 Cancelled Q.No. A
43. Who is system analyst? Highlight the characteristics of a good analyst.	2068 Cancelled Q.No. 8 2057 Q.No. 2
44. What are the documentation techniques? Explain with an example.	2068 Cancelled Q.No. 10
45. Define program logic. Explain different types of program logic tools.	2068 Q.No. 7
46. Define program logic. Explain different types of program logic tools.	2068 Q.No. 7
47. What is system analyst? Explain the major roles of system analyst.	2067 Q.No. 4
48. Explain about the system design methodologies.	2066 Q.No. 5
49. Explain about the different testing techniques during the system development.	2066 Q. No. 11
50. How can you test a newly developed system? Explain different types of testing techniques.	2066 Supp Q.No. 4
51. Differentiate between decision table and decision tree with example.	2066 Supp Q.No. 8
52. What is the purpose of E-R diagram? List out the different symbols used in E-R diagram with their meanings and examples.	2066 Supp Q.No. 10
53. What is data security? How it can be implemented?	2065 Q.No. 10
54. What is documentation? Explain the importance of documentation in program designing.	2065 Q.No. 11
55. Who is system analyst? Explain the different stages of system development life cycle.	2064 Q.No. 6
56. What do you mean by data security? Explain briefly the type of security methods normally adopted in computerized environment.	2064 Q. No: 11)
57. What is system analysis? Explain the different steps of system development life cycle.	2063 Q.No. 4)
58. What are the different symbols used to construct a flow chart? Give brief explanation along with a neat diagram.	2063 Q.No. 11
59. Who is a system analyst? Explain the major role of system analyst.	2062 Q.No. 4
60. What is program logic? Explain the different types of program logic design tools.	2062 Q.No. 11
61. Define feasibility study. Why feasibility study is important in system development process. Explain.	2061 Q. No. 5
62. What is data security? How is can be implemented?	2061 Q.No. 6
63. What are the documentation techniques? Explain any three of them.	2061 Q.No. 9
64. What do you mean by feasible study? Why is it necessary before designing a system?	2060 Q. No. 4
65. What do you mean by program algorithm? Explain the aims of program design and building blocks of a structured programming.	2060 Q. No. 8
66. State the steps involved in system development cycle in chronology order. Explain data security laws.	2059 Q.No 9
67. What are the importance of Data flow diagrams in the S.D.L.C ? What do you mean by the following terms(any two); a) Physical system b) C.A.S.E c) P.I.E.C.E.S d) Feasibility Study	2058 Q.No 1
68. Define the term system. List different stages of system development life cycle . Highlight the importance of the first two stages.	2057 Q.No. 1

WRITE SHORT NOTES ON

69. Feasibility analysis.	2076 GIE Set B Q.No 15a
70. ER diagram	2074 Set A Q.No 15a
71. Expert System	2072 Set D Q.No 15a
72. Data Security	2067 Q.No 7a
73. Feasibility study.	2065 Q.No 12b

MULTIPLE CHOICE QUESTIONS [1 Marks]

1. 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)? a. Wi-Fi b. Barcode c. RFID d. Sensors	2079 Set A Q.No. 9
2. ….. is the part of computer science concerned with designing intelligent computer systems. a. hardware b. computer c. Artificial Intelligence d. None of the above	N/A
3. ..… is the branch of technology that deals with the design, construction, operation, and application of robots. a. hardware b. Robotics c. software d. None of the above	N/A
4. ….. is the use of various services, such as software development platforms, servers, Storage, and software, over the Internet. a, Hard Disk b. Cloud Computing c. Pen drive d. None of the above	N/A
5. SaaS stands for… a. Software as a Service b. System as a Service c. Both a and b d. None of the above	N/A
6. IaaS stands for… a. Internet as a Service b. Infrastructure as a service c. Both a and b d. None of the above	N/A

SHORT ANSWER QUESTIONS [5 Marks]

7. Explain the popular five applications areas of AI.	2079 Set A Q.No 14
8. What is AI ? Describe the application of AI.	2077 Set D Q.No. 7
9. What are the importance of earning in the 21″ century? Write the importance of multimedia in e-learning. a	2076 GIE Set B Q.No. 13
10. What are the roles of Al in our real life? List out Al related systems in our society.	2076 Q.No. 14
11. Define the terms e-governance and medicine.	2075 GIE Q.No. 14
12. Define the terms e-business and e-learning.	2075 Set A Q.No. 12 2073 Supp Q.No 13
13. Explain Artificial Intelligence.	2074 Supp Q.No. 13
14. What are the advantages and disadvantages of social media? List out.	2074 Set B Q.No. 13
15. What is E-Commerce? Point out the advantages of E Commerce.	2075 Set B Q.No. 14
16. What is Al? Write the social impact of ICT	2073 Supp Q.No. 11
17. What is Al? Explain cyber law.	2073 Set Q.No. 12
18. Define the terms e-learning and virtual reality.	2073 Set D Q.No. 14
19. What is E-governance? List out the objectives of E-governance.	2072 Set C Q.No. 13
20. Describe applications of Al.	2072 Set D Q.No. 14
21. What is Al? What are the uses of Al ?	2072 Set E Q.No. 12
22. What is e-governance? List the importance of e-governance.	2071 Supp Q.No. 14
23. Describe the application areas of Al.	2074 Set C QNo. 13
24. Describe the objectives of & governance.	2071 Set D Q.No. 14
25. What is Al? Explain the application areas of Al.	2070 Supp QNo. 14 , 2070 Set_C Q.No. 43
26. list out the advantages and disadvantages of e-business.	2070 Supp Q.No. 15
27. What are the objectives of & governance? Explain.	2070 Set D Q.No 14
28. What are the key challenges of implementing of e-governance in developing countries?	2069 Q.No, 14
29. What is Al? Describe the application of AI	2069 Q.No. 11 OR
30. What do you understand by AI? How it affects the modern society ?	2068 Q.No. 11
31. What is e-commerce? Explain its role to enhance the digital economy.	2066 Supp Q.No 7
32. What do you understand by AI ? How it affects the society ? Explain the terms polymorphism and inheritance in terms of OOPs.	2064 Q.No 5
33. What is E-Commerce ? Write impact of e-commerce technology in our society.	2060 Q.No. 11
34. What do you mean by e-commerce ? Distinguish between WWW(World Wide Web ) and Internet ? What is multimedia ? What are the hardware devices required by a personal computer to make it “Multimedia capable” ?	2058 Q.No. 7
35. What does an AI application work ? Can a computer really think the aid of AI?	2057 Q.No. 7

WRITE SHORT NOTES ON

36. AI	2075 GIE Q.No. 15
37. Application of AI	2075 Set B Q.No. 15
38. Social Media	2074 Supp Q.No. 15b
39. E-learning	2072 Set D Q.No. 15b
40. E-commerce.	2071 Set C Q.No. 15a

Class 12 Computer

Secondary Education Curriculum
2078
Computer

1. Introduction

2. Level-wise competencies

Scope and Sequence of Contents

1. Database Management System (DBMS) (12hrs)

2. Data Communication and Networking (15hrs)

3. Web Technology II (12hrs)

4. Basic Programming in PHP (12hrs)

5. Programming in C (10hrs)

6. Object-Oriented Programming (OOP) (10hrs)

7. Software Process Model (SPM) (10hrs)

8. Recent Trends in Technology (8hrs)

Main Menu

Falano College

Secondary Education Curriculum2078Computer

1. Introduction

2. Level-wise competencies

Scope and Sequence of Contents

1. Database Management System (DBMS) (12hrs)

2. Data Communication and Networking (15hrs)

3. Web Technology II (12hrs)

4. Basic Programming in PHP (12hrs)

5. Programming in C (10hrs)

6. Object-Oriented Programming (OOP) (10hrs)

7. Software Process Model (SPM) (10hrs)

8. Recent Trends in Technology (8hrs)

Main Menu

Falano College

FOLLOW US ON

Secondary Education Curriculum
2078
Computer