CBSE Sample Papers for Class 12 Informatics Practices Paper 4

CBSE Sample Papers for Class 12 Informatics Practices Paper 4 are part of CBSE Sample Papers for Class 12 Informatics Practices. Here we have given CBSE Sample Papers for Class 12 Informatics Practices Paper 4.

CBSE Sample Papers for Class 12 Informatics Practices Paper 4

Board	CBSE
Class	XII
Subject	Informatics Practices
Sample Paper Set	Paper 4
Category	CBSE Sample Papers

Students who are going to appear for CBSE Class 12 Examinations are advised to practice the CBSE sample papers given here which is designed as per the latest Syllabus and marking scheme, as prescribed by the CBSE, is given here. Paper 4 of Solved CBSE Sample Paper for Class 12 Informatics Practices is given below with free PDF download solutions.

Time : 3 hrs
Maximum Marks : 70

General Instructions

• All questions are compulsory.
• Answer the’questions after carefully reading the text.

QUESTIONS

Question 1.
(a) Which of the following softwares are Open Source Software?
Linux, MS-Windows 7, Photoshop, MySQL

(b) Which form of Web page is used by a server to respond to a client?

(c) Choose the most appropriate wireless communication channel in each of the following situations:

1. Communication in a hilly area.
2. Very fast communication between two offices in two different countries.

(d) Give one function of a gateway.

(e) What does the following protocols do?

1. DNS
2. FTP .

(f) Expand the terms OSI, FLOSS. Explain in brief as well.

(g) Define the term hub. Also, explain in brief active hubs and passive hubs.

Question 2.
(a) Are values “true” and true the same? Likewise are “false” and false the same?
(b) Following code contains error. Write correct code.

float a = 15.50 ;
byte b = a ;

(c) Write the output of following Java code. What will be print in jTextAreal?

for (int I = 5 ; I > = 2 ; I - -)
j TextAreal.setText (j TextAreal.getText ( ) +" "+ Integer.toString(1*1) ) ;

(d) Rewrite the following code using while loop :

int a, b ;
for (a = 10, b = 4 ; a <= 16 ; a+ + , b +=2)
{
j TextAreal.append(” ''+ a - -) ;
}
J OptionPane.showMessageDialog (null, "Finished") ;

(e) (i) Write HTML tag to do the following :
I. To create heading in table of Web page
II. To create ordered list in Web page.

(ii) How many times the do-while loop executed and also write its output?

int a,i ;
i=0 ; a=1 ;
do
{
i++ ; a++ ;
)
while (a<=5) ;
System.out.println ("i=",+i) ;
System, out. println ( "a=" ,+a) ;

Question 3.
(a) Which function is used to get current date and time in MySQL?
(b) Consider the table ‘BRAND’ :

To select tuples with some Brand_Name, Rupak has written the following erroneous SQL statement :

SELECT Item_Code, Brand_Name FROM BRAND
WHERE Brand_Name = something ;

Write the correct SQL statement.

(c) (i) While creating the table ‘VENUE’ last week, Renuka forgot to include the column Guest_Name. Now, write a command to insert the Guest_Name column with VARCHAR datatype and 20 size into the ‘VENUE’ table.
(ii) Neelu is inserting “Pink” in the “Color” column of the ‘DESIGN’ table but an error is being displayed. Write the correct SQL statement.

INSERT INTO DESIGN ( 'Pink' ) VALUES ('Color') ;

(d) An attribute NAME of datatype VARCHAR(10) has the value ‘Ram’. The attribute LNAME of datatype CHAR(15) has the value ‘Sharma’. How many characters are occupied in attribute NAME? How many characters are occupied in attribute LNAME?

(e) Give the output of the following queries :

(i) SELECT LENGTH ('environment') ;
(ii) SELECT TRIM (' Hindustan ') ;
(iii) SELECT MID ('envi ronment' , 4, 3) ;
(iv) SELECT CONCAT ( 'I', ' am', 'best') ;

Question 4.
(a) Give the output of the following :

