CBSE Class 12 Informatics Practices Sure Shot Questions Worksheet Set A

Read and download free pdf of CBSE Class 12 Informatics Practices Sure Shot Questions Worksheet Set A. Students and teachers of Class 12 Informatics Practices can get free printable Worksheets for Class 12 Informatics Practices Sure Shot Questions in PDF format prepared as per the latest syllabus and examination pattern in your schools. Class 12 students should practice questions and answers given here for Informatics Practices in Class 12 which will help them to improve your knowledge of all important chapters and its topics. Students should also download free pdf of Class 12 Informatics Practices Worksheets prepared by school teachers as per the latest NCERT, CBSE, KVS books and syllabus issued this academic year and solve important problems with solutions on daily basis to get more score in school exams and tests

Worksheet for Class 12 Informatics Practices Sure Shot Questions

Class 12 Informatics Practices students should refer to the following printable worksheet in Pdf for Sure Shot Questions in Class 12. This test paper with questions and answers for Class 12 will be very useful for exams and help you to score good marks

Class 12 Informatics Practices Worksheet for Sure Shot Questions

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.

More Worksheets for Class 12 Informatics Practices
CBSE Class 12 Informatics Practices Commonly Used Libraries Worksheet
CBSE Class 12 Informatics Practices Computer Networking Worksheet
CBSE Class 12 Informatics Practices Computer Xml Extensible Markup Language Worksheet
CBSE Class 12 Informatics Practices Concept Of Inheritance Worksheet
CBSE Class 12 Informatics Practices Database Connectivity To MySQL Worksheet
CBSE Class 12 Informatics Practices Database Fundamentals MySQL Revision Tour Worksheet
CBSE Class 12 Informatics Practices Database Transactions Worksheet
CBSE Class 12 Informatics Practices File Handling Worksheet
CBSE Class 12 Informatics Practices Html Basic Html Elements Worksheet
CBSE Class 12 Informatics Practices Html Lists Tables And Forms Worksheet
CBSE Class 12 Informatics Practices Introducing Classes And Objects Worksheet
CBSE Class 12 Informatics Practices It Applications Worksheet
CBSE Class 12 Informatics Practices Java Application Worksheet
CBSE Class 12 Informatics Practices Java Gui Programming Revision Worksheet
CBSE Class 12 Informatics Practices Java Gui Programming Worksheet
CBSE Class 12 Informatics Practices More On Sql Grouping Records And Table Joins Worksheet
CBSE Class 12 Informatics Practices MySQL Worksheet
CBSE Class 12 Informatics Practices Networking Worksheet
CBSE Class 12 Informatics Practices Open Source Concepts Worksheet
CBSE Class 12 Informatics Practices Sure Shot Questions Worksheet
CBSE Class 12 Informatics Practices Sure Shot Questions Worksheet Set A
CBSE Class 12 Informatics Practices Table And Integrity Constraints Worksheet
CBSE Class 12 Informatics Practices Web Application Development Worksheet

More Study Material

CBSE Class 12 Informatics Practices Sure Shot Questions Worksheet

We hope students liked the above worksheet for Sure Shot Questions designed as per the latest syllabus for Class 12 Informatics Practices released by CBSE. Students of Class 12 should download in Pdf format and practice the questions and solutions given in the above worksheet for Class 12 Informatics Practices on a daily basis. All the latest worksheets with answers have been developed for Informatics Practices by referring to the most important and regularly asked topics that the students should learn and practice to get better scores in their class tests and examinations. Studiestoday is the best portal for Class 12 students to get all the latest study material free of cost.

Worksheet for Informatics Practices CBSE Class 12 Sure Shot Questions

