NEB MODEL SET FOR COMPUTER GRADE 12 - SET D

 

SET D

Group - A Multiple Choice Questions (1*9=9)

1. In the ______________normal form, a composite attribute is converted to individual attributes: 

a) First b) Second c) Third d) Fourth 

2. Which of the following command is used to display name, class and roll number of roll number 20 inserted in a table "student"? 

a) SELECT NAME, CLASS, ROLL from student WHERE ROLL like 20 

b) SELECT all ROLL from student where ROLL = 20 

c) SELECT NAME, CLASS, ROLL from student where ROLL = 20 

d) SELECT NAME, CLASS, ROLL in student where ROLL = 20 

3. Which of the following 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. The of use of echo in JavaScript is to __________

a) Assign value b) display value c) echo value d) list value 

5. PHP code starts with_____?

a) <?PHP b) <? c) <PHP d)?>

6. What is the output of the given C program? 

void main () 

{ 

char str1[] = "ABC COLLEGE"; char str2[20]; strcpy(str2, str1); 

printf("%s %s%d", str1,str2, strlen(str1));

}

a) ABC COLLEGE ABC COLLEGE 16 

b) ABC COLLEGE ABC COLLEGE 15 

c) ABC COLLEGE 16 

d) None of these(a,b,c) 

7. In Inheritance, a class derived is from? 

a. Superclass b. Subclass 

c. Subset class d. Relative class 

8.________of the system gives long life to the new system.

a) Implementation b) Maintenance c) Analysis d) Design

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 Question Answers (5*5=25)

1. Explain data security and its types with examples. 

OR

Demonstrate primary key and alternate key with an example. 

2. Write a function to print sum, product and difference of two numbers in JAVA Script. 

OR

Write a PHP code to create a database in MySql with checking the database connectivity. 

3. Describe any five features of OOPS. 

4. What are the different software models? Describe any two of them with advantages and disadvantages. 

5. Explain Al and different types of Al and also explain Big data and its types in brief.

Group-C: Long Question Answers (8*2=16)

6. What is network topology? Explain star, bus and ring topology with advantages and disadvantages. 

7. What is string handling function? Explain any five string handling functions with examples. 

OR

Explain fscanf() and fwrite function with examples. Also write a program in C to read the marks of 5 subjects of any five students from a file "marks.dat" and calculate total marks and average marks. Also print all the information in appropriate format. [2+6] 

SET E

Group - A Multiple Choice Questions (1*9=9)

1. Which of these is the correct order of the SDLC?

1. Analysis, Design, Coding, Testing, Implementation 

2. Analysis, Design, Testing, Implementation, Coding

3. Design, Testing, Implementation, Coding, Analysis 

4. Coding, Analysis, Design, Testing, Implementation

2.  A topology in which all nodes are connected with a central hub............... 

1. Bus 

2. Star 

3. Tree 

4. Mesh 

3.  A variable which holds memory address of next variable is called.... 

(a) Function 

(b) Pointer 

(с) Агтау 

(d) Structure 

4. ………………. means using the Internet and the web for education. 

a. E-medicine 

b. E-education 

c. E-health 

d. E-commerce 

5. ...........is a process where you show only "relevant" data and "hide" unnecessary details of an object from the user. 

(a) Abstraction 

(b) Polymorphism 

(c) Inheritance 

(d) Encapsulation 

6. Which of the following is an example of full duplex mode of communication......? 

a. Mobile Phone 

b. Walkie-Talkie 

c. Radio 

d. All of above 

7. The key that identifies each record uniquely, is called 

a. Primary Key 

b. Record Key 

c. Unique Key 

d. Keyword 

8. PHP stands for 

a. Hypertext preprocessor 

b. Preprocessor Hypertext 

c. Pre hypertext processor

d. All of the above 

9. What of the following is the correct syntax to Display "Nepal" in an alert box using JavaScript? 

a. alert-box("Nepal"); 

b. alert("Nepal");

c. confirm("Nepal"); 

d. All of the Above 

Group B Short Question Answers (5*5=25)

1. What is DBMS? Write some advantages and disadvantages of 

OR

Differentiate between Centralized and Distributed Database.

2. WAP to calculate difference of two numbers using JavaScript. 

OR 

Differentiate between Client-Side Scripting and Server-Side Scripting. 

3. What is Cloud Computing? Write some advantages of Cloud Computing. 

4. Explain the term abstraction, encapsulation, inheritance and polymorphism. 

5. Explain SDLC with necessary diagram. 

Group-C: Long Question Answers (8*2=16)

1. Define Communication System and explain each component of communication system with necessary diagram. Explain simplex, half duplex and full duplex mode of communication. 

2. WAP to input name and address of 5 employees and sort them in descending alphabetic order according to their name. 

OR 

WAP to open a new file and read rollno, name, address and phone number of students until the user says "no", after reading the data, write it to the file and display the content of the file. 

SET F

Group ‘A’

(Multiple Choice Questions) (9x1=9)

Tick the best alternative.

 Q1. Find the error in the following SQL statement. 

SELECT * ;

1. No error

2. No table mentioned 

3. Depends

4. 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= "ABC"; var B="College"; 

document.write(A+B); 

(a) ABC (b) ABCCollege

(c) ABC College (d) CollegeABC 

Q6. What is the output of given C program? 

int a = 9, b = 42; 

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 

(c) Polymorphism 

(b) Inheritance 

(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 prime or composite. (5) 

OR

Write PHP code to find cube of 10. (5) 

Q12. Explain different types of inheritance properties of OOP. (5) 

Q13. Explain stages of SDLC with its diagram. 

Q14. Explain any two areas where Al can be used? 

Group 'C'

Give long answer to the following question. (2x8=16) 

Q15. What do you mean by 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 ascending order on the basis of registration number. (8) 

OR

Write a program in C to create a data file "score.txt" which stores Student ID, Name, marks of computer as per need of user. After that display all the records of file "score.txt". (4+4)