CBSE Class 12 Informatics Practices Sure Shot Questions Worksheet Set A

Read and download the CBSE Class 12 Informatics Practices Sure Shot Questions Worksheet Set A in PDF format. We have provided exhaustive and printable Class 12 Informatics Practices worksheets for Sure Shot Questions, designed by expert teachers. These resources align with the 2025-26 syllabus and examination patterns issued by NCERT, CBSE, and KVS, helping students master all important chapter topics.

Chapter-wise Worksheet for Class 12 Informatics Practices Sure Shot Questions

Students of Class 12 should use this Informatics Practices practice paper to check their understanding of Sure Shot Questions as it includes essential problems and detailed solutions. Regular self-testing with these will help you achieve higher marks in your school tests and final examinations.

Class 12 Informatics Practices Sure Shot Questions Worksheet with Answers

Topic: Networking and Open Source Software

Question. Which transmission medium should be used to transfer data across two continents at very high speed?
Answer :
Satellite

Question. Two Engineers in the same room have connected their mobile using Bluetooth for working on a group presentation. Out of the following, what kind of networks they have formed? LAN,MAN,PAN,WAN.
Answer :
PAN

Question. Arrange the following communication channels in descending order of their data transmission rates.
ETHERNET CABLE, OPTICAL FIBER, TELEPHONE CABLE, COAXIAL CABLE.
Answer :
Telephone Cable, Ethernet Cable, Coaxial Cable, Optical Fiber

Question. Which of the following software’s are open source:
LINUX,MS WINDOWS 7,PHOTOSHOP,MYSQL
Answer :
Linux, MySQL

Question. Explain the difference between domain name and URL with the help of appropriate example of each.
Answer :
Pls see the example : http://www.cbse.nic.in/welcome.htm
Domain Name: It is the name of any website. Ex cbse.nic.in
URL: Uniform Resource Locator – It is complete address of any website which contain protocol, domain name and webpage name.

Question. What do you mean by network topology? Name most popular topologies
Answer :
Network topology is defined as the interconnection of the various elements (links, nodes, etc.) of a computer network.
The study of network topology recognizes five basic topologies:
Bus topology , Star topology, Ring topology, Tree topology, Mesh topology

Question. Puneet is using software, which has been downloaded from internet and is available for one month.
After one month he has to pay license fee for further use. What software Puneet is using?
Answer :
Shareware
Ans: II

Question. Which protocol is used for transfer of hyper text documents on the internet?
Answer :
HTTP – Hyper Text Transfer Protocol

Question. What type of address is the following ? Also define it. 20 : B9 : Fl : 63 : 2F : FB
Answer :
It is MAC Address (Media Access Control). It is given to hardware part to enable networking

Question. What is IP address?
Answer :
(Internet Protocol Number):
Sometimes called a dotted quad. A unique number consisting of 4 parts separated by dots, e.g.
165.113.245.2. Every machine that is on the Internet has a unique IP number - if a machine does not have an
IP number, it is not really on the Internet.
Identify these address : i) 192.168.1.25 ii) 20 : B9 : Fl : 63 : 2F : FB
It is IP address
It is MAC address.

TOPIC : HTML

Question. Give two difference between HTML and XML.
Answer :
The two differences between HTML and XML are:
1. HTML is designed to display data and hence, focused on the ‘look’ of the data, whereas XML is designed to describe and carry data and hence, focuses on
2.HTML tags are not case sensitive, whereas XML tags are case sensitive

Question. Which tag is used to specify :
a. Table data
b. Table header
c. Table row
d. Table border
Answer : (a) <td> (b) <th> (c) <tr> (d) <tb>

Question. What is an unordered list?
Answer :
Bulleted/unordered list <UL> tag is used to indicate a list item as contained in an unordered or bulleted form.

Question. What is ordered list?
Answer :
The numbered/ordered list <OL> tag is used to indicate a list item as contained in an ordered or numbered form.

