grade-12-model-question-set

Grade 12 
Computer model question 2081

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