School Leaving Certificate

               NEB Model question of computer 

                                            2079

Grade: Grade XII               Subject: Computer Science      

Full Marks: 50(9 Marks Obj + 41 Marks Sub)                             

Time: 2 Hours    

                              

             Group A: Multiple Choice questions (9 x 1=9)            

Tick the correct answer          (Time: 20 minutes)

1. 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

2. With SQL, how do you select all the records from a table named 'Person' 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%‟ 

3. 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

4. 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");

5. What is the use of tag? 

 A) To insert an image                B) To create a link

 C) To create a hyperlink           D) To create a list 

6. What is the output of given C program?

void 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  

7. Where is a class derived in inheritance?

 A) Superclass                             B) Subclass

 C) Subsetclass                           D) Relativeclass 

8. 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

9. 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. 



 

 

Comments