Information Technology Class 11

Teachers and Examiners (CBSESkillEduction) collaborated to create the Java NetBeans Programs for Class 11 QA. All the important Information are taken from the NCERT Textbook Information Technology (802) class 11.

Java NetBeans Programs for Class 11

1. What is the purpose of NetBeans IDE?
Answer – Java applications can be simply created utilizing the effective GUI builder in the NetBeans IDE. We can create application by dragging and dropping GUI elements from a palette onto a container. Correct spacing and alignment of the various components in relation to one another are handled automatically by the GUI builder.

3. What is the difference between Parent control and Child control in NetBeans?
Answer – There are two different type of control –
a. Parent or container controls – Controls that serve as a parent or container serve as the backdrop for other controls. Consider Frame. All of a parent control’s child controls are also destroyed when we remove it. All of a parent control’s child controls move with it when the parent control is moved.

b. Child controls – Child controls are controls that are positioned inside a container control. For instance, a text field, a label, a button, etc.

Java NetBeans Programs for Class 11

4. Write any two property of jFrame Form?
Answer – The two property of jFrame Form are –
a. defaultCloseOperation – Sets action to be performed when the user attempts to close the form.
b. Title – Sets the text to be displayed in the Title bar of the form window.

5. What id purpose of property in NetBeans?
Answer – An object’s properties are used to determine how it will display on the form. For instance, you can alter a textfield’s background color, font, and other properties by changing its background attribute.

6. What is Methods?
Answer – To do some action on the object, methods are employed. For instance, you may use a textfield’s setText() method to show something in it or use its getText() method to retrieve its contents. Getters and setters are the two categories into which methods can be separated.

Java NetBeans Programs for Class 11

7. What is Event?
Answer – Events are the actions which are performed on controls. Examples of events are mouseClick, mouseMoved,keyPressed etc. When the user performs any action on a control, an event happens and that event invokes the corresponding part of the code and the application behaves accordingly.

8. Write any two method of jButton?
Answer –
a. getText() – Retrieves the text typed in jButton.
String result=<button-name>.getText( );
b. setText() – Changes the display text at runtime.
<button-name>.setText(String text);

9. What is Object Oriented Programming Language?
Answer – Object-oriented programming is known as OOP. While object-oriented programming involves constructing objects that include both data and functions, procedural programming involves developing procedures or functions that perform actions on the data.

Java NetBeans Programs for Class 11

10. What are the major components of Object Oriented Programming?
Answer – The major components of Object Oriented Programming are –
1. Class
2. Object
3. Data Members & Methods
4. Access Specifier and Visibility Modes

11. What is data member and method?
Answer – Methods and data members are accessible in classes. In actual Java programming, the methods are a series of steps put together to carry out a certain action on the data, whilst the data will need to adhere to a specified data type, such as char, int, float, or double.

12. What is Variables?
Answer – Variables act as a kind of container for the data they hold. Because they can change their value but not their name, these things are called variables.

Java NetBeans Programs for Class 11

13. What are the different characteristics of variable?
Answer – The characteristics of a variable are:
• It has a name.
• It is capable of storing values.
• It provides temporary storage.
• It is capable of changing its value during program execution.

14. What is Data types? What are the different type of Data Type.
Answer – The data type describes the actions that may be performed on the type, the range for the type, and how the type’s values are stored. Some of the example of data types are –

a. Numeric Data Type – These data types are used to store integer values only i.e. whole numbers only.
Example Byte, Short, Int, Long

b. Floating Data Types – These data types are used to store numbers having decimal points i.e. they can store numbers having fractional values. for example float & double.

c. Character Data Types – These data types are used to store characters. Character data types can store any type of values – numbers, characters and special characters.

Java NetBeans Programs for Class 11

15. What is Operator? What are the different type of operators.
Answer – Operators are symbols that manipulate, combine or compare variables. The operators available in java are –
a. Assignment Operator – One of the most common operators is the assignment operator “=” which is used to assign a value to a variable. We assign the value given on the right hand side to the variable specified on
the left hand side.

b. Arithmetic Operator – These operators perform addition, subtraction, multiplication, and division. These symbols are similar to mathematical symbols. example +, -, *, /, %

c. Relational Operator – A relational operator is used to test for some kind of relation between two entities. A mathematical expression created using a relational operator forms a relational expression or a condition. example ==, !=, >, <, >=, <=

16. What is Bitwise Operator?
Answer – Bitwise operators can be used to change a number’s individual bits. They are compatible with all integral kinds (char, short, int, etc). They are utilised while updating and searching a binary indexed tree.

Java NetBeans Programs for Class 11

17. Design a GUI application to accept the side of a square in a text field and calculate the area and perimeter of the square. Add Refresh button to clear all text fields and a Stop button to end the application.
Hint [ Area of a square = side * side and perimeter = 2(side +side)]
Answer – //Coding for jButton1 (“Calculate the area” button)
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
double a,b;
a=Double.parseDouble(jTextField1.getText());
b=a*a; jTextField2.setText(Double.toString(b));
}

//Coding for jButton2 (“Calculate the perimeter” button)
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt)
{
doublea,c;
a=Double.parseDouble(jTextField1.getText());
c=4*a;
jTextField3.setText(Double.toString(c));
}

//Coding for jButton4 (“Refresh” button)
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt)
{
jTextField1.setText(” “);jTextField2.setText(” “);jTextField3.setText(” “);
}

Employability Skills Class 11 Notes

• Unit 1 : Communication Skills Class 11 Notes
• Unit 2 : Self-Management Skills Class 11 Notes
• Unit 3 : Information and Communication Technology Skills Class 11 Notes
• Unit 4 : Entrepreneurial Skills Class 11 Notes
• Unit 5 : Green Skills Class 11 Notes

Employability Skills Class 11 MCQ

• Unit 1 : Communication Skills Class 11 MCQ
• Unit 2 : Self-Management Skills Class 11 MCQ
• Unit 3 : Information and Communication Technology Skills Class 11 MCQ
• Unit 4 : Entrepreneurial Skills Class 11 MCQ
• Unit 5 : Green Skills Class 11 MCQ

