NEB MODEL SET FOR COMPUTER GRADE 12 - SET F

 SET F

Group ‘A’

(Multiple Choice Questions) (9x1=9)

Tick the best alternative.

 Q1. Find the error in the following SQL statement. 

SELECT * ;

1. No error

2. No table mentioned 

3. Depends

4. None 

Q2. What identifies a row in a table as unique? 

(a) Main Key (b) Regular Key

(c) Primary Key (d) Foreign Key

Q3. The location of a resource on the internet is given by its_____?

(a) Protocol (b) URL 

(c) Email ID (d) None

Q4. The term 'HTTP' stands for_______

(a) Hyper Text Transfer Protocol (b) Hypertext Tracing Program

(c) Hyper Text Terminal Protocol (d) Hyper Type Transfer Protocol

Q5. What will be the output of following JavaScript code?

var A= "ABC"; var B="College"; 

document.write(A+B); 

(a) ABC (b) ABCCollege

(c) ABC College (d) CollegeABC 

Q6. What is the output of given C program? 

int a = 9, b = 42; 

printf("%d",a>b); 

printf("%d",a<b); 

(a) 0 0

(b) 0 1

(c) 1 0

(d) 1 1 

Q7. Which of the following features must be supported by any programming language to become a pure object-oriented programming language? 

(a) Encapsulation 

(c) Polymorphism 

(b) Inheritance 

(d) All of the above 

Q8. Which of the following is the working culture of an Agile team? 

(a) Connective 

(b) Connective 

(c) Collaborative 

(d) Contemplative 

Q9. Transaction of data of the bank is a type of__________.

(a) Unstructured Data 

(b) Structured Data 

(c) Both Structured and Unstructured Data 

(d) None of above 

Group 'B'

Give short answer to the following questions. (5x5=25)

Q10. Explain normalization with its advantages. Give an example of First NF. (3+2) 

OR

Write syntax and one example of CREATE TABLE and INSERT. (Make necessary assumptions)

Q11. Write a JavaScript program to check whether the given number is prime or composite. (5) 

OR

Write PHP code to find cube of 10. (5) 

Q12. Explain different types of inheritance properties of OOP. (5) 

Q13. Explain stages of SDLC with its diagram. 

Q14. Explain any two areas where Al can be used?

Group 'C'

Give long answer to the following question. (2x8=16) 

Q15. What do you mean by topology? Explain Bus, Star and Ring Topology with their diagrams. (2+6) 

Q16. Write a C program to store registration number, name and marks of 3 students using structure and display them in ascending order on the basis of registration number. (8) 

OR

Write a program in C to create a data file "score.txt" which stores Student ID, Name, marks of computer as per need of user. After that display all the records of file "score.txt". (4+4)