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 teachers as per the latest Informatics Practices 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>
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 Class 12 Informatics Practices Data Handling using Pandas Worksheet |
| CBSE Class 12 Informatics Practices Societal Impacts Worksheet |
Worksheet for CBSE Informatics Practices Class 12 Sure Shot Questions
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. Expert teachers of studiestoday have referred to the NCERT book for Class 12 Informatics Practices to develop the Informatics Practices Class 12 worksheet. 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. 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.
You can download the CBSE Printable worksheets for Class 12 Informatics Practices Sure Shot Questions for latest session from StudiesToday.com
There is no charge for the Printable worksheets for Class 12 CBSE Informatics Practices Sure Shot Questions you can download everything free
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
CBSE Class 12 Informatics Practices Sure Shot Questions worksheets cover all topics as per the latest syllabus for current academic year.
Regular practice with Class 12 Informatics Practices worksheets can help you understand all concepts better, you can identify weak areas, and improve your speed and accuracy.