(XII) Computer Third Term Management 2078

Trinity International SS & College 3rd Term Examination 2079 Grade – XII Management – Morning Shift Computer Science Candidates are requested to give their answers in their own words as far as practicable. The figures in the margin indicate full marks. Time: 2 hrs. Full Marks: 50 Group ‘A’ (Multiple Choice Questions) Tick the best alternative. (9x1=9) Q1. Which of the following statements can not be rollback? (a) Data Manipulation Language (b) Data Definition Language (c) Data Control Language (d) 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= "Trinity"; var B="College"; document.write(B+A); (a) Trinity (b) TrinityCollege (c) Trinity Collegee (d) CollegeTrinity Q6. What is the output of given C program? int a = 4 , b = 2; 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 (b) Inheritance (c) Polymorphism (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 odd or even. (5) OR Write PHP code to find cube of 7. (5) Q12. Explain different types of inheritance properties of OOP. (5) Q13. Explain any two types of feasibility study. Q14. Explain any two areas where AI can be used ? Group ‘C’ Give long answer to the following question. (2x8=16) Q15. What do you mean by LAN 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 descending order on the basis of marks. (8) OR Write a program in C to create a data file “score.txt” which stores Student ID, Name, marks of computer until user press yes. After that display all the records of file “score.txt”. (4+4) The End