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