Expert teachers of studiestoday have referred to the NCERT book for Class 12 Informatics Practices to develop the Informatics Practices Class 12 worksheet. If you download the practice worksheet for one chapter daily, you will get higher and better marks in Class 12 exams this year as you will have stronger concepts. Daily questions practice of Informatics Practices worksheet and its study material will help students to have a stronger understanding of all concepts and also make them experts on all scoring topics. You can easily download and save all revision worksheet for Class 12 Informatics Practices also from www.studiestoday.com without paying anything in Pdf format. After solving the questions given in the worksheet which have been developed as per the latest course books also refer to the NCERT solutions for Class 12 Informatics Practices designed by our teachers

Sure Shot Questions worksheet Informatics Practices CBSE Class 12

All worksheets given above for Class 12 Informatics Practices have been made as per the latest syllabus and books issued for the current academic year. The students of Class 12 can be rest assured that the answers have been also provided by our teachers for all worksheet of Informatics Practices so that you are able to solve the questions and then compare your answers with the solutions provided by us. We have also provided a lot of MCQ questions for Class 12 Informatics Practices in the worksheet so that you can solve questions relating to all topics given in each chapter. All study material for Class 12 Informatics Practices students have been given on studiestoday.

Sure Shot Questions CBSE Class 12 Informatics Practices Worksheet

Regular worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Sure Shot Questions concepts. Worksheets play an important role in developing an understanding of Sure Shot Questions in CBSE Class 12. Students can download and save or print all the worksheets, printable assignments, and practice sheets of the above chapter in Class 12 Informatics Practices in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 12 Informatics Practices MCQ Test for the same chapter.

Worksheet for CBSE Informatics Practices Class 12 Sure Shot Questions

CBSE Class 12 Informatics Practices best textbooks have been used for writing the problems given in the above worksheet. If you have tests coming up then you should revise all concepts relating to Sure Shot Questions and then take out a print of the above worksheet and attempt all problems. We have also provided a lot of other Worksheets for Class 12 Informatics Practices which you can use to further make yourself better in Informatics Practices

Where can I download latest CBSE Printable worksheets for Class 12 Informatics Practices Sure Shot Questions

You can download the CBSE Printable worksheets for Class 12 Informatics Practices Sure Shot Questions for latest session from StudiesToday.com

Can I download the Printable worksheets of Sure Shot Questions Class 12 Informatics Practices in Pdf

Yes, you can click on the links above and download Printable worksheets in PDFs for Sure Shot Questions Class 12 for Informatics Practices

Are the Class 12 Informatics Practices Sure Shot Questions Printable worksheets available for the latest session

Yes, the Printable worksheets issued for Class 12 Informatics Practices Sure Shot Questions have been made available here for latest academic session

How can I download the Class 12 Informatics Practices Sure Shot Questions Printable worksheets

You can easily access the links above and download the Class 12 Printable worksheets Informatics Practices Sure Shot Questions for each chapter

Is there any charge for the Printable worksheets for Class 12 Informatics Practices Sure Shot Questions

There is no charge for the Printable worksheets for Class 12 CBSE Informatics Practices Sure Shot Questions you can download everything free

How can I improve my scores by solving questions given in Printable worksheets in Class 12 Informatics Practices Sure Shot Questions

Regular revision of practice worksheets given on studiestoday for Class 12 subject Informatics Practices Sure Shot Questions can help you to score better marks in exams

Are there any websites that offer free test sheets for Class 12 Informatics Practices Sure Shot Questions

Yes, studiestoday.com provides all latest NCERT Sure Shot Questions Class 12 Informatics Practices test sheets with answers based on the latest books for the current academic session

Can test papers for Class 12 Informatics Practices Sure Shot Questions be accessed on mobile devices

Yes, studiestoday provides worksheets in Pdf for Sure Shot Questions Class 12 Informatics Practices in mobile-friendly format and can be accessed on smartphones and tablets.

Are worksheets for Sure Shot Questions Class 12 Informatics Practices available in multiple languages

Yes, worksheets for Sure Shot Questions Class 12 Informatics Practices are available in multiple languages, including English, Hindi