(XII) CDC Computer Model Set

Model Question Computer Science - XII School Leaving Certificate Examination 2078 Full Marks: 50 Time: 2 Hours Group A: Multiple Choice questions (9 x 1=9) Tick the correct answer. Q1. Which of the statements are used in DDL? A) Create, alter and drop B) Create, insert and select C) Insert, update and delete D) Delete, alter and drop Q2. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”? A) SELECT * FROM Persons WHERE FirstName='a' B) SELECT * FROM Persons WHERE FirstName LIKE 'a%' C) SELECT * FROM Persons WHERE FirstName LIKE '%a' D) SELECT * FROM Persons WHERE FirstName='%a%' Q3. Which of the following statements is true about a star network topology? A) Each device is connected to a switch or hub B) Each device is connected to each other C) Each device is connected in a trunk D) Each device is connected to a terminal Q4. Which of the following is the correct syntax to display "Stay Safe" in an alert box using JavaScript? A) alert-box("Stay Safe"); B) confirm("Stay Safe"); C) msgbox("Stay safe"); D) alert("Stay Safe"); Q5. What is the use of <a> tag? A) To insert an image B) To create a link C) To create a hyperlink D) To create a list Q6. What is the output of given C program?

#include<stdio.h> #include<string.h> main(){ char str1[] = "FIRST"; char str2[20]; strcpy(str2,str1); printf("%s %s ",str1,str2); printf(" %d ", (str1!=str2)); printf(" %d ", strcmp(str1,str2)); }

A) FIRST FIRST 0 0 B) FIRST FIRST 1 1 C) FIRST FIRST 1 0 D) FIRST FIRST 0 1 Q7. Where is a class derived in inheritance? A) Superclass B) Subclass C) Subsetclass D) Relativeclass Q8. Which of these is the correct order of the SDLC? A) Analysis, Design, Coding, Testing, Implementation B) Analysis, Design, Testing, Implementation, Coding C) Implementation, Coding, Analysis, Design, Testing D) Design, Testing, Implementation, Coding, Analysis Q9. Why is cloud computing popular nowadays? A) Cost-sharing and easily accessible B) As modern technology and costly C) Accessible and freely available D) Affordable to all Group B: Short Answer Questions (5 x 5=25) 1. Explain 2NF and 3NF with examples. OR Demonstrate the basic DML statement with an example. 2. Write a function to add any two numbers in Javascript. OR Demonstrate the external CSS implemented in the web page. 3. Describe any five features of OOPs. 4. What are the different stages of software planning? Describe. 5. Define the concept of AI and IoT. (2+3) Group C: Long Answer Questions (2 x 8=16) 6. How do you implement the Class C IP address in the local area network? Describe. 7. Write a program to enter ten integer numbers into an array, sort and display them in ascending order. OR Write a program to read the marks of any 5 students in a subject and count how many students are pass and fail.