Question. What do you understand by ALINK? Give an example.
Answer :
Links which are currently being visited in web page are known as Active Links (ALINK). Example:
<BODY TEXT = “#FFFFFF” ALINK=”#FF0000”>
<A HREF=”www.kvsangathan.nic.in”> Kendriya Vidyalaya Sangathan </A><BR> <A HREF = www.cbse.nic.in&gt;
Central Board of Secondary Education </A> </BODY>

IT APPLICATIONS

Question. define following terms.
E-Governance
E-Business
E-Learning

Answer : E-Governance : It refers to the application of electronic means in governance with a name of full filling the requirements of daily needs of user at affordable cost and in fastest possible time.
E-Business: It refers to any form of transactions that uses an electronic media to facilitate the transaction.
E-Learning: It refers to the means of teaching through technology such as Network browser, DVD, CD ROM etc.

Question. Give examples of any two websites of E-Governance, E-Business and E-Learning.
Answer :
E-Governance: www.india.gov.in, www.indianrail.gov.in
E-Business: www.homeshop18.com, www.amazon.in
E-Learning: www.kvselearning.in, www.w3schools.com www.ncert.nic.in

Question. What controls would you suggest for following types of inputs?
Typed text(Single Line)
Typed Text(Multiple Lines)
A Mouse click
One out of many choices
Multiple choices from a set
Multiple items from a group of names
Typed text which should remain hidden

Answer : Text Field
Text Area
Button / Radio Button / Check Box
Radio Button
Check Box
List Box
Password field

Topic :-NetBeans (JAVA)

Question. Name any two swing containers.
Answer :
jFrame, jPanel

Question. Which property would you set the setting the password character as ‘$’?
Answer :
setEchochar(‘$’)

Question. Which method you would use to insert ‘Hello’ at 10th position in the Text Area control.
Answer :
void insert(“Hello”,10)

Question. Which method returns the password entered in a password field?
Answer :
getPassword()

Question. Which list property do you set for specifying the items for the list.
Answer :
Model

Question. Which method would you use to determine the index of selected item in a list?
Answer :
getSelctedIndex()

Question. How one can make a Text Field un-editable on a Frame?
Answer :
<jTextField>.setEditable(false)

Question. How one can make a Label invisible on a frame?
Answer :
<jLabel>.setVisible(false)

Question. While working in NetBeans, Mr. Gupta wants to display “Pass” or “Needs to Reappear” message depending the marks entered in jTextfield. Help him to choose more appropriate statement out of “If” and “switch” statement.
Answer :
If statement

Question. Which Methods is use to display message on screen using JOptionpane ?
Answer :
showMessageDialog Box ();

Question. Write any two differences between while and do-while loop?
Answer :
Entry control – Exit Control

Question. Runs if condition is true – runs at least once
Answer :
10

Question. Write the code for clear and exit button for the given application.
Answer :
Code for Clear Button
JtextField1.setText(null);
JtextField2.setText(null);
JtextField3.setText(null);
JtextField4.setText(null);
JtextField5.setText(null);
Code for Close Button
System.exit(0);

Question. Name the command to open a Database
Answer :
USE

Question. What command is used to see all the existing Tables in the database
Answer :
Show Tables

Question. Name the command use to see all ‘Databases’ in the system.
Answer :
Show Databases

Question. Name the command use to create a table
Answer :
Create Table

Question. Name the command to show the structure of an existing table
Answer :
DESC <Table Name>

Question. Name the various keys you know.
Answer :
Primary Key, Candidate key, Alternate key, Foreign Key

Question. Write two characteristics of a Primary key?
Answer :
It cannot be NULL
It is unique

Question. What is the difference between Candidate Key and Alternate key
Answer :
Candidate Key: An attribute or group of attributes that can act as a Primary Key is Called Candidate Key.
Alternate Key : All Candidate key other than the Primary key are called Alternate Key.

Question. What is a Foreign Key?
Answer :
Foreign Key is a Non-Key attributes, which obtains its values for the primary key of a parent table.

