HISSAN CENTRAL EXAMINATION – 2079 (2023) -computer model question - class 12

 

HISSAN CENTRAL EXAMINATION – 2079 (2023)

Grade: XII

Time: 2 hrs Full Marks: 50

COMPUTER SCIENCE (TH) [4281 A]

 

GROUP A

Multiple Choice Questions [9×1=9]

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 the 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               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 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

Short Answer Questions [5×5=25]

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. [1+2+2] 14. Explain mobile computing with advantages. [5]

 

GROUP C

Long Answer Questions [2×8=16]

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