Employability Skills Class 11 Questions and Answers

• Unit 1 : Communication Skills Class 11 Questions and Answers
• Unit 2 : Self-Management Skills – III
• Unit 3 : Information and Communication Technology Skills Class 11 Questions and Answers
• Unit 4 : Entrepreneurial Skills Class 11 Questions and Answers
• Unit 5 : Green Skills Class 11 Questions and Answers

Information Technology Class 11 Notes

• Unit -1 : Computer Organization Class 11 Notes
• Unit -2 : Networking And Internet Class 11 Notes
• Unit-3 : Office Automation Tools Class 11 Notes
• Unit-4: RDBMS Class 11 Notes
• Unit-5: Fundamentals of Java Class 11 Notes

Information Technology Class 11 MCQ

• Unit -1 : Computer Organization Class 11 MCQ
• Unit -2 : Networking And Internet Class 11 MCQ
• Unit-3 : Office Automation Tools Class 11 MCQ
• Unit-4: RDBMS Class 11 MCQ
• Unit-5: Fundamentals of Java Class 11 MCQ

Information Technology Class 11 Questions and Answers

• Unit -1 : Computer Organization Class 11 Questions and Answers
• Unit -2 : Networking And Internet Class 11 Questions and Answers
• Unit-3 : Office Automation Tools Class 11 Questions and Answers
• Unit-4: RDBMS Class 11 Questions and AnswersS
• Unit-5: Fundamentals of Java Class 11 Questions and Answers

Teachers and Examiners (CBSESkillEduction) collaborated to create the Fundamentals of Java Class 11 MCQ. All the important Information are taken from the NCERT Textbook Information Technology (802) class 11.

Fundamentals of Java Class 11 MCQ

1. NetBeans is an IDE using which we can develop ___________ in Java.
a. GUI application 
b. CUI application
c. BW application
d. None of the above

2. NetBeans provides various components used to create a GUI front-end interface like ___________.
a. jTextArea
b. jLabel
c. jButton
d. All of the above 

3. GUI components’ __________ is controlled by their properties and methods.
a. Appearance
b. Behavior
c. Both a) and b) 
d. None of the above

4. We should use meaningful names for controls on the _________ in the code. It makes programming convenient.
a. Form
b. Variables
c. Both a) and b) 
d. None of the above

5. Some useful Data Types supported in Java are ___________.
a. Int & Boolean
b. Double
c. Char
d. All of the above 

6. String is an _________ type supported in Java.
a. Object 
b. Constraint
c. Class
d. None of the above

7. A variable must be declared _____________.
a. After it can be used
b. Between it can be used
c. Before it can be used 
d. None of the above

8. What are the different operators used in Java _________.
a. Logical Operator
b. Conditional Operator
c. Comparison Operator
d. All of the above 

9. The __________ selects among a set of statements depending on the value of a controlling expression.
a. If Statement 
b. For Statement
c. While Statement
d. None of the above

10. If else statement is also known as ________.
a. Control statement 
b. Structure statement
c. Program statements
d. All of the above

11. An IF statement in Java is also a _______ statement.
a. Number
b. conditional 
c. String
d. None of the above

12. In Java, an ELSE statement needs to come after a _________ statement.
a. IF
b. ELSE IF
c. IF or ELSE IF 
d. None of the above

13. It is required to define an IF statement code between two braces.
a. False 
b. True
c. Some time True and Some time False
d. None of the above

14. An ELSE statement’s code may be enclosed in braces.
a. FALSE
b. TRUE 
c. Some time True and Some time False
d. None of the above

15. Without an IF statement, an ELSE or ELSE-IF statement in Java cannot occur.
a. FALSE
b. TRUE 
c. Some time True and Some time False
d. None of the above

16. if the condition is false in if condition, which of the following will be true.
a. IF Statement will be executed
b. ELSE Statement is executed. 
c. IF and ELSE both will not execute.
d. IF and ELSE both will execute.

17. How many lines of code can be written inside an IF, ELSE, or IF-ELSE block in Java?
a. 25
b. 72
c. 105
d. None of the above 

18. In which of the following situations is an IF-ELSE statement preferable to a SWITCH statement?
a. Checking multiple condition
b. Checking for Less-than condition
c. Checking for Ranges
d. All of the above 

19. How many ELSE-IF statements can be present between the beginning IF and the closing ELSE statements?
a. 44
b. 55
c. 320
d. None of the above 

