NEB Students
Computer Science

NEB — CLASS 12

Computer Science

Model Question

Answer each question in your own words as far as practicable. The figures in the margin indicate full marks.

सबै प्रश्नको उत्तर दिनुहोस् । (Attempt All Questions)

Time : 3 hrsPass Marks : 20Full Marks : 50
1.

In which normal form of database, atomicity is introduced?

a. First
b. Second
c. Third
d. Fourth
[1]
2.

Which of the following techniques is not implemented to protect a database?

a. Rollback
b. Backup
c. Recovery
d. Firewall
[1]
3.

Which one of the following SQL commands is executed to display all the records having a second letter in the LNAME (LAST NAME) as "A" from the customer table?

a. SELECT * FROM CUSTOMER WHERE LNAME LIKE "?A%";
b. SELECT * FROM CUSTOMER WHERE LNAME LIKE "_A%";
c. SELECT * FROM CUSTOMER WHERE LNAME LIKE "A%";
d. SELECT * FROM CUSTOMER WHERE LNAME LIKE "%A";
[1]
4.

Which of the following is an incorrect IP address?

a. 192.168.0.1
b. 192.168.1
c. 172.255.0.0
d. 202.10.79.4
[1]
5.

Which of the following is a server-side scripting language?

a. JavaScript
b. MySQL
c. PHP
d. jQuery
[1]
6.

Which of the following keywords are used to declare a variable in JavaScript?

a. int or var
b. float or let
c. var or let
d. char or var
[1]
7.

Which of the following commands is executed in PHP to concatenate the variables $x and $y?

a. $x + $y
b. $x . $y
c. concat($x, $y)
d. $x & $y
[1]
8.

Which statement is incorrect about the object-oriented approach?

a. Emphasis is on data rather than procedure.
b. Data is hidden and cannot be accessed.
c. Objects communicate through functions.
d. It supports abstract data but not the class.
[1]
9.

Which of the following feasibility study is concerned with cost benefit analysis?

a. Technical feasibility
b. Economic feasibility
c. Operational feasibility
d. Schedule feasibility
[1]
10.
Which type of database system (centralized or distributed) is mostly preferred by financial institutions like a bank? Give any four suitable reasons.
Or

Nowadays most business organizations prefer applying relational model for database design in comparison to other models. Justify the statement with your arguments.

[1]
11.

Develop a program in JavaScript to exchange/swap the values of any two variables.

Or

How can you connect a database with PHP? Demonstrate with an example.

[5]
12.
Describe the concept of Object Oriented and Procedure Oriented Programming in brief.
[2]
13.

Write down any five qualities of good software.

[5]
14.

Explain mobile computing with its advantages and disadvantages.

[5]
15.
Why do most business organizations prefer setting their network with the client-server architecture? Write its advantages and disadvantages.
[2]
16.

Develop a program in C using structure to ask the information of any 12 students with roll_number, name and marks scored in sub1, sub2, and sub3. Also, display them in proper format along with the calculation of total and percentage.

Note: The full marks of each subject is 100.
Or

Demonstrate a program in C to create a data file named score.dat to store students’ information with Reg_no, name, gender, and address. The program should ask the user to continue or not. When finished, the program should also display all the records in the proper format.

[8]