CBSE Academic Informatics Practices Class XII Sample Question Paper 2018-19 : cbseacademic.nic.in

Name of the Board : CBSE Academic
Class : XII STD
Document Type : Sample Question Paper
Subject : Informatics Practices
Paper : Class XII Sample Question Paper 2018-19
Year : 2018-19
Website : http://cbseacademic.nic.in/SQP_CLASSXII_2018_19.html

CBSE Academic Informatics Practices Sample Question Paper

MM: 80
Time Allowed : 3 hours

Update : CBSE Academic Class XII Informatics Practices Sample Question Paper 2019-20 : www.pdfquestion.in/34715.html

General Instructions

** All questions are compulsory.
** There are in all 25 questions.
** Question nos.1-6 are for 1 mark, to be answered in one or two lines.
** Question nos.7-13 are of 2 marks, to be answered in 10-20 words.
** Question nos.14-15 are of 3 marks, to be answered in 20-30 words.
** Question nos.16-21 are of 4 marks, to be answered in 30-50words.
** Question nos.22-25 are of 5 marks, to be answered in 60-100 words.
** Support your answer with suitable examples and figures wherever required.

Informatics Download Question Paper :
SQP :
https://www.pdfquestion.in/uploads/pdf2019/33519-Infor.pdf
MS :
https://www.pdfquestion.in/uploads/pdf2019/33519-InforMS.pdf

Section-A

1. (a) Which of the following are open standards?
.OGG .DOC .BMP .ODF 1

(b) Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. Although she carries her laptop with her all the time but many a times she require to take some data from her office PC. She has to make several requesting phone calls to her colleague Ms. Barbara to send her required documents from her office PC. Suggest her any one popular software name so that she can herself remotely access her office PC anytime from anywhere.

(c) Write the URL of any one e-Governance website. 1

(d) International Tour and Travels company has set up its new branch office in Jaipur where different buildings are spanned over in the radius of 900 meter in Jaipur. Name the network formed in the following situations :
(i) The branch office is connected with the regional office in New Delhi.
(ii) All the buildings of branch office are connected to each other. 1

(e) Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. 2

(f) Many of the programming brains has shifted their focus from Proprietary software to Free and Open software. Mention any two freedom offered by Free software. Going with the flow, Sandhya has downloaded a software from the internet which can be freely distributed and used by anyone but the source code is not available. Is it Freeware or free software? Justify your answer as well. Similarly Premjith wants to install a software on his system that can help him to create, edit and save office documents but he does not want to purchase the software. Suggest him a good software for the same.

2. (a) Ruby, a class XI student has just started learning java programming. Help her in the following:
i. Explain her the concept of variable and data type by suitable example.
ii. Help her in understanding the difference between assignment operator and comparison operator with the help of appropriate example. 4

(b) Will the output from the following two code be any different?
First Code:
int x=2,y=40;
while(y<=x) {
jTextField1.setText(“”+x);
x=x+8;
}
Second Code :
int x=2,y=40;
do {
jTextField1.setText(“”+x);
x=x+8;
} while(y<=x);
Give reasons for your answer.
2
OR
(b) Predict the output of the following code:
int n=4,f=0,i;
for(i=1;i<=n;i++)
{
f=f*i;
}
jTextField1.setText(“”+f);
jTextField2.setText(“”+i);

(c) Dev, a website designer with “Creative Designers Pvt. Ltd.” has written the following code. Observe the code given below and answer the following questions:
<company>
<employee eid=1>
<name>Albert</name>
<dept deptid=“d1”>Computer</dept>
</employee>
<employee eid=2>
<name>Manisha</name>
<dept deptid=“d2”>Accounts</dept>
</employee>
</company>

i. Are these tags part of HTML code or XML code?
ii. Identify the root element.
iii. Mention any two child elements.
iv. Mention any two attributes

(c) Mention any two main differences between HTML and XML. Also mention any two main features of XML for which it’s used extensively now a days.