j TextFieldl.setText (Math.round(2.6)+ " ”) ;

(b) (i) Write the contents of jTextFieldl, jTextField2, jTextField3 and jTextField4 when the following statements are executed.

String x ;
String str = "INFORMATION” ;
x=str.concat ("PRACTICE") ;
double a=6. 8534 ;
jTextField1.setText (x. length ( )+" ") ;
jTextField2.setText (x. toupperCase( ) ) ;
jTextField3.setText (x.substring(2,5) ) ;
jTextField4.setText (Math.round(a)+" ") ;

(ii) Find and write the output of the following Java code snippet :

String Fname="Kareena",Lname="Kapoor",Str=" ",name ;
int len ;
name=Fname+'"'+Lname ;
JOptionPane.showMessageDialog(null.name) ;
1en=name.length ( ) ;
int i=0 ;
while (i<1)
{
Str=Str+name.substring(4) ;
i=i+15 ;
}
JOptionPane.showMessageDialog (null,Str) ;
System.out.println (len) ;

(c) (i) DTD is a set of rules that defines which type of tags appear in an HTML document. Explain it. (2)
(ii) The following code has some error(s). Rewrite the given code after removing all error(s).

public class star
{
Int i=5 ;
public Void show (int j)
{
System.out.println ("j="+j)
System.out.println ("i="+i) ;
}
public void show(int k)
{
System.out.println("i="i) ;
{
}

(d) Rani has developed a screen used to find area of rectangle as given below :

(i) Write code for “Calculate” button to calculate the area of rectangle.
(ii) Write code to clear all TextFields on pressing of “Reset” button.
(iii) Write code for “Exit” button.

Question 5.
(a) Change the datatype of column Citycode to VARCHAR(IO) in the table CONSUMER.
(b) Pooja, a student of class XI, created a table BOOK. Price is a column of this table. To find the details of books whose prices have not been entered, she wrote the following query :

SELECT * FROM BOOK WHERE Price = NULL ;

Help Pooja to run the query by removing the error(s) from the query and rewriting it.

(c) (i) Consider the following table :

With reference to the C_TABLE, what will be the content of the table after the execution of 12th statement?

1. START TRANSACTION :

2. INSERT INTO C_TABLE VALUES(4,'A',100) ;

3. DELETE FROM C_TABLE WHERE S_No = 1 ;

4. ROLLBACK work ;

5. BEGIN ;

6. UPDATE C_TABLE SET Code = 'C WHERE S_No = 2 ;

7. ROLLBACK work ;

8. INSERT INTO C„TABLE VALUES(5,'A 1,200) ;

9. DELETE FROM C_TABLE WHERE S_No = 2 ;

10. ROLLBACK work ;

11. UPDATE C_TABLE SET Value = 400 WHERE S_No = 2 ;

12. COMMIT work ;

(ii) Conside the table ‘CINEMA given below.

What will be the output of the following queries on the basis of the above table?

I. SELECT COUNT(Name) FROM CINEMA ;
II. SELECT COUNT(Id) FROM CINEMA WHERE Profit <=100 ;

(d) Table “CLIENT’ is shown below. Write commands in SQL for (i) and (ii) and output for (iii) and (iv).

(i) To display client name and salary in descending order of salary.
(ii) To list name of female client.

(iii) SELECT CNAME, AGE, SALARY FROM CLIENT
WHERE SALARY BETWEEN 30000 AND 50000 ;
(iv) SELECT CID, AGE, CNAME FROM CLIENT WHERE CNAME LIKE ’Pa%' ;

Question 6.
(a) (i) Aarti is the fashion designer of Iconic-fashion company. She wants to create a table ‘COLLECTION’ to store details of her dresses. She have following attributes to store Dress_Code, Name,Price, Color. Write a query to create this table.
(ii) Consider the tables given below ;

The Book_Id column in the “BOOKS” table is the …………….. key. The Book_Id column in the “ISSUED” table is a …………… key.

(b) With reference to the above given tables (in Q6 (a)(ii)) write commands in SQL for (i) and (ii) and output for (iii) below :
(i) To show Book_Name, Author_Name, Price and Quantity_Issued of books of , “First Publ” pubhshers and Book_Id is present in ISSUED table.
(ii) To list the names from books of text type whose Book_Id is present in ISSUED table.

(iii) SELECT Book_Name, Author_Name FROM BOOKS WHERE Publishers = "EPB”;

Question 7.
(a) One goal of E-Govemance is citizen participation. Explain it.
(b) Define the term of DDLC. List the phases of DDLC.
(c) Sanjna is creating a form for practical file, help her to choose most appropriate controls from ListBox, ComboBox, TextField, TextArea, RadioButton, CheckBox, Label and CommandButton for the following entries from the user :

Answers

Answer 1.
(a) Linux and MySQL are the Open Source Software.
(b) After processing the request, server automatically generates an HTML page. This HTML page is sent to the client as a result. Which may contain text, images etc.
(c) (i) Microwave
(ii) Satellite
(d) The gateway is a node in a network, which serves as a proxy server and a firewall system, that prevents the unauthorised access.
(e) (i) DNS(Domain Name System) is the way that Internet domain names are located and translated into Internet protocol addresses.
(ii) FTP(File Transfer Protocol) is used widely on Internet for transferring files to and from a remote host.
(f) OSI(Open Source Initiative) is an organisation, which is related to promote open source software.
FLOSS(Free Libre/Livre Open Source Software), means the software which can get free of cost, get copied, modified, redistributed with the availability of the source code.
(g) A hub is a hardware device used to connect several computers together.
(i) Active hubs electrically amplify the signal as it moves from one connected device to another. Active concentrators are used like repeaters to extend the length of a network.
(ii) Passive hubs allow the signal to pass from one computer to another without any change.

Answer 2.
(a) No “true” and “false” are string literals whereas true and false are Boolean literals.

(b) float a = 15.50 ;
byte b = (byte) a ;

(c) 25 16 9 4 will be display in jTextAreal after the execution of the given code.

(d) int a=10, b=4 ;
while(a<=16)
{
jTextAreal.append(” "+a- -) ;
a++ ;
b+=2 ;
}
JOptionPane.showMessageDialog(null,"Finished") ;

(e) (i) I. <TH>.. .</TH>
II. <OL>...</OL>

(ii) do-while loop executed 5 times.
Output
i=5
a=6

Answer 3.
(a) NOW ( ) function is used to get current date and time in MySQL.
(b) Correct SQL statements is :

SELECT Item_Code, Brand_Name FROM BRAND
WHERE Brand_Name IS NOT NULL ;

(c) (i) ALTER TABLE VENUE ADD Guest_Name VARCHAR(20) ;
(ii) INSERT INTO DESIGN(' Col or')VALUES(’Pink') ;

(d) NAME column occupied 3 characters.
LNAME column occupied 6 characters.

Answer 4.
(a) 3 is the output of the given code.
(b) (i) jTextFieldl will contain 19
jTextField2 will contain INFORMATIONPRACTICE
jTextField3 will contain FOR
jTextField4 will contain 7

(ii) Output
Kareena Kapoor
ena Kapoor
14

(c) (i) Document Type Declaration (DTD) are used in XML to specify information about a document, whose purpose is to acknowledge the existence and location of a document type definition. All document type declaration starts with <!DOCTYPE. The DTD declaration can be internal or external.

(d)
(i) Java code for CommandButton “Calculate” is as follows :

double 1, b, area =0 ;
1 = Double.parseDouble (jTextFieldl.getText( ) ) ;
b = Double.parseDouble (jTextField2.getText( ) ) ;
area = l*b ;
jTextField3.setText(area+ " ") ;

(ii) Java code for CommandButton “Reset” is as follows :

jTextFieldl.setText (" ") ;
jTextField2.setText(" ") ;
jTextField3.setText(" ") ;

(iii) Java code for CommandButton “Exit” is as follows :

System.exit(0) ;

Answer 5.

(a) ALTER TABLE CONSUMER MODIFY Citycode VARCHAR(10) ;

(b) The correct query is :

SELECT * FROM BOOK WHERE Price IS NULL ;

(c) (i) Content of table after statement 12 will be as follows :

(d) (i) SELECT CNAME, SALARY FROM CLIENT ORDER BY SALARY DESC ;
(ii) SELECT CNAME FROM CLIENT WHERE GENDER = 'F’ ;

Answer 6.

(a) (i) CREATE TABLE COLLECTION
(Dress_Code INT(10) PRIMARY KEY,
Name VARCHAR(IO) NOT NULL,
Price INT(5),
Color VARCHAR(10)
);

(ii) Primary, Foreign

(b) (i) SELECT Book_Name, Author_Name, Price, Quantity_Issued
FROM BOOKS, ISSUED
WHERE Publishers = "First Publ" AND BOOKS.BooK_Id - ISSUED.BooK_Id ;

(ii) SELECT Book_Name FROM BOOKS, ISSUED
WHERE Type = "Text" AND BOOKS.Book_Id = ISSUED.Book_Id ;

Answer 7.
(a) Through the Internet, people from different place can interact with politicians or public servants. People give their views suggestions to the politicians. So, use of E-Governance is increasing participation of citizen.
(b) Database Development Life Cycle (DDLC) is a structural process, which is imposed upon the development of the database portion of an application. On every step, database is evolved and refined. The systematic approach used for developing a database is referred to as DDLC.

The phases of the DDLC are as follows :

1. Database initial study
2. Database design
3. Coding and implementation
4. Testing and evaluation
5. Operation
6. Maintenance

We hope the CBSE Sample Papers for Class 12 Informatics Practices Paper 4 help you. If you have any query regarding CBSE Sample Papers for Class 12 Informatics Practices Paper 4, drop a comment below and we will get back to you at the earliest.