IT

REVISION TEST 2
SECTION A

Q1 . Answer any 4 out of the given 6 questions based on Employability Skills. (4 × 1 = 4)

(i) Which one of the following is not a symptom of stress?
(a) Increased sweating (c) Cold hands or feet
(b) Dry mouth (d) None of the above
(ii) Which term refers to our knowledge and understanding of ourselves?
(a) Self-awareness (c) Both (a) and (b)
(b) Motivation (d) None of these
(iii) Which of the following is an example of effective written communication?
(a) Using excessive jargon and technical terms
(b) Writing lengthy paragraphs without any breaks or bullet points
(c) Using concise and clear language
(d) Including personal opinions and biases
(iv) __________ provides process and memory management services that allow two or
more tasks, jobs or programs to run simultaneously.
(a) Multi-tasking (c) Multi-processing
(b) Multi-threading (d) Multi-computing
(v) Which of the following is an example of a green skill?
(a) Traditional farming techniques
(b) Renewable energy installation and maintenance
(c) Conventional manufacturing processes
(d) Non-recyclable waste disposal methods
(vi) In which situation an entrepreneur will not be able to convince his fellow beings to
achieve his goals?
(a) Low self-confidence (c) Risk-taking
(b) Innovativeness (d) None of the above
Q2 . Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) A __________ is a temporary connection that uses the Public Switched Telephone
Network (PSTN) to connect to the Internet.
(a) broadband connection (c) dial-up connection
(b) wireless connection (d) None of the above
(ii) The small area network created around a Bluetooth device is called __________
(a) LAN (b) PAN (c) WAN (d) MAN
(iii) The __________ SQL statement is used to make a query or retrieve data from a table
in a database.
(a) INSERT (b) UPDATE (c) SELECT (d) REVIEW
(iv) Which of the following allows you to reorder data?
(a) Sorting (b) Filtering (c) Scenario (d) Custom sorting
(v) Which of the following is not an AutoShape?
(a) Line (b) Circle (c) Curve (d) ClipArt
(vi) Neeta is planning to take a car loan to buy a new car. But she is not sure about the
 payback time, i.e. whether to pay it back in 5 or 6 years considering that her monthly
fuel cost will also increase. In such cases, which of the following features of the
spreadsheet can she use to get an idea about it?
(a) Consolidation (b) Macros (c) Templates (d) What-if analysis
Q3 . Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Editing Custom Shapes feature allows __________ of small segments of a drawing.
(a) shaping (b) reshaping (c) rehearse (d) None of these
(ii) DBMS is a program, that controls the creation, maintenance, and use of a
database. Here, DBMS stands for
(a) Digital Base Management System
(b) Data Build Management System
(c) Database Management System
(d) Database Management Service
(iii) A __________ filters data traffic at a network boundary.
(a) bridge (b) switch (c) gateway (d) hub
(iv) Template includes a text space that is surrounded by brackets. It is called a
__________
(a) margin (b) placeholder (c) data source (d) track changes
(v) Key field is a unique identifier for each record. It is defined in the form of __________
(a) rows (b) columns (c) tree (d) query
(vi) What is the name given to a combination of two cell references?
(a) Relative reference (c) Mixed reference
(b) Absolute reference (d) None of the above
Q4 . Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) Which of the following is an application program that is stored on a remote server
and delivered over the Internet?
(a) Web application (c) Internet application
(b) System application (d) None of these
(ii) A __________ is a document model that you use to create other documents.
(a) Anchoring (b) Alignment (c) Template (d) None of these
(iii) 1 : 1, 1 : n, and n : 1 are examples of different types of __________
(a) Relations (b) Databases (c) Data (d) Query
(iv) In packet-based networks, the message gets broken into small __________
(a) data packets (b) data frame (c) chunk (d) None of these
(v) This is a type of hyperlink available in the Hyperlink dialog box, which creates a new
worksheet.
(a) New document (b) New file (c) New worksheet (d) New data
(vi) Which of the following allows you to display the specific data?
(a) Arranging (b) Filtering (c) Scenario (d) Custom sorting
Q5 . Answer any 5 out of the given 6 questions. (5 × 1 = 5)
(i) A __________ refers to a cell or a range of cells on a Worksheet and can be used to
find the values or data that you want the formula to calculate.
(a) cell reference (b) block (c) sheet reference (d) autofill
(ii) URL is the __________ for a website or a web page.
 (a) web address (b) website (c) web page (d) Both (a) and (c)
(iii) Rajiv has created an employee table and made Emp_No, the primary key so that it
can accept unique values for each record. At the same time, he wants to have one
more field that can behave like a primary key. Which of the following types of key can
serve the purpose?
(a) Foreign key (c) Unique key
(b) Composite key (d) None of these
(iv) __________ is used to define the structure of your tables and other objects in the
database.
(a) DDL (b) DML (c) DCL (d) None of these
(v) Suraj wants to know the sequence of steps used to open the Templates dialog.
Answer to his query.
(a) File → New → ext Document (c) Format → Group → Group
(b) File → New → Templates (d) None of the above
(vi) Two other toolbars can be opened from the Picture Toolbar: the __________ and
__________
(a) Edit picture, Color picture (c) Graphic Filter toolbar, Color toolbar
(b) Format, drawing (d) Floating toolbar, Color toolbar
SECTION B
Answer any 3 out of the given 5 questions on Employability skills. Answer each question in
20-30 words. (3 × 2 = 6)
Q6 . How stress can be caused by both good and bad experiences?
Q7 . How do green skills contribute to sustainable development?
Q8 . What is the difference between moving and copying a folder?
Q9 . How entrepreneur is helpful in capital formation?
Q10 . Can you explain what it means to encode a message?
Answer any 4 out of the given 6 questions in 20-30 words each. (4 × 2 = 8)
Q11 . What is the use of grouping objects in a word processor application?
Q12 . What is the difference between a workbook and a worksheet?
Q13 . What is the use of the Scenario tool?
Q14 . Define data, the major component of a database.
Q15 . Name any two ways of wireless connections to the Internet. Ramya wants to connect
all the computers in her office wirelessly to avoid uncoordinated cables. Which
wireless technology would be best suitable for her office?
Q16 . What are the benefits of online shopping?
SECTION C
Answer any 3 out of the given 5 questions in 50-80 words each. (3 × 4 = 12)
Q17 . What is sorting? How to use ascending or descending sort which depends on one
column?
Q18 . Ojas had prepared a Table of Contents of the project work he had done in a word
processor application.
(a) Tell him the different steps to update the TOC.
(b) Tell him the different steps to delete the TOC.
Q19 . Consider the following table:
Table : Employee

(a) How many fields and records are there in the table Employee?
(b) Write the SQL queries for the following:
(i) Display E name and Salary of those employees whose Salary is greater than or
equal to 22000.
(ii) Display details of employees who are not getting commission.
(iii) Display all the details of the employee profile ‘SALESMAN’.
Q20 . Define the following types of integrity.
(i) Entity integrity
(ii) Domain integrity
(iii) Referential integrity
(iv) User-defined integrity
Q21 . Pinky had heard about the words types of networks. She had some doubts. Answer to
her queries to clear her doubts.
(i) What is PAN?
(ii) Define the term WAN.
(iii) Define the term MAN.
(iv) Write a disadvantage of both LAN and WAN.