HISSAN CENTRAL
EXAMINATION - 2079 (2023)
Grade: XII Time:
2 hrs
Subject:- COMPUTER
SCIENCE (TH) [4281 A] Full
Marks: 50
GROUP A [9×1=9]
Multiple
Choice Questions.
Choose the correct
answer.
1. In which normal form
of database transitive dependency should not be occurred?
A)
First
B) second
C) Third
d) All of above
2. Which of the
following techniques is used to grant privileges to user in a database?
A)
Authentication
B) Authorization
C) Isolation
D) Backup
3. Which SQL command is
used to display all the records from a table named STUDENT with "H"
as the first letter in the field FNAME (FIRST NAME)?
A) SELECT * FROM STUDENT WHERE FNAME LIKE
"H";
B) SELECT * FROM STUDENT WHERE FNAME LIKE
"H%";
C) SELECT * FROM STUDENT WHERE FNAME LIKE
"H%";
D) SELECT * FROM STUDENT WHERE FNAME LIKE
"H";
4. Which of the
following is a remote login service?
A) FTP
B)Telnet
C) SMTP
5. Which of the
following is a server-side scripting language?
A)
PHP
B) MySql
C) JavaScript
D) SQL
6. Which of the following
keywords are used to declare a variable in JavaScript?
A) int or suppose
B) float or int
C) var or let
D) char or var
7. What will be the
result of combining a string with another data type in PHP?
A)
Float
B) int
C) string
D) double
8. The process of hiding
internal details of a program and exposing the functionality is .....
A) Class.
B) Polymorphism.
C) Inheritance.
D) Data Abstraction.
9. Which of the
following is not a phase of SDLC?
A) Analysis.
B) Developing
C) Testing
D) Meeting
GROUP B [5x5=25]
Short Answer Questions
10. Suppose you are
appointed as an IT expert in a Hotel. What kind of database system you
preferred and why? [1+4]
OR
Most of the Hospitals
prefer applying a relational database model for database design compared to
other models. Justify the statement with your
arguments. [5]
11. Write a program in
JavaScript to add the values of any two variables. [5]
OR
How can you connect
MYSQL database with PHP? Demonstrate with an example. [5]
12. Differentiate
between OOP and procedural oriented language.
[5]
13. State various stages
of SDLC and explain any two. [5]
14. Explain mobile
computing with advantages. [1+2+2]
GROUP C [2x8=16]
Long
Answer Questions
15. Suppose you are
appointed as an IT expert of any bank which network architecture you prefer and
why? [2+6]
16. Write a program in C
using structure to enter the roll_number, name, and marks scored in english,
computer, maths and nepali of 10 students. Also, display them in proper format
along with the total
marks. [Note: the marks
should be between 0 and 100]. [8]
OR
Write a program in C to
create and store name, gender, and phoneno of students to a data file named
"ADDRESS.DAT". The program should prompt the user whether to continue
or not. The program should also display all the records in the proper format. [8]
THE END
-----------------------------------------------------------------------------------------------------------
Answer key:
1.) c 2).B 3.) C 4.) D 5.) A 6.) C 7) C 8.)D 9.) D
No comments:
Post a Comment