Grade 12
Computer model question 2080
Set 2
Model question grade 12 2080
Class: XII F.M: 50
Subject: Computer Science Time: 2hrs
Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.
Group A: Multiple Choice Questions (9 × 1=9)
Tick the best alternatives:
1. All the candidate
remaining candidate key which are not selected as a primary key are called
……………
a) Foreign Key
b)
Compound Key
c) Alternate Key
d) Composite Key
2. Which of the
following statements is true about the star topology?
a) Each device is
connected to a switch or hub
b) Each device is
connected to each other.
c) Each device is
connected to a terminal
d) Each device is
connected to trunk.
3. Which query is
used to delete a table.
a) DROP TABLE
b) DELETE TABLE
c) REMOVE TABLE
d) RD TABLE
4. The …………. Layer
establishes and terminates a connection between two physically connected nodes
on network.
a) transport
b) session
c) data link
d)
physical
5. Which of the
following method sends input to a script via a URL?
a) Get
b) Post
c) onfocus
d) RMI
6. What would be the
output of following C code?
#include
<stdio.h>
void f(int x)
{
return x;
}
int main ()
{
f (7);
f(8);
return 0;
}
a) 0 b) 9 c) 2 d)
8
6. The process of
creating multiple classes from an existing class is called ……….. inheritance.
a) single
b) multiple
c) hierarchical
d)
multilevel
7. The data flow diagram (DFD) shows;
a) the flow of data
b) the processes
c) the
areas where they are stored
d) All of the above
8. The primary objectives of system designs is:
a) design the
programs, databases and test plans
b)
design only the user interface
c)
implement the system
d)
find out how the system will perform
9. Which of the
following is the component of AI?
a) Learning
b) Training
c) Designing
d)
Puzzling
Group ‘B’
Give short answer
to the following questions. (5 × 5=25)
10. Explain
hierarchical and relational database model.
OR
What
is key? Explain the primary key, foreign key and alternate key.
11. Write a JavaScript program to check the input
number is prime or composite.
OR
Write a PHP code to insert a records
in a database name student with fields id, name and post.
12. Differentiate
between structured programming and Object-oriented programming
13. Define the term
feasibility study? Explain the different types of feasibility study.
14. What is cloud computing? Explain the types of cloud
computing.
Group
‘C’
Give long answer to the following question (2 × 8=16)
15. a. Explain client
server and peer-to-peer architecture.
b.
Write the differences between LAN and WAN.
16. Write a C program
to enter the roll number, name and four subject marks of student and calculate
and display total using structure.
OR
What is pointer? Explain the advantages of pointer.
Write the program to write name, age and fee to a file “STUD.DAT”
Best of luck