3. (a) What is the purpose of SQL? 1
(b) Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” for the upcoming training schedule:

Help him in writing SQL query for the following purpose:
i. To count how many female candidates will be attending the training.
ii. To display list of free trainings.
iii. To display all the cities where Cyber Security training is scheduled along with its fee.
iv. To add a column feedback with suitable data type.

(c) Observe the table named “Training” given above carefully and predict the output of the following queries:
i. select city from training where topic = ‘Cyber Security’;
ii. select count(Training_Id) from training where email_id like ‘%gmail% ‘;
iii. select AVG (Fee) from training where Topic = ‘Cyber Security’;
iv. select name from training where INSTR (Email_Id, ‘@’)=0; 4
(d) What is the degree and cardinality of the above given table named ‘Training’. 1

4. (a) Shiva has placed two radio button on a payment form designed in NetBeans to accept mode of payment one out of cash or card. To his surprise, during runtime, a customer is able to select both the options for a single transaction. What went wrong?
OR
(a) Mention any one advantage of jCheckBox control over jRadioButton control.
(b) Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available with all the four controls mentioned above. 1
OR
(b) How jLabel is different from jTextField control at run time? 1

(c) What will be an output of the following code if value of variable application is 1?
Switch (application)
{
case 0 : jTextField1.setText(“RDBMS”);
case 1 : jTextField1.setText(“BROWSER”);
case 2 : jTextField1.setText(“OS”); break;
case 3 : jTextField1.setText(“PHOTO EDITOR”); break;
default : jTextField1.setText(“Application Software”); break;
} 1
OR
(c) Re-write the above given code through if-else statements.
(d) Anju, a beginner in java programming has written following code with some mistakes:
int k=0;
string s=”Save Earth”;
int l=s.length;
for(int i=0;k<l;i++)
{
jTextArea1.append(s+\n);
k++;
};
Help her in identifying and correcting the errors.
Convert the correct code into do while looping statement.
4
OR
(d) Observe the given code:
int ctr=10;
while(ctr>5)
{
ctr=ctr-2;
}

Section – B

Attempt the following questions based on the above given code:
i. How many times the above given loop will run and what will be the value of ctr, immediately after exiting from the loop.
ii. Out of entry controlled or exit controlled loop, above given loop will come under which category and why?
(e) Study the following code and answer the questions that follow:
String str=”Green World, Clean World”;
int len=str.length(),remain;
remain=100-len;
jTextField2.setText(str.toUpperCase());
jTextField3.setText(Integer.toString(remain)+” more charachters can be entered”);

i. Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code.
ii. Identify and name any two method of String class used in the above code. 2
OR
(e) Explain the purpose of pow() method with the help of suitable java code. Also mention that pow() method belongs to which class?
OR
(f) Write java statement to make the Net Fee text field named txtNetFee un-editable at run time. 5.
(a) Write any one similarity and one difference between primary key and unique Constraint 2
(b) Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. Also mention suitable command for it 2

(c) Consider the following tables Library given below: 4
i. Suggest the suitable data type for Issue_Date column.
ii. Suggest the suitable SQL command to change the size of column name from 30 character to 50 characters.
iii. Mention the significance of Bid column in table Library.
iv. Suggest the suitable command to display a list of the books in a sequence so that first all the book’s name should be displayed which has not been returned and after that all the book’s name which has been returned should be displayed.

(d) Rishi, a class XII student has given following commands for the given purposes: i. To add a new column “Rating” : update table library add column rating varchar(20); ii. To give an increase of 50 Rs. to all the books: alter library set price=price+50; Check if above given SQL commands will be able to achieve desired task or not. Justify your answer. Suggest the correction (s) if required.

6. (a) Write SQL query to create a table “BOOKS” with the following structure 2
OR
(a) Help Ramesh in identifying any two columns for a table named student along with their suitable data type