Model questions
from NEB (SET-A)
------------------------------------------------
Model Question School Leaving Certificate Examination 2078
Grade: Grade XII Subject: Computer Science (Th) Subject code: 428 Full Marks:
50 (9 marks Obj + 41 Marks Sub) Time: 2 Hours
Group A:
Multiple Choice questions (9 x 1=9) Time: 20 minutes
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 <A> tag?
A) To insert an image
B) To create a link
C) To create a hyperlink
D) To create a list 139
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 x 5=25)
10.
Explain 2NF and 3NF with examples.
OR
Demonstrate the basic DML statement with an
example.
11.
Write a function to add any two numbers in
Javascript.
OR
Demonstrate the external CSS implemented in
the web page.
12. Describe any five features of OOPs.
13. What are the different stages of software planning?
Describe.
14. Define the concept of AI and IoT. (2+3)
Group C: Long
Answer Questions (2 x 8=16)
15. How do you implement the Class C IP address in the local
area network? Describe.
16. 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.
SET-B
Group A:
Multiple Choice questions (9 x 1=9) Time: 20 minutes
Q1) To insert a record into a table, we use
a)
Insert
b)
Delete
c)
Alter
d)
All of the above
Q2) Which is a database software?
a)
SQL
b)
MYSQL
c)
Oracle
d)
All of the above
Q3) A topology where all the nodes are connected to each
other.
A)
Star
B)
Bus
C)
Tree
D)
Mesh
Q4) In JavaScript, switch control structure supports
a)
Integer values for case
b)
Floating values for case
c)
String values for case
d)
All of the above
Q5) To use css codes in our HTML files, we enclose it
between
a)
<script> and </script>
b)
<style> and </style>
c)
<head> and </head>
d)
None of the above
Q6) what would be the output?
#include <stdio.h>
int f(int x)
{
return x;
}
int main()
{
f(7);
printf("result=%d",f(8));
return 0;
}
a)
0
b)
9
c)
2
d)
8
Q7) The
process of creating multiple classes from an existing class is called …
inheritance.
a)
Single
b)
multiple
c)
hierarchical
d)
multilevel
Q8) ‘SDLC’ stands for
a)
System Development Life Cycle
b)
Standard Development Life cycle
c)
Special Development Life Cycle
d)
All of the above(a,b,c)
Q9) Which is the
example of cloud?
a) Amazon Web Services (AWS)
b) Dropbox
c) Cisco WebEx
d) All of the above
Group B: Short
answer questions (5x5=25)
Q10) Define the term ‘normalization’.
Explain about 1N. [1+4]
Or
Explain
about create, delete and alter commands used in SQL. [2+1+2]
Q11) What is a function in JS?
Write a program to create a button, onclick of which displays an alert message.
Use function. [2+3]
OR
Make a simple webpage using HTML and CSS.
Include: [2+3]
->header
for image
->
two columns of width 25% and 75%
Q12) Differentiate between
procedure Oriented programming and Object-Oriented programming.[5]
Q13) What is a software
development model? Explain about spiral model. [2+3]
Q14) Explain any two fields where
we can use AI. [5]
Group C: Long
Answer questions (2x8=16)
Q15) What is an IP address? What
are its types? Under IPv4, how many classes are there? List them out. Differentiate
between static and dynamic IP. [1+1+2+4]
Q16) Write a C program using
structure to input employees’ id, name and salary. Then print that entered data
in sorted format on the basis of salary (from highest to lowest). [8]
Or
Let, a datafile named “book.txt”
contains information of books (name, price, edition). Write a program in C
language to add some more data and then print all the records of books having
price >900. [4+4]
SET-C
Group A:
Multiple Choice questions (9 x 1=9) Time: 20 minutes
1. Which
of the following is the basic structure of SQL to create table in data
base…………………?
a.
CREATE table (field1 data_type, field2
data_type,……)
b.
CREATE table table_name (field1 data_type,
field2 data_type,……)
c.
CREATE table table_data (field1 data_type,
field2 data_type,……)
d.
All of the above
2. Which
of the following is not example of DML (Data Manipulation Language)?
a.
INSERT
b.
UPDATE
c.
DELETE
d.
GRANT
3. Computer Network is
a. Collection of hardware components and computers
b. Interconnected by communication channels
c. Sharing of resources and information
d. All of the Above
4. ……………………………
is not the phase of waterfall model.
a.
Requirement analysis
b.
Testing
c.
Build prototype
d.
Maintenance
5. Which
of the following syntax is correct to embed JavaScript to HTML?
a. <script
type=”text/javascript”></script>
b. <script
language type=”text/javascript”></script>
c. <script
type=”text/javascript language”></script>
d. All
of the above
6. The
prevention of data from unauthorized access is…………….
a. Data
security
b. Data
integrity
c. Data
misuse
d. All
of above
7.
The
delivery of computing services over the internet rather than having local
servers or personal devices handle applications is called…………………
a. Cloud Computing
b. Analog Computing
c. Mobile Computing
d. All of the above
8. A
variable which holds memory address of another variable is…………………….
a.
Function
b.
Pointer
c.
Array
d.
Structure
9. Binding the data
with the code that manipulates it is ………………….
a. Polymorphism
b.
Encapsulation
c. Inheritance
d. Abstraction
Group B: Short Answer Questions (5x5=25)
10.
Explain
Cloud Computing with its characteristics. [2+3]
11.
What
is DBMS? Write its advantages and disadvantages. [1+4]
OR
What
is normalization? Write its advantages. [1+4]
12.
WAP
to display largest among three numbers using JavaScript.[5]
13.
Explain
OOP with its features. [5]
14.
Explain
SDLC with its phases. [5]
Group C: Long answer Questions (2x8=16)
15.
Explain
guided and unguided transmission media with its types. [4+4]
16. WAP to input name and address of
10 employees and sort them in ascending alphabetic order according to their
name. [8]
OR
WAP
to enter name, roll no and marks of 10 students and store them in a file. [8]
SET-D
Group A:
Multiple Choice questions (9 x 1=9) Time: 20 minutes
Q1) The key that identifies each record uniquely, is called
a)
Primary key
b)
Unique key
c)
Key record
d)
Field name
Q2) Which forms simplifies and
ensures that there are minimal data aggregates and repetitive groups:
a. 1NF
b. 2NF
C 3NF
D All of the mentioned
Q3) 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
Q4) Which of the following is a ternary operator in JS?
A. -
b. ?:
c. +
d. :
Q5) PHP stands for …
a. Hypertext
Processor
b. Hyper
Markup Processor
c. Hyper Markup Preprocessor
c. Hypertext Preprocessor
Q6) What is the first octet value of class A IP?
a.
0-126
b.
128-191
c.
224-239
d.
192-223
Q7) The function
int fibo()
{
Statements;
}
Is called
a)
Function declaration
b)
Function definition
c)
Function end
d)
None of the above
Q8)
What is an abstraction in object-oriented
programming?
a) Hiding the implementation and showing only the
features
b) Hiding the important data
c) Hiding the implementation
d) Showing the important data
Q9) Agile Software Development is based on which of the
following type?
a. Iterative Development
b. Incremental Development
c. Both
Incremental and Iterative Development
d. Linear Development
Group B: Short
Answer Questions (5x5=25)
Q10) Differentiate
between centralized and distributed database. [5]
Or
What
is RDBMS? Explain relational model of a database. [2+3]
Q11) Write the difference
between server side scripting and client side scripting. [5]
OR
Write
steps to connect PHP code to your database. Let, database name is ‘test’. [5]
Q12) What are the different types of inheritance? Explain
them. [5]
Q13) Describe in brief the process of prototype model. [5]
Q14) Define e-commerce and
e-business. What are the advantages and disadvantages of e-commerce? [2+3]
Group C: Long
answer Questions (2x8 =16)
Q15) Define communication system.
Explain each component of communication system with necessary diagram. [1+2+5]
Or
Define OSI reference model.
Explain each layer of OSI model. [1+7]
Q16) Differentiate between library
and user defined function. Write a program to display largest among three
numbers by using pointer. [4+4]
SET-E
Group A: Multiple Choice questions (9
x 1=9) Time: 20 minutes
1.
Which of the following is a group of one or many
attributes that uniquely identifies a row?
a. Key
b. Determinant
c. Tuple
d. Relation
2.
In general, a file is basically a collection of
all related
a. Rows & Columns
b. Fields
c. Database
d. Records
3.
Give an example of half duplex mode of data
communication.
a.
TV
b.
Radio
c. Walkie-Talkie
d.
Internet
4.
Which of the following can’t be done with
client-side JavaScript?
a. Validating a
form
b. Sending a
form’s content by email
c. Storing the form’s contents to a database
file on the server
d. None of the
above
5. Which
one of the following should not be used while sending password or other
sensitive information?
a. GET
b. POST
c. REQUEST
d. NEXT
6.
What will fopen will return if there is any
error while opening a file?
a.
Nothing
b. NULL
c.
EOF
d.
Depends upon compiler
7. Which feature of OOP indicates code
reusability?
a) Abstraction
b) Polymorphism
c) Encapsulation
d) Inheritance
8.
Which of the following is the first step in SDLC
framework?
a. Feasibility Study
b. Requirement Gathering
c. Communication
d. System Analysis
9. Which
segment of e-commerce model does eBay belong to?
a. B2B
b. B2C
c. C2B
d. C2C
Group B: Short Answer Questions (5 x 5=25)
10.
What is RDBMS? Explain relational model of a
database. [2+3]
Or
What is primary
key? What are the features of good primary key? [1+4]
11. What
is event handling in JavaScript? Explain with example. [2+3]
OR
What is variable? Write
rules to variable in PHP. [1+4]
12. Define data
abstraction and encapsulation. Mention their main advantages in OOP.[2+3]
13. Explain internet of thing (IOT) along with advantages
and disadvantages.[5]
14.
Describe in brief the process of agile model. [5]
Group C: Long Answer Questions (2x 8=16)
15. Define network topology. Describe star and
ring topology with necessary diagram.[2+6]
16. Write
a c program to input name, salary, and post of ‘n’ employee and sort them in
alphabetical order according to their name. [8]
OR
Write a program
to create a data file named ‘student.dat’ and store roll number, name and
address of 10 students and display the record in proper format. [8]
SET-F
Group
A: Multiple Choice Questions (9 x 1=9) Time: 20 minutes
Tick the correct answer.
1. ____ is a DDL command.
a)
CREATE b)
TRUNCATE c) ALTER d) all of the above
2. .
Data dictionary is a repository that manages
a. Memory b. Metadata c. Spell Checker d.
Data Validator
3. Mbps stands for?
a) Mega
bits per second b) Mega bytes per second
c) Mega
bands per second d) A and b
4. Which of the following
is client side scripting language?
a)
PHP b) HMTL
c) CSS
d) JavaScript
5. Which of the following
is used to access html elements using javascript?
a)
getElementById() b) getElementsByClassName()
b)
Both a and b d) None of the above
6. For a function,
int
series()
{
int
a,I,s=0;
}
a,I and s are called
a)
local variables
b)
global variables
c)
register variables
d)
none of the above
7. Which is not feature
of OOP in general definition?
a) Code reusability b) Modularity c) Duplicate/Redundant Data
d) Efficient Code
8. What is the first step
in the software development lifecycle?
a) system
design b)Coding c) System testing d)
Investigation and analysis
9. What is the name of
the computer program that simulates the thought process of human being?
a) Human logic b) expert reason c) expert system d) personal information
Group
B: Short Answer Questions (5 x 5=25)
10. What
is primary key? Explain different data security methods. [2+3]
Or
Demonstrate
the basic DDL statement with an example. [5]
11. What is JavaScript?
Write a program in JavaScript to find the factorial of a given number. [1+4]
Or
Explain
different types of PHP variables. [5]
12.
Define object and class?
What are the differences between a class and an object?[2+3]
13. What is feasibility
study? Explain its types. [1+4]
14. What do you mean by
robotics? Explain its characteristics. [1+4]
Group
C: Long Answer Questions (2 x 8=16)
15. Define the term
‘communication protocol’. List any four protocols and explain any two. [2+2+4]
16. Write a
program in C language to read name and marks of n number of
students and store them in a file named ‘student.txt’. [8]
Or
Write a program to read
the marks of any 5 students in a subject and count how many students are pass
and fail. [8]
No comments:
Post a Comment