Trinity International SS & College Second Term Examination 2078 Grade – XII Science – 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. ____ is not a DDL command. (a) UPDATE (b) TRUNCATE (c) ALTER (d) None of the above Q2. Which SQL keyword is used to retrieves a maximum value? (a) MOST (b) TOP (c) MAX (d) UPPER Q3. The cabling structure of a network is called _______ (a) Topology (b) Arrangements (c) Physical Structure (d) None Q4. An example of half-duplex mode is ______ (a) Newspaper (b) Radio (c) Walkie-Talkie (d) Telephone / Mobile Q5. Which of the following is an example of WAN? (a) Network within a building (b) Network within a city (c) Network within country (d) WWW Q6. An example of server-side scripting language is... (a) PHP (b) CSS (c) HTML (d) all of above Q7. Which of the following statement is not a type of conditional statement? (a) do-while (b) nested if-else statement (c) If else (d) if statement. Q8. What is meant by 'a' in the following C operation? fp=fopen('random.txt","r"); (a) Read (b) write (c) create (d) None of above Q9. A term attribute refers to a _______ of a table. (a) Record (b) Column (c) Tuple (d) Key Group ‘B’ Give short answers to the following questions. (5x5=25) Q10. Explain network architecture with their types.. (5) OR What is an operator in JavaScript. Write a program using JavaScript to display the factorial of a given number. Q11. What is normalization? Compare 1 NF and 2 NF with examples. (1+4) Q12. What is database security? Why it is important? Explain the roles of DBA. (5) OR Define the term “networking”. Explain its advantages. (1+4) Q13. What is a user-defined function? Difference between pointer and array. (1+2+2) Q14. Write a program in C Using a structure that takes roll_no, fname, lname of 5 students and prints the same record in ascending order on the basis of roll no. (5) Group ‘C’ Give a long answer to the following question. (2x8=16) Q15. What is the OSI reference model? Explain with layers. (1+7) OR Write a SQL statement to create a table named job history including columns employee_id, start,_date , end_date,job_id,and department_id and make sure that the value against column end_date will be entered at the time of insertion to the format like’--/--/----/’. Q16. Write a program in C to create a data file “employee.txt” which stores employee id, first name, last name, and salary until you press y-yes and finally display the contents of the data file. (8 ) The End