CBSE Question Paper 2016 class 12 Informatics Practices

myCBSEguide App

myCBSEguide App

Complete Guide for CBSE Students

NCERT Solutions, NCERT Exemplars, Revison Notes, Free Videos, CBSE Papers, MCQ Tests & more.

Download Now

 

CBSE Question Paper 2016 class 12 Informatics Practices conducted by Central Board of Secondary Education, New Delhi in the month of March 2016. CBSE previous year question papers with solution are available in myCBSEguide mobile app and cbse guide website. The Best CBSE App for students and teachers is myCBSEguide which provides complete study material and practice papers to CBSE schools in India and abroad.

CBSE Question Paper 2016 class 12 Informatics Practices

Download as PDF

CBSE Question Paper 2016 class 12 Informatics Practices

General Instructions:
• Marking scheme is the final document for all references with regard to evaluation and cannot be altered under any circumstance.
• The answers given in the marking scheme are SUGGESTIVE, Examiners are expected to award marks for all alternative correct Solutions/Answers conveying the similar meaning.
• All programming questions have to be answered with respect to Java Language only.
• In Java, ignore case sensitivity for identifiers (Variables / Functions / Structures / Class Names).
• In SQL related questions:

A. Both ways of text/character entries should be acceptable. For example “AMAR” and ‘amar’ both are acceptable.
B. All date entries should be acceptable for example: ‘YYYY-MM-DD’, ‘YY-MM-DD’, ‘DD-Mon-YY’, “DD/MM/YY”, ‘DD/MM/YY’, “MM/DD/YY”, ‘MM/DD/YY’ and {MM/DD/YY} are correct.
C. Semicolon should be ignored for terminating the SQL statements.
D. Ignore case sensitivity for commands.
E. Ignore headers in output questions.


1. (a). Two doctors have connected their mobile phones to transfer a picture file of a person suffering from a skin disease. What type of network is formed?
Which communication media out of Coaxial cable, Optical fiber, Bluetooth, Satellite link should be used to transfer the file? (2)

(b). State reason why Star topology requires more cable length than Bus topology. (2)

(c). “Open Source Software developers work for the good of community”. Is this statement true? Give reason. (2)

(d). What happens during ‘Domain Name Resolution’? (2)

(e). How is ‘Denial of service’ attack, a threat to Network security?

2. (a). Identify the odd one out of the following statements. State reason for your choice. (1)
i) switch
ii) So while
iii) while
iv) for

(b). What is the difference between setVisible() and setEnabled() methods? (1)

(c). What is the difference between the following statements i) and (ii) (1)
i) w = 5;
ii) if (a = = 5) x = 3;

(d) Write the output in jtextField1 if dep code is 3. (1)
switch(decode)
{
case 1:
allowance = 4000;
break;
case 2:
allowance = 3200;
break;
default:
allowance = 1000;
}
jTextField1.setText(” “+allowance);
(e). Sandhya is creating a webpage. She is entering HTML code on her computer. In between, she keeps pressing ‘Refresh’/ ‘Reload’ button on her browser. What is the purpose? (2)

(f). What does ‘XML’ stand for? How is the purpose of HTML different from XML? (2)

(g). Write Java code (statements) to declare Y as integer variable. Then, assign the value 30 to a variable Y. Increase the value of Y by 5 and store the increased value in Z. (2)

3.(a). What is MySQL? (1)
(b). Charvi is inserting “Sharma” in the “LastName” column of the “Emp” table but an error is being displayed. Write the correct SQL statement. (1)
INSERT INTO Emp(‘Sharma’) VALUES (Lastname);
(c). Kunal created the (1)
following table with the name ‘Friends’:

friend codeName Hobbies
F101BijoySwimming
F102AbhinavReading Books
F103JyotsnaDancing

Now, Kunal wants to delete the ‘Hobbies’ column. Write the MySQL statement.

(d). Mrs. Sen entered the following SQL statement to display all Salespersons of the cities “Chennai” and ‘Mumbai’ from the table ‘Sales’. (1)
Table: Sales

codeNameCity
101AakritiMumbai
102AmanPunjab
103BanitDelhi
104FauziaMumbai

SELECT * FROM Sales
WHERE City=’Chennai’
AND City=’Mumbai’;
Rewrite the correct statement if wrong or write statement is correct.