20. Select the proper Java IF statement syntax from the list below.
a. if(condition) //statement
b. if(condition){ //statement}
c. if(condition){ //statement1 //statement2}
d. All of the above 

21. What does the Java programme with IF-ELSE statements produce?
if(TRUE)
System.out.println(“True”);
else
System.out.println(“False”);
a. True
b. False
c. Compiler error 
d. None

22. What is the output of the Java program?
int a=10;
if(a==9)
System.out.println(” My “);
System.out.println(“School”);
else
System.out.println(“My Class”);
a. My School
b. My Class
c. Compiler error 
d. None of the above

23. What is the output of the Java program?
String name1=”My School”, name2=”My Class”;
if(name1 == “My School”)
{
System.out.print(“My School “);
System.out.println(“My Class”);
}
if(name2 == “No Class”)
{
System.out.println(“My Class”);
}
a. My School My Class 
b. My School My Class My Class
c. Compiler error
d. None of the above

24. What is the output of the Java program?
String name=”Anurag”;
if(name == “Anand”)
{
System.out.print(“Anurag”);
}
System.out.println(“Computer Science”);
a. Anurag Computer Science
b. Anurag
c. Computer Science 
d. Compiler error

25. What is the output of the Java program with ELSE-IF statements?
int marks=90;
if(marks >= 80)
System.out.println(“Distinction”);
else if(marks >=33)
System.out.println(“Pass”);
else
System.out.println(“Fail”);
a. Distinction
b. Pass 
c. Fail
d. Compiler error

26. What is the output of Java program below?
float temp = 97.3;
if(temp > 97.3)
{
System.out.println(“High Temperature”);
}
else
{
System.out.println(“Temperature”);
}
a. High Temperature 
b. Temperature
c. Compiler error
d. None of the above

27. What is the output of the Java program?
int marks = 91;
if(marks > 32)
{
if(age <= 100)
{
System.out.println(“Pass”);
}
}
else
{
System.out.println(“Fail”);
}
a. Pass 
b. Fail
c. Compiler error
d. None of the above

28. What is the output of the Java program?
int marks=55;
if(marks > 55);
System.out.print(“Pass “);
System.out.println(“Fail”);
a. Fail
b. Pass
c. Pass Fail 
d. Compiler error

29. What is the result of the IF statement in a Java programme?
if(true)
{
break;
System.out.println(“School”);
}
a. No Output
b. School
c. Compiler error 
d. None of the above

30. Java is a ______ programming language.
a. Procedure Oriented
b. Object-Oriented 
c. Practical
d. All of the above

31. The code in the Java programming language is put inside ___________.
a. Blocks
b. Methods
c. Classes, Interfaces
d. All the above 

32. What file extension is associated with the Java class source code?
a. .jpp
b. .jsp
c. .java 
d. None of the above

33. What file extension is associated with compiled Java class files?
a. .jpp
b. .java
c. .class 
d. .clear

34. In Java, the keyword used to declare a class is _________.
a. Function
b. Method
c. class 
d. Java

35. A Java class can contain___________.
a. Variables
b. Methods, Constructors
c. Inner Classes (A class inside another class)
d. All of the above 

36. In Java, the word ________ is used to create a new object.
a. java
b. new 
c. class
d. function

37. In Java, an object is created at _________ time.
a. Assembling time
b. Run time 
c. Compile-time
d. None of the above

38. Select the appropriate Java class declaration syntax from the list below.
a. 
class CLASSNAME
{

}
b.
CLASSNAME class
{

}
c.
class CLASSNAME;
{

}
d.
Class CLASSNAME
{

}

39. Pick the appropriate method for producing an object of the class listed below.
class Table
{
Table(){System.out.println(“Table Created”);}
}
a. Table t = new Table;
b. Table t = new Table();
c. Table() t = new Table();
d. None of the above

40. A control statement in Java is called a _________ SWITCH case statement.
a. Iteration
b. Loop
c. Selection 
d. Jump

41. Which is the Java language equivalent of SWITCH?
a. break, continue
b. for, while
c. if, else 
d. goto, exit

42. What keywords are needed in Java to implement a SWITCH case?
a. switch, case
b. default
c. break
d. All of the above 

43. Select the proper SWITCH statement syntax for Java from the list below.
a.
switch(input)
{
case constant1: //statements; break;
case constant2: //statements; break;
default: //statements;
};
b. 
switch(input)
{
case constant1: //statements; break;
case constant2: //statements; break;
default: //statements;
}
c.
switch(input)
{
case constant1: //statements; break;
case constant2: //statements; break;
default case: //statements;
};
d.
switch(input)
{
case constant1: //statements; break;
case constant2: //statements; break;
default case: //statements;
}

44. What is the result of the following Java application with SWITCH?
int a=10;
switch(a)
{
case 10: System.out.println(“Welcome”);
}
a. No output
b. Welcome 
c. Compiler error as there is no BREAK.
d. None

45. What does the Java programme below produce?
String animal = “Horse”;
switch(animal)
{
break: System.out.println(“DOMESTIC”);
}
a. No output
b. Horse
c. DOMESTIC
d. Compiler error 

Employability Skills Class 11 Notes

• Unit 1 : Communication Skills Class 11 Notes
• Unit 2 : Self-Management Skills Class 11 Notes
• Unit 3 : Information and Communication Technology Skills Class 11 Notes
• Unit 4 : Entrepreneurial Skills Class 11 Notes
• Unit 5 : Green Skills Class 11 Notes

Employability Skills Class 11 MCQ

• Unit 1 : Communication Skills Class 11 MCQ
• Unit 2 : Self-Management Skills Class 11 MCQ
• Unit 3 : Information and Communication Technology Skills Class 11 MCQ
• Unit 4 : Entrepreneurial Skills Class 11 MCQ
• Unit 5 : Green Skills Class 11 MCQ

Employability Skills Class 11 Questions and Answers

• Unit 1 : Communication Skills Class 11 Questions and Answers
• Unit 2 : Self-Management Skills – III
• Unit 3 : Information and Communication Technology Skills Class 11 Questions and Answers
• Unit 4 : Entrepreneurial Skills Class 11 Questions and Answers
• Unit 5 : Green Skills Class 11 Questions and Answers

Information Technology Class 11 Notes

• Unit -1 : Computer Organization Class 11 Notes
• Unit -2 : Networking And Internet Class 11 Notes
• Unit-3 : Office Automation Tools Class 11 Notes
• Unit-4: RDBMS Class 11 Notes
• Unit-5: Fundamentals of Java Class 11 Notes

Information Technology Class 11 MCQ

• Unit -1 : Computer Organization Class 11 MCQ
• Unit -2 : Networking And Internet Class 11 MCQ
• Unit-3 : Office Automation Tools Class 11 MCQ
• Unit-4: RDBMS Class 11 MCQ
• Unit-5: Fundamentals of Java Class 11 MCQ

Information Technology Class 11 Questions and Answers

• Unit -1 : Computer Organization Class 11 Questions and Answers
• Unit -2 : Networking And Internet Class 11 Questions and Answers
• Unit-3 : Office Automation Tools Class 11 Questions and Answers
• Unit-4: RDBMS Class 11 Questions and AnswersS
• Unit-5: Fundamentals of Java Class 11 Questions and Answers

Teachers and Examiners (CBSESkillEduction) collaborated to create the RDBMS Class 11 Questions and Answers. All the important Information are taken from the NCERT Textbook Information Technology (802) class 11.

RDBMS Class 11 Questions and Answers

1. Write a short note on MySQL.
Answer – Based on structured query language, MySQL is a relational database management system (RDBMS) created by Oracle (SQL). A systematic collection of data is called a database. Anything from a straightforward shopping list to a photo gallery or a location to store the enormous volumes of information in a business network may be it.

2. Mention features of a DBMS.
Answer – Features of a DBMS –

• Minimum Redundancy and Duplication. …
• Usage Of Query Languages. …
• Multi User Access. …
• Reduced amount of space and money spent on storage. …
• Data Organization. …
• Customization of the Database. …
• Data Retrieval. …
• Data Integrity is Maintained.

RDBMS Class 11 Questions and Answers

3. What is the difference between DBMS and RDBMS?
Answer – Database Management System is referred to as DBMS, and Relational Database Management System is referred to as RDBMS. Unlike RDBMS, which stores data in the form of tables, DBMS stores data as a file.

4. List some features of MySQL.
Answer – Features of MySQL ae –
a. MySQL based on Client/Server Architecture
b. Free to use
c. Highly Flexibal
d. Compatible on many operating sytem
e. High performance
f. High productivity
g. Platform independent

5. How is Primary Key different from Candidate Key?
Answer – A record in a table is uniquely identified by its primary key, which must be both unique and non-null. There can only be one primary key per table. A candidate key can be used in conjunction with a primary key to uniquely identify records in a table.

RDBMS Class 11 Questions and Answers

6. Define the key(s) used in MySQL.
Answer – There are four different types of Keys –
a. Primary Key – The group of one or more columns used to uniquely identify each row of a relation is called its Primary Key.

b. Cndidate Key – A column or a group of columns which can be used as the primary key of a relation is called a Candidate key because it is one of the candidates available to be the primary key of the relation.

c. Alternate Key – A candidate key of a table which is not selected as the primary key is called its Alternate Key.

d. Foreign Key – A primary key of a base table when used in some other table is called as Foriegn Key.

7. State the similarity and difference between the Primary Key, Candidate Key, Alternate Key and Foreign Key
Answer –
a. Primary Key – The group of one or more columns used to uniquely identify each row of a relation is called its Primary Key.

b. Cndidate Key – A column or a group of columns which can be used as the primary key of a relation is called a Candidate key because it is one of the candidates available to be the primary key of the relation.

c. Alternate Key – A candidate key of a table which is not selected as the primary key is called its Alternate Key.

d. Foreign Key – A primary key of a base table when used in some other table is called as Foriegn Key.

RDBMS Class 11 Questions and Answers

8. Which statement is used to select a database and make it current?
Answer – To choose data from a database, use the SELECT statement. The information received is kept in a result table known as the result-set.

9. How is a database related to table(s)?
Answer – In databases, a table is a collection of data elements (values) organised using a model of vertical columns (named) and horizontal rows, with a cell serving as the intersection of a row and a column. A table can have any number of rows but only a certain number of columns.

10. Write SQL statement to view names of all the tables contained in the current database.
Answer – To display all the table in database –
SQL> SHOW TABLES;

11. In a database there is a table Cabinet. The data entry operator is not able to put NULL in a column of Cabinet? What may be the possible reason(s)?
Answer – The data entry operator cannot enter duplicate values in a column of a cabinet; this is likely because the column contains a primary key.

RDBMS Class 11 Questions and Answers

12. Do Primary Key column(s) of a table accept NULL values?
Answer – Primary Key column does not support NULL Values.

13. There is a table T1 with combination of columns C1, C2, and C3 as its primary key? Is it possible to enter:
a. NULL values in any of these columns?
b. Duplicate values in any of these columns?
Answer –
a. No
b. Not possible

18. What are the differences between DELETE and DROP commands of SQL?

Answer – The DELETE command in Data Manipulation Language (DML) is used to remove tuples or records from a relation or table. In contrast, the DDL command DROP is used to delete named schema elements such as relations, tables, constraints, or the whole schema.

RDBMS Class 11 Questions and Answers

19. How many types of language are there in the database?

DDL (Data definition language) – Data definition language is used to design and modify the structure of a database.
Common DDL commands are
a. Create – This command is used to create database
b. Alter – This command is used to modify the database.
c. Drop – This command is used to delete database tables.

DML (Data manipulation language) – Data manipulation language provides commands for manipulating data in databases.
Common DML commands are
a. Select – This command is used to display information from the database.
b. Insert – This command is used to insert new records in the database.
c. Delete – This command is used to delete records from the database.
d. Update – This command is used to modify records in the database.

20. Consider the following table “Teachers”

Write SQL commands:
a. To display all the information from the table whose address is ‘Mumbai’.

Answer – Select * from students where address = “Mumbai”;

b. To list the details of all the students whose percentage is between 90 to 100.

Answer – Select * from students where percentage >= 90 and percentage <= 100;

c. To display the name of all the students whose gender is Female.

Answer – Select Subject from students where Gender = ‘F’;

d. To display the list of names of all the students in alphabetical order.

Answer – Select * from students order by Student_name;

21. Write the SQL commands to answer the queries based on Fabric table

a. Write a query for insert the following record
(“F005”, “Kurta”, “Woollen”,5)

Answer – insert into Fabric values (‘F005’, ‘Kurta’, ‘Woolen’,5);

b. Write a query to display only those fabric whose disc is more than 10

Answer – select * from Fabric where Disc>10;

c. To display those record whose type is ‘Woolen’

Answer – select * from Fabric where type = ‘Woolen’;

d. To modify the fabric shirt by increasing discount by 10

Answer – update fabric set Disc = Disc + 10 where Fname = ‘Shirt’;

e. To delete the record of fabric F003 from table

Answer – delete from Fabric where FabricID =‘F003’;

22. Consider the following Vendor table and write the queries

a. Write a Query to display all records

Answer – Select * from Vendor;

b. Write a Query to add a new row with the following details
(„V005‟, „Vadilal‟, „2010-03-20‟, „Pune‟)

Answer – Insert into Vendor values (“V005‟, “Vadilal‟, “2010-03-20‟, “Pune‟);

c. Write a query to modify the location of V003 from Kolkata to Gujrat

Answer – Update Vendor Set location= “Gujrat‟ Where location= “Kolkata‟;

23. Consider the following table “ITEM”:

a. Display the total amount of each item. The amount must be calculated as the price multiplied by quantity for each item.

Answer – Select price * quantity from item;

b. Display the details of items whose price is less than 50.

Answer – Select * from item where price < 50;

Employability Skills Class 11 Notes

• Unit 1 : Communication Skills Class 11 Notes
• Unit 2 : Self-Management Skills Class 11 Notes
• Unit 3 : Information and Communication Technology Skills Class 11 Notes
• Unit 4 : Entrepreneurial Skills Class 11 Notes
• Unit 5 : Green Skills Class 11 Notes

Employability Skills Class 11 MCQ

• Unit 1 : Communication Skills Class 11 MCQ
• Unit 2 : Self-Management Skills Class 11 MCQ
• Unit 3 : Information and Communication Technology Skills Class 11 MCQ
• Unit 4 : Entrepreneurial Skills Class 11 MCQ
• Unit 5 : Green Skills Class 11 MCQ

Employability Skills Class 11 Questions and Answers

• Unit 1 : Communication Skills Class 11 Questions and Answers
• Unit 2 : Self-Management Skills – III
• Unit 3 : Information and Communication Technology Skills Class 11 Questions and Answers
• Unit 4 : Entrepreneurial Skills Class 11 Questions and Answers
• Unit 5 : Green Skills Class 11 Questions and Answers

Information Technology Class 11 Notes

• Unit -1 : Computer Organization Class 11 Notes
• Unit -2 : Networking And Internet Class 11 Notes
• Unit-3 : Office Automation Tools Class 11 Notes
• Unit-4: RDBMS Class 11 Notes
• Unit-5: Fundamentals of Java Class 11 Notes

Information Technology Class 11 MCQ

• Unit -1 : Computer Organization Class 11 MCQ
• Unit -2 : Networking And Internet Class 11 MCQ
• Unit-3 : Office Automation Tools Class 11 MCQ
• Unit-4: RDBMS Class 11 MCQ
• Unit-5: Fundamentals of Java Class 11 MCQ

Information Technology Class 11 Questions and Answers

• Unit -1 : Computer Organization Class 11 Questions and Answers
• Unit -2 : Networking And Internet Class 11 Questions and Answers
• Unit-3 : Office Automation Tools Class 11 Questions and Answers
• Unit-4: RDBMS Class 11 Questions and Answers
• Unit-5: Fundamentals of Java Class 11 Questions and Answers

Teachers and Examiners (CBSESkillEduction) collaborated to create the Office Automation Tools Class 11 Questions and Answers. All the important Information are taken from the NCERT Textbook Information Technology (802) class 11.

Office Automation Tools Class 11 Questions and Answers

1. What is the need of a word processing software?
Answer – Using a standard word processor, a user can generate documents, modify them using the keyboard and mouse, store them for later access, and print them to a printer. Microsoft Word, Microsoft Notepad, and Corel WordPerfect are all common word processing programs.

2. What is the task of a word processing software?
Answer – A word processor is a tool or computer application that allows for the entry, editing, formatting, and output of text.

3. Name an open source word processing software.
Answer – Apache OpenOffice Writer & Google doc

Office Automation Tools Class 11 Questions and Answers

4. List the steps to start an OpenOffice Writer.
Answer – Click Start >> All Programs >> OpenOffice >> OpenOffice Writer from the desktop if applicable. OpenOffice Writer users should select File > New > Text Document. A text document appears on your screen in either scenario. (The text document’s name can be seen at the top of the screen.

5. List the components of the main screen of OpenOffice Writer.
Answer – OpenOffice Writer’s home screen is divided into several sections, including the Work Area, Ruler bar, Status bar, and Scroll bar.

Office Automation Tools Class 11 Questions and Answers

6. Define the following:
a. Tabs
b. Ruler Bar
c. Status Bar
d. Scroll Bar
e. Work Area
Answer –
a. Tabs – Tabs like “File,” “Edit,” “View,” and “Insert” feature drop-down menus with actions that are specific to the tab.
b. Ruler Bar – There are two rulers—a horizontal and vertical ruler—on the ruler bar. We can change the margins and indentation using the Ruler Bar.

c. Status Bar – The status bar shows details about the open document that is currently open. The zoom slider, total number of pages in the document, and the current page number are all displayed.

d. Scroll Bar – Both a horizontal and vertical scroll bar are present. They aid in scrolling the document’s body or content.

e. Work area – This is the area where the document’s text is typed.

Office Automation Tools Class 11 Questions and Answers

7. List the tabs in the OpenOffice Writer. What are the key tasks performed by the tabs.
Answer – The Tab key in word processing and text editing inserts the ASCII tab character, advances the insertion point to the following tab stop in a table, or inserts numerous space characters (depending on the programme used).

8. What is the extension of the file created in OpenOffice Writer?
Answer – ODT is the extension for files produced by OOo Writer (OpenDocument text). ODT files and Writer Files are the terms used in this site to refer to files made in Writer.

9. What is the purpose of the following tabs?
a. File
b. Edit
c. View
d. Insert
Answer –
a. File – You can specify a file in the File tab where the log shall be saved. An indicator that shows if file logging is active and a button to enable or disable it are located at the top. (Take note that unless a file is chosen below, you cannot enable it.) You can stop and start the file entering process using the button.

b. Edit – Editing principles and objectives Editing is done to carry on or emphasise the significance of a scene or tale. It is often referred to as “creating diverse moods and atmospheres,” and this can be done by editing techniques including fading, three-way colour correction, and shot pacing.

c. View – By limiting access to a predetermined set of a table’s rows and columns, views offer an extra layer of security. A view has the ability to conceal the complexity of a multiple table join.

d. Insert – The user can add something (such a photograph) into a document or file by using the Insert file menu and Ribbon area in software. For instance, in Microsoft Word, the user can include a photo of themself into their paper using the Insert tab in the Ribbon.

Office Automation Tools Class 11 Questions and Answers

10. What is the difference between Save command and Save As command?
Answer – When we save a document, the most recent version can be modified to reflect the most recent working version and the newly created document. We can save our work for the first time using Save As, and it will also ask where and under what name it should be saved.

11. What is the difference between Move text and Copy text?
Answer – Moving and copying are different in that the first creates a duplicate of a file or directory at a new location without changing its original content, whereas the latter moves the original file or directory to a new location.

Office Automation Tools Class 11 Questions and Answers

12. How is Find and Replace option useful?
Answer – By using Find and Replace, you may easily find and replace any word or formatting style within a page. This is very useful for lengthy papers. Perform the keyboard shortcut Ctrl+H or go to Editing in the Home tab of the ribbon, then select Replace to use Find and Replace.

13. List the steps for inserting a hyperlink to a web page in a document.
Answer –
Step 1 : Select the text you want to use as link
Step 2 : Insert >> Links >> Link
Step 3 : Type or paste the destination URL
Step 4 : Click on OK to create a hyperlink

14. What is the difference between toggle case and sentence case when using Change Case?
Answer – Sentence case will capitalise the first word; lowercase will change all of the letters in the selection to lowercase; UPPERCASE will change all of the letters to uppercase; and tOGGLE cASE will change all of the letters in the selection to the opposite case.

Office Automation Tools Class 11 Questions and Answers

15. What is a spreadsheet? List its uses.
Answer – In a spreadsheet application, data is arranged into rows and columns and shown as a grid or table. Utilizing the numerical data, it is utilised to assess and produce projections. Typically, a spreadsheet programme is used for the following tasks –

• Enter data
• Edit data
• Format data
• Perform calculation on the data
• Present data in graphical form

16. Explain a workbook and worksheet.
Answer –
Workbook – You can use a file called a “Calculus Workbook” that contains numerous worksheets to arrange various types of related material. The three worksheets “sheet 1,” “sheet 2,” and “sheet 3” are included by default in a workbook.

Worksheet – A single spreadsheet with cells, rows, and columns can be found in a calc worksheet. A worksheet always starts in row 1 and column A. A formula, text, or number can be entered into each cell.

Office Automation Tools Class 11 Questions and Answers

17. What is the purpose of using a spreadsheet?
Answer – The purpose of using spreadsheet are –
1. Managing financial data such as bank account information, budgets, transactions, billing, and receipts.
2. Handling inventory, reviews, employee information, surveys, etc., using data entry forms.
3. Tracking student performance by calculating grades and other relevant information such as attendance, highest score, and lowest score.
4. Creating lists of items which may not be numeric such as student list, grocery list.
5. Managing company information such as profit and sales by creating graphs from the data.

Office Automation Tools Class 11 Questions and Answers

18. What do you mean by Active Cell?
Answer – You’ll notice a thick black border surrounding the cell you’ve chosen when you choose it. The selected cell is the active cell, as indicated by the thick black border.

19. What are the various types of data available in a spreadsheet?
Answer – There are various types of data that can be entered in a cell –
a. Labels – These are alphabetic or alphanumeric entries without numeric value. They can be a combination of letters, numbers, space, special characters etc. Labels are left justified by default.

b. Numbers or Values – These are numeric data which may be integers or can contain decimals or fractions. Values are right-justified by default.

c. Formulas – Used to perform calculations such as addition, subtraction, multiplication, division, average. Formulas must begin with an = sign.

Office Automation Tools Class 11 Questions and Answers

20. What is the purpose of AutoFill in Spreadsheet?
Answer – You can enter data automatically in Spreadsheet. Use the AutoFill command to automatically expand a predictable sequence (such as 1, 2, 3, days of the week, or hours of the day) that you are typing.

21. What is the need of a presentation software?
Answer – Users who want to deliver information to an audience can do so with the aid of presentation software. It includes templates and tools for adding text, photos, music, video, and graphs as well as other types of content. Using presentation software, teachers can make their lessons more engaging.

Office Automation Tools Class 11 Questions and Answers

22. What is the task of a presentation software?
Answer – It is possible to construct presentations of ideas by combining text, graphics, and audio or video using presentation software, a subcategory of application software. A tale is told, a speech is supported, or information is presented in a presentation.

23. Name an open source presentation software
Answer –
a. Apache OpenOffice’s Impress.
b. LibreOffice’s Impress.
c. FreeOffice 2018’s Presentation.
d. Google Slides.

Office Automation Tools Class 11 Questions and Answers

24. List the steps to start an OpenOffice Impress.
Answer –
Step 1 : Click on Start Button
Step 2 : Click on OpenOffice.org
Step 3 : Click on OpenOffice.org Impress

25. List the components of the main screen of OpenOffice Impress.
Answer – The Slides pane, Workspace, and Tasks panes make up the main Impress window. Several toolbars can also be shown or hidden while a presentation is being created.

Office Automation Tools Class 11 Questions and Answers

26. List the different view options in OpenOffice Impress.
Answer – Different ways in which presentation slides can be viewed are –
a. Normal View
b. Outline View
c. Slide Sorter
d. Slide Show
e. Notes Page
f. Handout Page

Office Automation Tools Class 11 Questions and Answers

27. List the tabs in the OpenOffice Impress. What are the key tasks performed by the tabs?
Answer – Insert tab are described as follows –
a. Insert page number, Date and Time – A Header and Footer Window opens. Make settings here for date, time and page number.

b. Insert Fields – A pop-up menu appears. Select the element to be inserted. The selected element will insert at the location of the cursor.

c. Insert Hyperlink – A dialog box opens. On the left side of the dialog box, select where you want to link – current presentation slides, new presentation or Internet link. Then fill the details path, Form (text, button), etc. The Text is the name that appears in your document as a hyperlink.

Office Automation Tools Class 11 Questions and Answers

28. What is the extension of the file created in OpenOffice Impress.
Answer – ODP is the file extension for files produced by OOo Impress (OpenDocument Presentation). ODP files and Impress Files are the terms used in this site to refer to files made in OOo Impress.

29. What is the purpose of the following views –
a. Normal
b. Outline
c. Slide Sorter
d. Slide Show
e. Notes Page
f. Handout Page
Answer –
a. Normal – This is the main editing view for writing and creating slides

b. Outline – This displays an outline of the text in the slides.

c. Slide Sorter – This presents all slides of the presentation in a miniature form. It helps in viewing all slides together and allows easy moving of slides.

d. Slide Show – It shows slides as they will be actually presented. No editing can take place in this view.

e. Notes Page – Allows users to make notes for the selected slide. The notes can be seen only by the presenter while making a presentation. The note page is not visible to the audience of the slide show presentation.

f. Handout Page – It displays slides on a page as seen when printed.

Office Automation Tools Class 11 Questions and Answers

30. What is the need to use the Slide Master?
Answer – Each slide in your presentation has a general appearance that is controlled by a slide master, including formatting and design. Every slide layout will be updated as you make changes to the slide master within your presentation. At least one slide master can be found in every template.

31. What is the difference between slide transition and slide animation?
Answer – The following are the differences between slide transition and custom animation –
1. Slide Transition – The looks that move you from one slide to the next are known as slide transitions.
2. Slide Animation – Slide animations are the motions you add to text, images, and other items on a single presentation.

Office Automation Tools Class 11 Questions and Answers

Employability Skills Class 11 Notes

• Unit 1 : Communication Skills Class 11 Notes
• Unit 2 : Self-Management Skills Class 11 Notes
• Unit 3 : Information and Communication Technology Skills Class 11 Notes
• Unit 4 : Entrepreneurial Skills Class 11 Notes
• Unit 5 : Green Skills Class 11 Notes

Employability Skills Class 11 MCQ

• Unit 1 : Communication Skills Class 11 MCQ
• Unit 2 : Self-Management Skills Class 11 MCQ
• Unit 3 : Information and Communication Technology Skills Class 11 MCQ
• Unit 4 : Entrepreneurial Skills Class 11 MCQ
• Unit 5 : Green Skills Class 11 MCQ

Employability Skills Class 11 Questions and Answers

• Unit 1 : Communication Skills Class 11 Questions and Answers
• Unit 2 : Self-Management Skills – III
• Unit 3 : Information and Communication Technology Skills Class 11 Questions and Answers
• Unit 4 : Entrepreneurial Skills Class 11 Questions and Answers
• Unit 5 : Green Skills Class 11 Questions and Answers

Information Technology Class 11 Notes

• Unit -1 : Computer Organization Class 11 Notes
• Unit -2 : Networking And Internet Class 11 Notes
• Unit-3 : Office Automation Tools Class 11 Notes
• Unit-4: RDBMS Class 11 Notes
• Unit-5: Fundamentals of Java Class 11 Notes

Information Technology Class 11 MCQ

• Unit -1 : Computer Organization Class 11 MCQ
• Unit -2 : Networking And Internet Class 11 MCQ
• Unit-3 : Office Automation Tools Class 11 MCQ
• Unit-4: RDBMS Class 11 MCQ
• Unit-5: Fundamentals of Java Class 11 MCQ

Information Technology Class 11 Questions and Answers

• Unit -1 : Computer Organization Class 11 Questions and Answers
• Unit -2 : Networking And Internet Class 11 Questions and Answers
• Unit-3 : Office Automation Tools Class 11 Questions and Answers
• Unit-4: RDBMS Class 11 Questions and Answers
• Unit-5: Fundamentals of Java Class 11 Questions and Answers

Teachers and Examiners (CBSESkillEduction) collaborated to create the RDBMS Class 11 MCQ. All the important Information are taken from the NCERT Textbook Information Technology (802) class 11.

RDBMS Class 11 MCQ

1. A _________ is an organized collection of data.
a. Database
b. Digital Document
c. Spreadsheet
d. None of the above

2. A ________ is a software package that can be used for creating and managing databases.
a. Database Management System
b. Basedata Management System
c. Database Manage System
d. None of the above

3. In an RDBMS data is stored in _________.
a. Table
b. Form
c. Query
d. Report

4. A_________________ database management system is referred to as a relational model.
a. DBMS
b. RDBMS
c. DB
d. None of the above

RDBMS Class 11 MCQ

5. Example of the database ________.
a. Microsoft Access
b. OpenOffice Base
c. MySQL
d. All of the above

6. DBMS Stands for __________.
a. Database Management System
b. Database Manage System
c. Data Manage System
d. None of the above

7. A table refers to a _________ representation of data arranged in columns and rows.
a. Two dimensional
b. Three dimensional
c. Four dimensional
d. None of the above

8. __________ is used to manage databases in an RDBMS.
a. Structred Program
b. Structured Query Language (SQL)
c. Forms
d. Report

9. MySQL commands are divided into different categories_________.
a. DDL, DMC and DDP
b. DDL, DML and DPP
c. DDL, DML and DCL
d. None of the above

RDBMS Class 11 MCQ

10. _________ command is used to create databases and tables.
a. Create
b. Select
c. Insert
d. Modify

11. __________ statement is used to create a new database.
a. Select Database
b. Insert Database
c. Create Database
d. Modify Database

12. ___________ statement is used to create a new table.
a. Select Table
b. Insert Table
c. Create Table
d. Modify Table

13. The _________ statement is used to see the structure of a table.
a. Modify
b. Display
c. Describe
d. Select

14. ALTER TABLE statement is used to change the structure of a table.
a. Modify Table
b. Display Table
c. Alter Table
d. Select Table

RDBMS Class 11 MCQ

15. _______ command is used to delete tables.
a. Delete Table
b. Cut Table
c. Drop Table
d. None of the above

16. _________ statement is used to insert a new row in a table.
a. Insert into
b. Select into
c. Display into
d. Add into

17. Data stored in a single table is known as __________.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above

18. Data is stored in multiple tables, which are connected together via a common field.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above

19. The _______ statement is used to fetch data from one or more database tables.
a. Insert statement
b. Select statement
c. Display statement
d. Add statement

RDBMS Class 11 MCQ

20. _________ means display all columns.
a. Insert *
b. Select *
c. Select %
d. Select @

21. The __________ clause is used to select specific rows.
a. What clause
b. When clause
c. Where clause
d. None of the above

22. We can change the structure of a table ie. add, remove or change its column(s) using the _________ statement.
a. Insert Table
b. Alter Table
c. Display Table
d. Add Table

23. The keyword _________ is used to eliminate redundant data from display.
a. Modify
b. Distinct
c. Describe
d. None of the above

24 Logical operators ________ are used to connect relational expressions in the WHERE clause.
a. OR
b. AND
c. NOT
d. All of the above

RDBMS Class 11 MCQ

25. Logical operator _______ is used to negate a condition.
a. OR
b. AND
c. NOT
d. All of the above

26. The _________ operator defines the range of values that the column values must fall into to make the condition true.
a. Multiplication
b. Modular
c. Equalto
d. Between

27. The __________ operator selects values that match any value in the given list of values.
a. Multiplication
b. Modular
c. IN
d. Between

28. Give the example of wild card character _______.
a. %
b. _
c. Both a) and b)
d. None of the above

29. The _________ symbol is used to represent any sequence of zero or more characters.
a. %
b. _
c. &
d. #

RDBMS Class 11 MCQ

30. The _________ symbol is used to represent a single character.
a. %
b. _
c. &
d. #

31. _________ represents a value that is unavailable, unassigned, unknown or inapplicable.
a. None
b. NULL
c. Empty
d. None of the above

32. The results of the SELECT statement can be displayed in the ascending or descending order of a single column or columns using _________ clause.
a. Non Order by
b. Modular
c. Order by
d. Where cause

33. ________ statement is used to modify existing data in a table.
a. Insert Table
b. Update Table
c. Display Table
d. Add Table

34. _________ statement is used to delete rows from a table.
a. Insert Statement
b. Alter Statement
c. Display Statement
d. Delete Statement

RDBMS Class 11 MCQ

35. When the same piece of data is stored in two or more locations, it is called ______________.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above

36. The unique field present in the table is called __________.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above

37. When the primary key is applied on multiple columns is known as __________.
a. Primary Key
b. Composite Primary Key
c. Foreign Key
d. None of the above

38. SQL stands for _____________.
a. Single Query Language
b. Structured Query Language
c. Semantic Query Language
d. None of the above

39. A row also called a Record or _________ represents a single, data item in a table.
a. Column
b. Tuples
c. Fields
d. None of the above

RDBMS Class 11 MCQ

40. Which datatype is used for storing date and time both in the database.
a. Date
b. Time
c. Timestamp
d. None of the above

41. _____________ are used to identify which type of data we are going to store in the database.
a. Datatype
b. DataItem
c. DataValue
d. DataCat

42. By default the length of the numerical data type is _______.
a. 05
b. 10
c. 20
d. 30

43. ________ means to arrange the data in either ascending order or descending order.
a. Filter
b. Sorting
c. Arrangement
d. None of the above

44. In database, data can be linked between two or more tables with the help of ____________.
a. Primary Key
b. Foreign Key
c. Both a) and b)
d. None of the above

