Model questions from NEB (SET-A)
------------------------------------------------
Model
Question School Leaving Certificate Examination 2078
Grade:
Grade XII Full
Marks: 50 (9 marks Obj + 41 Marks Sub)
Subject:
Computer Science (Th)
Subject
code: 428
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 from 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. [5]
OR
Demonstrate
the basic DML statement with an example. [5]
11. Write a function to add any two
numbers in Javascript. [5]
OR
Demonstrate
the external CSS implemented in the web page. [5]
12. Describe any five features of OOPs. [5]
13. What
are the different stages of software planning? Describe. [5]
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. [8]
16. Write
a program to enter ten integer numbers into an array, sort and display them in
ascending order.[8] OR
Write a
program to read the marks of any 5 students in a subject and count how many
students pass and fail. [8]
------------------------------------------------------------------------------------------------------------------------------------------
Answer
keys:
- a
2. c 3.a 4. d. 5.c. 6.c 7. a 8. a. 9.a
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) drop
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) <css> and </css>
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
Define
server side scripting. Write a PHP program to connect to a database named ‘db’. [1+4]
Q12) Differentiate between procedure
Oriented programming and Object-Oriented programming.[5]
Q13) What is a software development
model? Explain about the 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]
answer keys:-
1. a 2. d 3.d 4. d 5.b. 6.d 7. c 8. a.
9.d
SET-C
Group A: Multiple Choice questions (9
x 1=9) Time: 20 minutes
- 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.
CREATE database database name (tabe(field1
data_type, field2 data_type,……));
- Which of the following is not an
example of DML (Data Manipulation Language)?
a.
INSERT
b.
UPDATE
c.
DELETE
d. GRANT
- 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
- …………………………… is not the phase of
the waterfall model.
a.
Requirement analysis
b.
Testing
c.
Build prototype
d.
Maintenance
- 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.
<style></style>
- The
prevention of data from unauthorized access is…………….
a.
Data
security
b.
Data
integrity
c.
Data
misuse
d.
Data
sharing
- 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.
computing
- A variable which holds the
memory address of another variable is…………………….
a.
Function
b.
Pointer
c.
Array
d.
Structure
- 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)
- Explain Cloud Computing with its
characteristics. [2+3]
- What is DBMS? Write its advantages and disadvantages. [1+4]
OR
What is
normalization? Write its advantages. [1+4]
- WAP to display the largest among three numbers
using JavaScript.[5]
Or
Write steps to fetch
records from the database and to print in the browser. Take support of PHP
code. Let the database is ‘db’ and table is
test(t_id,test_taker_name,test_score).Here
t_id is a primary key. [5]
- Explain OOP with its features. [5]
- Explain SDLC with its phases(any two). [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]
answer keys:-
1. b 2. d 3.d 4. c 5.a. 6.a 7. a 8. b.
9.b
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 2.5 NF
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 PHP code to find the square of a number. [5]
Q12) What are the different
types of inheritance? Explain them. [5]
Q13)
Describe in brief, the process of the prototype model.
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 the 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 input records of 10 employees(id,name
and salary) using structure.Then print them. [2+6]
answer keys:-
- a
2. a 3.d 4. b 5.d. 6.a 7. b 8. a. 9.c
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. … is
an example of half-duplex mode of data communication.
a. TV
b. Radio
c. Walkie-Talkie
d. Internet
4.
In JQUERY,what does the syntax $("p.para") will select?
a.
The first
paragraph element with class = "para"
b.
The first
paragraph element with id = "para"
c.
The first
paragraph element with name = "para"
d.
All paragraph
elements with class = "para"
5. Which of the following functions is used to unset a
variable in PHP?
e.
delete()
f.
unset()
g.
unlink()
h.
kill()
6. What will fopen will
return if there is any error while opening a file?
a. Nothing
b. NULL
c. EOF
d. The return value depends upon compiler
we use.
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 the primary key? What are the features of a good primary key? [1+4]
11. What is event handling in JavaScript? Explain with example. [2+3]
OR
What is variable? Write
rules to use variables in PHP. [1+4]
12. Define data abstraction and
encapsulation. Mention their main advantages in OOP.[2+3]
13. Explain internet of things (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)
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]
answer keys:-
1. a 2. d 3.c 4. d 5.b. 6.b 7. d 8. c.
9.b
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) ASP
c) JSP
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) super variables
7. Which is not a 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
any two operators with the help of PHP code. [2.5+2.5]
12. Define object and
class? What are the differences between a class and an object?[2+3]
13. What is a 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 pass and
fail(to be pass, the marks>=40) [8]
answer keys:-
- d
2. b 3.a 4. d 5.b. 6.a 7. c 8. d. 9.c
set
G
Attempt all the questions.
Group 'A'
Rewrite the correct options of each questions in your
answer sheet. 9x1=9
1. Which of the following SQL statement is used to DELETE
rows from a database table?
A) DELETE B) REMOVE C)
DROP D) CLEAR
2. A field that is used to uniquely called:
A) Primary
Key B)Entity C)
Relationship D) Constraints
3. What does "MAC" stands
A) Mandatory Access Control B) Media Access Control
C) Micro Access Control D) Media
Access Certificate
4. What is the correct syntax for referring to an
external JavaScript script?
A) <script
src="myscript.js"></script> B)
<script href="myscript.js"></script>
C) <js href="myscript.js"></js> D) <js
src="myscript.js"></js>
5. 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;
6.What is the output of C program?
void main()
{
int b=25;
//b memory
location=1234;
int *p;
p=&b;
printf("%d %d", &b, p);}
A) 25 25 B)
1234 1234 C) 25 1234 D) 1234 25
7. Which feature of OOP illustrates the code reusability?
A) Polymorphism B) Abstraction c) Encapsulation D)
Inheritance
8. 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
9. 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
Group 'B'(5x5=25)
Short answer questions
10. Differentiate the centralized and distributed
database system. [5]
OR
What are the purposes of normalization?Give an example of
2NF. [1+4]
11. Write a program to find the factorial of any number
using Javascript. [5]
Or
How do you fetch data from a database in PHP and display
it in form? Describe.[5]
12. Compare the OOPs and procedural programing language. [5]
13. What are the major activities performed to design the
software? Describe. [5]
14 Explain the popular five-application areas of AI. [5]
Group 'C' (8x2=16)
Long answer questions
15. Compare the star and ring topology with pros and cons. Which data communication cable is more appropriate to design the local area network? Describe. [5+3]
16. What is structure? Write a program to input roll,
name and age of 5 students and display them properly using structure. [2+6]
OR
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. [8]
-0-
answer keys:-
1. a 2. a 3.b 4. a 5.b. 6.b 7. d 8. b.
9.d
SET
H
Multiple choice questions [9×1=9]
Subject:-computer science
Time: 20 Minutes
GROUP A
Tick the correct answer.
1. Which of the statements are used in the DML statement?
a) Select,
drop, where
b) Select,
insert, delete
c) Select,
drop, update
d) Select,
insert, drop
2. With SQL, how do you select all the records from a
table named "employee" where the value of column "ename" is
"john"?
a)Select * from
employee where ename is exactly john ;
b)Select * from
employee where ename is equal to 'john' ;
c)Select * from
employee where ename="john';
d)Select * from employee where ename is not in
john;
3. What is the first step in the software development
lifecycle?
a) System
design
b) System
testing
c) Coding
d) System
analysis
4. What is the minimum number of functions to be present
in a C program?
a. 4 b. 1 c. 2
d. 3
5. What kind of transmission medium is most appropriate
for carrying data in a computer network that is exposed to electrical
interference?
- Unshielded twisted
pair b. Optical fiber c. Coaxial
cable d. Microwave
6. What should be the correct syntax to write a PHP code?
a.< php
> b. <?php ?> c. <? ?> d. Php
7. Which jQuery method is used to hide selected elements?
a. hidden() b.
display(none) c.hide() d. visible(false)
8. Which Key is used to uniquely identify a record?
a. Primary Key b.
Foreign Key c. Both a. and b. d. None of the mentioned
9. Which of the following is not an unguided
communication media?
a. Twisted pair wire
b. Satellite c. Microwave d. Bluetooth
GROUP B
Short answer questions: [5x5=25]
10. Explain INF and 2NF with examples. [5]
OR
Demonstrate any three DDL statements with example. [5]
11. What is OOPS? Define the terms class, polymorphism and Object. [2+3]
12. What do you mean by feasibility study? Why is it
necessary before designing a system?[2+3]
13.
14.
OR
Write a PHP program to multiply two numbers. [5]
Group C
Long answer
questions [2x 8=16]
15. Define IP address. Explain any three different types
of IP address. [2+6]
16. Define structure. Write a C program to store
information of 10 students (eid, ename, class) and display it using structure
variable. [2+6]
Or
What is a pointer? Write a C program to read a 3 numbers
and find its product using pointer.[2+6]
THE END
==================================================================================
answer keys:-
1. b 2. c 3.d 4. b 5.b. 6.b 7. c 8. a.
9.a
SET
I
Group A:
Multiple Choice Questions
Attempt ALL questions:
1. In hierarchical Model records are organized as
a. Table b. Tree
c. List d.links
2. Wireless medium is also called…medium.
a. Guided b.
Unguided c. Unbounded d.Both b and c
3. The… loop is also called an entry-controlled loop.
A.while b. do...
while c. switch d.for
4. Which feature of C++ illustrated data wrapping
facility?
a. Class b. Abstraction c. Encapsulation d. Object
5.Inside which HTML element do we put the JavaScript?
a. <head> b. <script> c. <meta> d.<style>
6. C Programming was developed in....... . lab.
a. AT&T b. Bell
c. both a and b d.Bill
7. Radio broadcast system is an example of..........
Transmission.
a. Simplex
b.half Duplex c. full duplex d. None of them
8. PHP's numerically indexes array begins with positional
value ….
a. 1 b. -1 c. 0
d. 2
9. Robot is derived from Czech word
a. Robata b. Robota c. Rebota
d. Ribota
Group B: (5×5=25)
Short Questions Answer
Attempt all the questions.
10.
Or
What is data security? How can it be implemented? [1+4]
11. Describe the Bus and Star topology with suitable
diagram advantages and disadvantages.[5]
12.
13. What is a user defined function? WAP to input length,
breadth of a pond and find its area by using user-defined function. [1+4]
14. What is agile development? Explain the principles of
agile development. [1+4]
Group-C (8x2-16)
Attempt any TWO questions
Long Answer Questions
15. What is cloud computing? Explain the types of cloud
computing and cloud services.[2+6]
Or
What is SQL? Explain any three types of SQL with example.
[2+6]
16. What is a loop? Explain one type of loop with an example. WAP which finds the sum, difference and product of 2 numbers using switch case statement. [3+5]
17.
What do you mean by random access to a file? WAP to enter name, post and age, address and salary of an employee and add it in a file "Emp.txt". [2+6]
answer keys:-
1. b 2. d 3.a 4. c 5.b. 6.c 7. a 8. c.
9.b
Worksheet
A
Rewrite the correct options of each questions
in your answer sheet.
1. Which of the following SQL statement is
used to DELETE rows from a database table?
A) DELETE B) REMOVE C)
DROP D) CLEAR
2. A field that is used to uniquely called:
A) Primary Key B)Entity C)
Relationship D) Constraints
3. For a table customer(cid,cname,caddress),
to fetch records of all customers, we use
- Select all
from customer; c. Select * from
customers;
- Select all
fields from customers; d.
Select all from table customers;
4. Transitive dependency is associated with
- 1N b. 2N c. 3N d. 0N
5. What does "MAC" stands
A) Mandatory Access Control B) Media Access Control C) Micro Access Control D) Media Access Certificate
6.
There is no interference in
- UTP cable b. STP cable c. optical fiber d.coaxial cable
7. The IP …. Belongs to class A.
- 112.23.32.4 b. 145.32.33.4 c. 167.23.32.44 d.
139.23.32.12
8. What is the correct syntax for referring to
an external JavaScript script?
A) <script src="myscript.js"></script> B) <script
href="myscript.js"></script>
C) <js
href="myscript.js"></js> D)
<js src="myscript.js"></js>
9. 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;
10. Which is the function used for database
connection?
- mysqli_connect() b.
mysqli_connect_database() c.
databse_connect()
D. connect_database()
11.What is the output of a C program?
void main()
{
int
b=25;
//b memory location=1234;
int *p; p=&b;
printf("%d %d", &b, p);}
A) 25 25 B)
1234 1234 C) 25 1234 D) 1234 25
12. How many parameters can be passed in the
function fopen()?
- 1 b. 2 c. 3 d. 4
13. Which feature of OOP illustrates the code
reusability?
A) Polymorphism B) Abstraction c) Encapsulation D) Inheritance
14. 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
15. 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
GROUP B
Q1. Differentiate between centralized and
distributed database.
Q2. compare OOP and POP.
Answer keys:
1.
A 2. A 3.c 4. C 5. b 6. C 7.a 8.a
9.b 10. A 11.b 12. B 13.d 14. B 15.d
WORKSHEET SET B
Rewrite the correct options of each question
in your answer sheet.
1. Which of the statements are used in the DML
statement?
a) Select, drop,
where
b) Select, insert,
delete
c) Select, drop,
update
d) Select, insert,
drop
2. With SQL, how do you select all the records
from a table named "employee" where the value of column
"ename" is "john"?
a)Select * from employee where ename is
exactly john ;
b)Select * from employee where ename is equal
to 'john' ;
c)Select * from employee where
ename="john';
d)Select * from employee where ename is not in
john;
3. A _______________ key is a minimal super
key.
a) Primary
b) Foreign
c) Candidate
d) Non-Prime
4.In order to build a link between two tables,
which key is used?
A.
Primary
B.
Foreign
C.
Composite
D.
Unique
5.
Which of the following is not an unguided communication media?
a. Twisted pair
wire b. Satellite c. Microwave
d. Bluetooth
6. What kind of transmission medium is most
appropriate for carrying data in a computer network that is exposed to
electrical interference?
a.
Unshielded twisted pair b. Optical fiber c. Coaxial cable d.
Microwave
7.
Which software prevents external access to a system?
a.
Firewall
b.
Gateway
c.
Router
d.
Virus checker
8. Which jQuery method is used to hide
selected elements?
a. hidden() b. display(none) c.hide() d. visible(false)
9. What should be the correct syntax to write
a PHP code?
a.< php > b. <?php ?> c. <? ?> d. Php
10. Which of the following is used for
concatenation in PHP?
a.
+ (plus)
b.
* (Asterisk)
c.
. (dot)
d.
append()
11. What is the first step in the software
development lifecycle?
a) System design
b) System testing
c) Coding
d) System analysis
12. The rename() function in C language takes
… arguments.
a. 4 b. 1 c. 2 d. 3
13. Can we change the starting index of an
array from 0 to 1 in any way.?
A) Yes. Through
pointers.
B) Yes. Through Call
by Value.
C) Yes. Through Call
by Reference.
D) None of the above.
14.Which feature of OOPS derives the class
from another class?
- Inheritance
- Data hiding
- Encapsulation
- Polymorphism
15.Which one of the following is Cloud
Platform by Amazon?
- Azure
- AWS
- Cloudera
- All of the
mentioned
GROUP B
Q1. Define feasibility study. Explain its
types.
Q2. What is cloud computing? Explain its types
in brief.
1.
b 2. c 3.c 4. a 5. a 6. b 7.a 8.c
9.b 10. c 11.d 12. c 13.d 14. a 15.b
Worksheet SET C
Rewrite the correct options of each question
in your answer sheet.
1. In hierarchical Model records are organized
as
a. Table b. Tree c. List d.links
2.In 2NF which forms of dependency is removed?
A). Functional
B). Partial
C). Associative
D). Transitive
3.In an E-R diagram a relationship is
represented by________?
A). Ellipse
B). Rectangle
C). Rectangle with
rounded corners
D). Diamond
4.Which one of the following given statements
possibly contains the error?
a.
select * from emp where empid =
10003;
b.
select empid from emp where empid
= 10006;
c.
select empid from emp;
d.
select empid where empid = 1009
and Lastname = 'GELLER';
5. Wireless medium is also called…medium.
a. Guided b. Unguided c. Unbounded d.Both b and c
6.The length of an IPv6 address is…
a.
32 bits
b.
64 bits
c.
128 bits
d.
256 bits
7.In specific, if the systems use separate
protocols, which one of the following devices is used to link two systems?
a.
Repeater
b.
Gateway
c.
Bridge
d.
Hub
8. In JQUERY,what does the syntax
$("p.para") will select?
a.
The first paragraph element with
class = "para"
b.
The first paragraph element with
id = "para"
c.
The first paragraph element with
name = "para"
d.
All paragraph elements with class
= "para"
9. The… loop is also called an
entry-controlled loop.
A.while b.
do... while c. switch d.for
10.What is the output of C Program with arrays
and pointers.?
int main()
{
int ary[] = {10,20,30}, *p;
p = &ary[0];
int i=0;
while(i<3)
{
printf("%d ", *p);
p++;
i++;
}
return 0;
}
A) 10 10 10
B) 10 20 20
C) 10 20 30
D) randomvalue
randomvalue randomvalue
11.Which of the following function is used to
unset a variable in PHP?
a.
delete()
b.
unset()
c.
unlink()
d.
None of the above
12.Which of the following is the correct way
to create an array in PHP?
a.
$season = array["summer"
, "winter" , "spring" , "autumn"];
b.
$season = array("summer"
, "winter" , "spring" , "autumn");
c.
$season = "summer" ,
"winter" , "spring" , "autumn";
d.
$season = {"summer" ,
"winter" , "spring" , "autumn"};
13. Which feature of C++ illustrated data
wrapping facility?
a. Class b.
Abstraction c. Encapsulation d. Object
14. IN SDLC, which maintenance says that fix
the bugs/faults?
a.
Adaptive maintenance
b.
Corrective maintenance
c.
Perfective maintenance
d.
Preventive maintenance
15.In cloud computing,by whom is the backend
commonly used?
a.
Client
b.
User
c.
Stockholders
d.
service provider
GROUP B
Q1. What is database security? How would you
apply this to the database of an organization?
Q2. Explain about the Agile development model.
Answer keys:-
1.
b 2. A 3.d 4. d 5. d 6. C 7.b 8.d
9.a 10. c 11.b 12. B 13.c 14. B 15.d
No comments:
Post a Comment