Computer Science questions 2
EXAMINATION – 2079 (2023)
Grade: XII
Time: 2
hrs
Full Marks: 50
COMPUTER SCIENCE (TH) [4281 B]
GROUP A
Multiple Choice Questions
9*1=9
Choose the correct answer.
1. In which normal form of database all the
attributes of the non-primary keys are fully dependent on primary keys?
A) First B)
Second
C) First and
Second D) All of the above
2. Which one of the following refers to the "data about data"?
A) Directory B) Data mining
C) Metadata D)
Data warehouse
3. Which of the following statement is correct to display all the cities
with the condition, temperature,
and humidity whose humidity is in the range of
60 to 75 from the
'whether' table?
A) SELECT * FROM weather WHERE humidity IN (60 to 75);
B) SELECT * FROM weather WHERE humidity BETWEEN 60
AND 75
C) SELECT * FROM weather WHERE humidity NOT IN (60 AND 75)
D) SELECT * FROM weather WHERE humidity NOT BETWEEN
60 AND 75
4. Which of the following is a file transfer
service?
A) FTP B)
Telnet
C) SMTP D)
All of the above
5. Which of the following is a server-side scripting language?
A) PHP B) MySql
C) JavaScript D) SQL
6. Which syntax is used for
opening and closing a PHP script?
A) <php> . . .
</php> B)
<?php. . .?>
C)? php . .
.? php D) <p> . . . </p>
7. What output will be obtained from the following JavaScript?
var a=15; var
b=0;
console.log(a/b);
A) 15 is printed B) 0 is printed
C) Infinity is printed D)
Garbage value
8. The process of deriving new class from base class is …...
A) Class.
B) Polymorphism.
C) Inheritance.
D) Data Abstraction.
9. When can white-box testing be started?
A) After analysis B) After programming
C) After
designing D) After installation
GROUP B
Short Answer Questions
[5x5=25]
10. Suppose you are appointed as an IT expert in a School. What kind
of database model you preferred and why? [1+4]
OR
Most of the Hotel prefer applying a centralized database system. Justify the statement with your arguments. [5]
11. Write a program in JavaScript to calculate factorial of a number. [5]
OR
How can you connect MYSQL database with PHP? Demonstrate with an example. [5]
12. Explain any two characteristics of object-oriented programming. [5]
13. List
out different stages of SDLC and explain any two. [1+2+2]
14. Explain Artificial Intelligence with advantages. [5]
GROUP C
Long Answer Questions
[2x8=16]
15. Suppose you are appointed as an IT expert of any bank which LAN topology you suggested to design and why? [2+6]
16. Write a program in C using structure to enter the id, name, and
marks scored in computer,
social, math’s and law of 20 students. Also, display them in proper format along with the percentage. [Note: the marks should be
between 0 and 100]. [8]
OR
Write a program in C to create and store same,
address, and contact no of
students to a data file named “LOCATION.DAT” and display all the records in the
proper format. [8]
THE END
Comments
Post a Comment