RDBMS Class 11 MCQ

45. Referential Integrity helps to avoid ____________.
a. If you want to add a record in the related table and if there is no associated record available in the primary key table.
b. Changing values in a primary if there are any dependent records in the related table.
c. Deleting records from a primary key table if there are any matching related records available in the associated table.
d. All of the above

46. The connection or association between two or more table is known as ____________
a. Connection
b. Relationship
c. Connector
d. None of the above

47. Relationships between tables help to __________.
a. Save time
b. Reduce data-entry errors
c. Summarize data from related tables
d. All of the above

48. To retrieve all the columns in a table the syntax is ___________.
a. Select $ from <tablename>;
b. Select * <tablename>;
c. Select * from <tablename>;
d. Select % <tablename>;

49. A ____________ is a subset of DML that just deals with information retrieval.
a. Query Language
b. Structure Language
c. Both a) and b)
d. None of the above

50. A ______________ is a language that enables users to access and manipulate data in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above

Employability Skills Class 11 Notes

• Unit 1 : Communication Skills Class 11 Notes
• Unit 2 : Self-Management Skills Class 11 Notes
• Unit 3 : Information and Communication Technology Skills Class 11 Notes
• Unit 4 : Entrepreneurial Skills Class 11 Notes
• Unit 5 : Green Skills Class 11 Notes

