Sub. code 4281
NEB — GRADE XII
Model Question
Class 12 Computer Science Model Question
The candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.
Pass Marks : 20
सबै प्रश्नको उत्तर दिनुहोस् । (Attempt All Questions)
This model question paper is for Class 12 Computer Science, (subject code 4281), carrying full marks of 50 with a pass mark of 20, to be completed within 2 Hours. Model answers are available for questions that have one — reveal them with a free account (a few reveals) or a paid plan (unlimited).
Group A
Rewrite the correct answer of each question in your answer sheet.
In which normal form of database, atomicity is introduced?
First
Second
Third
Fourth
Which of the following techniques is not implemented to protect a database?
Rollback
Backup
Recovery
Firewall
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?
SELECT * FROM CUSTOMER WHERE LNAME LIKE "?A%";
SELECT * FROM CUSTOMER WHERE LNAME LIKE "_A%";
SELECT * FROM CUSTOMER WHERE LNAME LIKE "A%";
SELECT * FROM CUSTOMER WHERE LNAME LIKE "%A";
Which of the following is an incorrect IP address?
192.168.0.1
192.168.1
172.255.0.0
202.10.79.4
Which of the following is a server-side scripting language?
JavaScript
MySQL
PHP
jQuery
Which of the following keywords are used to declare a variable in JavaScript?
int or var
float or let
var or let
char or var
Which of the following commands is executed in PHP to concatenate the variables y ?
$x + $y
y
concat(y)
y
Which statement is incorrect about the object-oriented approach?
Emphasis is on data rather than procedure.
Data is hidden and cannot be accessed.
Objects communicate through functions.
It supports abstract data but not the class.
Which of the following feasibility study is concerned with cost benefit analysis?
Technical feasibility
Economic feasibility
Operational feasibility
Schedule feasibility
Group B
Which type of database system (centralized or distributed) is mostly preferred by financial institutions like a bank? Give any four suitable reasons
Nowadays most business organizations prefer applying relational model for database design in comparison to other models. Justify the statement with your arguments.
Develop a program in JavaScript to exchange/swap the values of any two variables.
How can you connect a database with PHP? Demonstrate with an example.
Describe the concept of Object Oriented and Procedure Oriented Programming in brief.
Write down any five qualities of good software.
Explain mobile computing with its advantages and disadvantages.
Group C
Give the long answers to the following questions.
Why do most business organizations prefer setting their network with the client-server architecture? Write its advantages and disadvantages.
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.]
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.
Paper Overview & Analysis
Year
Model Question
Type
50
Full Marks
20
Pass Marks
2 Hours
Duration
16
Question Items
Question Type Breakdown
Group Breakdown
Chapter Breakdown
| DBMS Concept | 4 items | 8 marks |
| Web Technology - II (CSS, JavaScript, PHP) | 4 items | 8 marks |
| Concept of Network and Data Communication | 2 items | 9 marks |
| OOP Concept | 2 items | 6 marks |
| Software Process Model | 2 items | 6 marks |
| Recent Trends in ICT | 1 item | 5 marks |
| Programming II | 1 item | 8 marks |