Question. Name the Command use to add a new record in an existing table
Answer :
Insert into

Question. Name commands for changing Table Data and changing Table Structure
Answer :
Changing Table Data: Update
Changing Table Structure: Alter Table

Question. What is the difference between the following pair of Commands:
Delete from stu;
Drop table stu

Answer : Delete from emp will remove all records from table emp but will keep the empty table, but , Drop table
emp will not only remove all the records but also the table.

Question. Define the terms Degree and Cardinality
Answer :
Degree : Total number of columns in a table
Cardinality : Total number of Rows in a table

Question. What is a Join?
Answer :
The horizontal joining of two or more tables base on a common column between the joining table is called
Join

Question. Name few type of Joins
Answer :
Inner Join , Outer Join, Left Join , Right Join

Question. What is a Cartesian Product?
Answer :
The Cartesian product, also referred to as a cross-join, returns all the rows in all the tables listed in the
query. Each row in the first table is paired with all the rows in the second table.

Question. What is the difference between NULL and ZERO?
Answer :
NULL is nothing not even zero or blank, it does not occupy any space on the disk but zero is a numeric
value, it occupies space on memory.

Question. While using SQL pattern Matching, what is the difference between ‘_’ and ‘%’
Answer :
‘_’ represents any string of zero or more characters.
‘%’ represents Any string of zero or more characters.

Question. Name various Transaction control Commands?
Answer :
SAVEPOINT: creates points within groups of transactions in which to rollback
COMMIT: to save the changes.
ROLLBACK: to rollback the changes.

CBSE Informatics Practices Class 12 Sure Shot Questions Worksheet

Students can use the practice questions and answers provided above for Sure Shot Questions to prepare for their upcoming school tests. This resource is designed by expert teachers as per the latest 2026 syllabus released by CBSE for Class 12. We suggest that Class 12 students solve these questions daily for a strong foundation in Informatics Practices.

Sure Shot Questions Solutions & NCERT Alignment

Our expert teachers have referred to the latest NCERT book for Class 12 Informatics Practices to create these exercises. After solving the questions you should compare your answers with our detailed solutions as they have been designed by expert teachers. You will understand the correct way to write answers for the CBSE exams. You can also see above MCQ questions for Informatics Practices to cover every important topic in the chapter.

Class 12 Exam Preparation Strategy

Regular practice of this Class 12 Informatics Practices study material helps you to be familiar with the most regularly asked exam topics. If you find any topic in Sure Shot Questions difficult then you can refer to our NCERT solutions for Class 12 Informatics Practices. All revision sheets and printable assignments on studiestoday.com are free and updated to help students get better scores in their school examinations.

Where can I download the 2025-26 CBSE printable worksheets for Class 12 Informatics Practices Chapter Sure Shot Questions?

You can download the latest chapter-wise printable worksheets for Class 12 Informatics Practices Chapter Sure Shot Questions for free from StudiesToday.com. These have been made as per the latest CBSE curriculum for this academic year.

Are these Chapter Sure Shot Questions Informatics Practices worksheets based on the new competency-based education (CBE) model?

Yes, Class 12 Informatics Practices worksheets for Chapter Sure Shot Questions focus on activity-based learning and also competency-style questions. This helps students to apply theoretical knowledge to practical scenarios.

Do the Class 12 Informatics Practices Chapter Sure Shot Questions worksheets have answers?

Yes, we have provided solved worksheets for Class 12 Informatics Practices Chapter Sure Shot Questions to help students verify their answers instantly.

Can I print these Chapter Sure Shot Questions Informatics Practices test sheets?

Yes, our Class 12 Informatics Practices test sheets are mobile-friendly PDFs and can be printed by teachers for classroom.

What is the benefit of solving chapter-wise worksheets for Informatics Practices Class 12 Chapter Sure Shot Questions?

For Chapter Sure Shot Questions, regular practice with our worksheets will improve question-handling speed and help students understand all technical terms and diagrams.