(e). i) Name 2 Aggregate (Group) functions of SQL. (2)
SUM(), MAX(), MIN(), AVG () ,COUNT(), COUNT(*)
(Any Two)
(1/2 mark each for any 2 Group functions)
Note: Function names without parentheses also to be accepted as correct answers.

ii) Consider the table:
Table: Company

SIDSALES
S10120000
S103NULL
S10410000
S10515000

What output will be displayed by the following SQL statement?
SELECT AVG(SALES) FROM Company ;
Ans.
15000
(1 mark for correct answer)

(f). Given below is the ‘Stu’ table: (2)

The following Statements are entered:
SET AUTOCOMMIT = 0;
INSERT INTO Stu VALUES(5,’Rahul’);
COMMIT;
UPDATE Stu set name=’Rahuliya’ where Rno= 5;
SAVEPOINT A;
INSERT INTO Stu VALUES(6,’Cristina’);
SAVEPOINT B;
INSERT into Stu values(7,’Fauzia’);
SAVEPOINT C;
ROLLBACK TO B;
Now what will be the output of the following statement:
SELECT * FROM Stu;
(g). Consider the table ‘Hotel’ given below. (2)
Table: Hotel

EMPIDCategorySalary
E101MANAGER60000
E102EXECUTIVE65000
E103CLERK40000
E104MANAGER62000
E105EXECUTIVE50000
E106CLERK35000

Mr. Vinay wanted to display average salary of each Category. He entered the following SQL statement. Identify error(s) and Rewrite the correct SQL statement.
SELECT Category, Salary
FROM Hotel
GROUP BY Category;
Ans.
SELECT Category, AVG(Salary)
FROM Hotel
GROUP BY Category;
(2 marks for correct answer)

OR
(1 mark for only identifying error)

4. (a). When is if-else if statement preferred over switch statement? (1)
(b). What is the purpose of break statement? (1)
(c). What will be displayed in jTextField1 and jTextField2 after the following code is executed: int t; int s ;
s = 2;
t = (4*s++)/2;
jTextField1.setText(” “+t);
jTextField2.setText(” “+s);

