MODEL SET D - COMPUTER 12 - HISSAN

 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]