Employability Skills Class 11 MCQ

• Unit 1 : Communication Skills Class 11 MCQ
• Unit 2 : Self-Management Skills Class 11 MCQ
• Unit 3 : Information and Communication Technology Skills Class 11 MCQ
• Unit 4 : Entrepreneurial Skills Class 11 MCQ
• Unit 5 : Green Skills Class 11 MCQ

Employability Skills Class 11 Questions and Answers

• Unit 1 : Communication Skills Class 11 Questions and Answers
• Unit 2 : Self-Management Skills – III
• Unit 3 : Information and Communication Technology Skills Class 11 Questions and Answers
• Unit 4 : Entrepreneurial Skills Class 11 Questions and Answers
• Unit 5 : Green Skills Class 11 Questions and Answers

Information Technology Class 11 Notes

• Unit -1 : Computer Organization Class 11 Notes
• Unit -2 : Networking And Internet Class 11 Notes
• Unit-3 : Office Automation Tools Class 11 Notes
• Unit-4: RDBMS Class 11 Notes
• Unit-5: Fundamentals of Java Class 11 Notes

Information Technology Class 11 MCQ

• Unit -1 : Computer Organization Class 11 MCQ
• Unit -2 : Networking And Internet Class 11 MCQ
• Unit-3 : Office Automation Tools Class 11 MCQ
• Unit-4: RDBMS Class 11 MCQ
• Unit-5: Fundamentals of Java Class 11 MCQ

Information Technology Class 11 Questions and Answers

• Unit -1 : Computer Organization Class 11 Questions and Answers
• Unit -2 : Networking And Internet Class 11 Questions and Answers
• Unit-3 : Office Automation Tools Class 11 Questions and Answers
• Unit-4: RDBMS Class 11 Questions and Answers
• Unit-5: Fundamentals of Java Class 11 Questions and Answers