(d). Write the contents of jTextField1, jTextField2, jTextField3 and jTextField4 when the following statements are executed: (2)
String x;
String str = “Java”;
x = str.concat(“study”);
double a = 7.8765;
jTextField1.setText(x.length()+” “);
jTextField2.setText(x.toUpperCase());
jTextField3.setText(x.substring(2,5) ) ;
jTextField4.setText(Math.round(7.8765)+” “);
(e). Rewrite the following code using WHILE loop: (2)
int sum = 0;
for(int i=9;i>=1;i–)
{
if(i%3==0)
sum = sum + i;
else
sum = sum – i;
}
(f). The following code has error(s). Rewrite the correct code underlining all the corrections made: (2)
int x = 10;
int y = 50;
do;
{
x+5 = x;
y-5 = y;
while ( x <= y );
(g). Vijay has developed a software for planning personal budget. A screenshot of the same is shown below:
CBSE Question Paper 2016 class 12 Informatics Practices
Total Income, Expenses of Bills (Water/Electricity), Groceries, Entertainment, other expenses and whether money is to be sent to Hostel are entered by the user.

Sum of Expenses, Grand Total of Expenses and Savings are calculated and displayed by the

program. Write the code to do the following :

i. When ‘CALCULATE’ button is clicked, Sum of Expenses, Total Expenses and Savings

should be calculated and displayed in appropriate text fields. (3)
• Sum of Expenses is calculated by adding expenses on Bills(Water/Electricity), Groceries,

Entertainment and other expenses.
• Grand Total of Expenses is calculated according to the following criteria:

If ‘Money to be sent to Hostel’ checkbox is selected, 3000.00 is to be added to the sum of expenses. If it is not selected,

Grand Total of Expenses is the same as sum of expenses.
• Savings = Total Income – Grand Total of Expenses.

(ii). When ‘CLEAR’ button is clicked, all text fields and checkbox should be cleared. (1)
(iii). When ‘CLOSE’ button is clicked, the application should close. (1)
5. (a). Anita has created the following table with the name ‘Order’. Table: Order (2)

Column NameConstraint
OrderIdPrimary Key
OrderDateNotNull
OrderAmount
StoreId

One of the rows inserted is as follows:

OrderIdOrderDateOrderAmountStoreId
O1012015-02-1234000S104

(i.) What is the data type of columns OrderId and OrderDate in the table Order?
(ii). Anita is now trying to insert the following row:

OrderIdOrderDateOrderAmountStoreID
O102NULL59000S105

Will she be able to successfully insert it? Give reason.

(b). Write the output of the following SQL queries: (2)
(i). SELECT MID(board examination’, 2, 4);

(ii). SELECT ROUND (67.246, 2);

(iii). SELECT INSTR(INFORMATION FORM’, ‘FOR’);

(iv). SELECT DAYOFYEAR(‘2015-01-10’) ;

(c). Write commands in SQL for (i) to (iv) and output for (v) and (vi). (6)
Table: Store

StoreIdNameLocationCityNo Of EmployeesDate OpenedSales Amount
S101Planet FashionKarolBaghDelhi72015-10-16300000
S102TrendsNehru

Nagar

Mumbai112015-08-09400000
S103VogueVikas ViharDelhi102015-06-27200000
S104Super fashionDefence ColonyDelhi82015-02-18450000
S105Rage

 

BandraMumbai52015-09-22600000

(i). To display name, location, city, SalesAmount of stores in descending order of SalesAmount.

(ii). To display names of stores along with SalesAmount of those stores that have ‘fashion’ anywhere in their store names.

(iii). To display Stores names, Location and Date Opened of stores that were opened before 1st March 2015.

(iv). To display total SalesAmount of each city along with city name.
Table: Course

CourseIdSubjectTeacherIdFee
C101Introductory MathematicsT1014500
C103PhysicsT1015000
C104Introductory Computer ScienceT1024000
C105Advance Computer ScienceT1046500

(v). Which column is used to relate the two tables?

(vi). Is it possible to have a primary key and a foreign key both in one table? Justify your answer with the help of table given above.

(c). With reference to the above-given tables, write commands in SQL for (i) and (ii) and output for (iii): (6)
(i). To display CourseId, TeacherId, Name of Teacher, Phone Number of Teachers living in Delhi.

(ii). To display TeacherID, Names of Teachers, Subjects of all teachers with names of Teachers starting with ‘S’.

(iii). SELECT CourseId, Subject, TeacherId, Name, PhoneNiunber FROM Faculty, Course WHERE Faculty.TeacherId = Course.TeacherId AND Fee >= 5000;

7. (a). “In e-Business, customers should shop only when they trust the e-store provider for payment methods”- Justify the statement (1)

(b). Which of the following statements is NOT true in e-Governance? Rewrite the statement after correcting it. (2)
(i) Online applications and tracking of status of applications should be provided.
(ii) Citizens should not be required to submit documents in physical form.
(iii) Online Forms should be made tricky so that only well-educated users can enter data.
(iv) Government should interact with citizens and enlighten them about different schemes through social media and web-based platforms.

(c). Ms. Arora is creating a form for accepting Visa applications. Help her to choose most appropriate controls out of ListBox, ComboBox, TextField, TextArea, RadioButton, CheckBox, Label and Command Button for the following entries. (2)

S.No.Function
1To enter EMAIL ID
2To choose GENDER
3To enter NATIONALITY from countries given as options.
4To enter REMARKS in the form of a paragraph about the purpose of visit.

These are questions only. To view and download complete question paper with solution install myCBSEguide App from google play store or log in to our student dashboard.

Download myCBSEguide App

CBSE Question Paper 2016 class 12 Informatics Practices

Download class 12 Informatics Practices question paper with solution from best CBSE App the myCBSEguide. CBSE class 12 Informatics Practices question paper 2016 in PDF format with solution will help you to understand the latest question paper pattern and marking scheme of the CBSE board examination. You will get to know the difficulty level of the question paper.

Previous Year Question Paper for class 12 in PDF

CBSE question papers 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005 and so on for all the subjects are available under this download link. Practicing real question paper certainly helps students to get confidence and improve performance in weak areas.

To download CBSE Question Paper class 12 Accountancy, Chemistry, Physics, History, Political Science, Economics, Geography, Computer Science, Home Science, Accountancy, Business Studies, and Home Science; do check myCBSEguide app or website. myCBSEguide provides sample papers with solution, test papers for chapter-wise practice, NCERT solutions, NCERT Exemplar solutions, quick revision notes for ready reference, CBSE guess papers and CBSE important question papers. Sample Paper all are made available through the best app for CBSE students and myCBSEguide website.


Test Generator

Test Generator

Create Papers with your Name & Logo

Try it Now (Free)


Leave a Comment