Series #CDBA Set-4
QP Code 89
INFORMATION TECHNOLOGY (Code 402)
Time: 2 Hours MM: 50
Answer Key – 2024
Section – A
Objective Type Questions (24 Marks)
1. Answer any 4 out of the given 6 questions on Employability Skills. 4 x 1 = 4
(i) The filename and filename extension are separated by a _______.
(A) Dollar ($)
(B) Dot (.)
(C) Underscore (_)
(D) Hash (#)
Answer: (B) Dot (.)
(ii) Which of the following type of communication involves interchanging messages only through images or pictures?
(A) Verbal
(B) Gesture
(C) Visual
(D) Facial
Answer: (C) Visual
(iii) _______ is the ability to identify and manage one’s own emotions, as well as the emotions of others.
(A) Self-Awareness
(B) Emotional Intelligence
(C) Stress Management
(D) Emotional Barrier
Answer: (B) Emotional Intelligence
(iv) ________ is the driving force that pushes us to achieve our goals, feel happy and improve our quality of life.
(A) Stress Management
(B) Self-Awareness
(C) Self-Growth
(D) Self-Motivation
Answer: (D) Self-Motivation
(v) Which of the following is not an essential quality to become a successful entrepreneur?
A) Confidence
(B) Creativity
(C) Patience
(D) Wealthy
Answer: (D) Wealthy
(vi) In total, how many SDGs were adopted by the United Nations in 2015 as a universal call to action to end poverty, protect the planet, and ensure that by 2030 all people enjoy peace and prosperity?
(A) 13
(B) 11
(C) 17
(D) 19
Answer: (C) 17
2. Answer any 5 out of the given 6 questions: 5 x 1 = 5
(i) Which of the following features allows one to apply a group of formats at the same time?
(A) Fill
(C) Images
(B) Styles
(D) Drag and Drop
Answer: (B) Style
(ii) In Writer, styles and formatting option is available under _________ menu.
(A) Insert
(B) Tools
(C) Format
(D) Window
Answer: (C) Format
(iii) Gaurav is creating a report in Writer. The image gets embedded in his document whenever he drags and drops the image and the document size increases. Suggest a way to link the image file instead of embedding it.
(A) Drag and drop the image.
(B) Hold down the Ctrl key while dragging.
(C) Hold down the Shift key while dragging the image.
(D) Hold down the Ctrl and Shift key while dragging and dropping the image.
Answer: (D) Hold down the Ctrl and Shift Key while dragging and dropping the image.
(iv) Resizing a __________ may badly affect the resolution of an image.
(A) Vector image
(B) Raster image
(C) CAD image
(D) Coloured image
Answer: (B) Raster Image
(v) In Writer, you can create your own template in ________ way(s).
(A) One
(B) Two
(C) Three
(D) Four
Answer: (B) Two
(vi) In Writer, __________ function key is used to see the databases while implementing mail merge.
(A) F1
(B) F2
(C) F3
(D) F4
Answer: (D) F4
3. Answer any 5 out of the given 6 questions: 5 x 1 = 5
(i) While consolidating data, a cell range can be named using ______ option.
(A) Name range
(B) Define range
(C) Consolidate name
(D) Define name
Answer: (B) Define range
(ii) Kawal and his friends are working on a Spreadsheet for entering data and updating records. They wish to keep a track of changes. Which of the following options will help in knowing who made the changes and what changes were done in the spreadsheet?
(A) View changes
(B) Record changes
(C) Store changes
(D) Track changes
Answer: (b) Record Changes
(iii) _________ is a more elaborate form of Goal Seek.
(A) Database
(B) Hyperlink
(C) Report
(D) Solver
Answer: (D) Solver
(iv) Macro functions can be written to behave as regular functions by writing a/an _________.
(A) Void
(B) Return
(C) Add-In
(D) Dim
Answer: (C) Add-In
(v) _________ option of Calc helps in viewing the changes made to a worksheet using original and edited worksheet.
(A) Edit -> Revise document
(B) Edit -> Consolidate
(C) Edit -> Compare document
(D) Edit -> Collaborate document
Answer: (C) Edit -> Compare Document
(vi) In Calc, shared workbooks allow:
(A) Merging cells
(B) Conditional formatting
(C) Inserting pictures/graphs
(D) Adding text
Answer: (D) Adding text
4. Answer any 5 out of the given 6 questions. 5 x 1 = 5
(i) In OpenOffice Base, the relationship applied on the tables can be removed with the help of _______ option.
(A) Clear
(B) Remove
(C) Drop
(D) Delete
Answer: (D) Delete
(ii) In SQL, the keyword to display records in ascending order is :
(A) Asce
(B) Incr
(C) Asc
(D) High
Answer: (C) Asc
(iii) ______ is a numeric data type which can store Yes/No type values in the form of 0 or 1 in OpenOffice Base table.
(A) Boolean
(B) Char
(C) Binary
(D) OtherObject
Answer: (A) Boolean
(iv) Which of the following statement retrieves zero or more rows from one or more database tables or database views?
(A) UPDATE
(B) DELETE
(C) SELECT
(D) DISPLAY
Answer: (C) SELECT
(v) Roshni has created a table Customer in SQL and wants to store photograph image of every customer under Cust photo field. Suggest a suitable data type from the options given below.
(A) IMAGE
(B) PICTURE
(C) LONGVARBINARY
(D) GRAPHIC
Answer: (C) LONGVARBINARY
(vi) By default, all the fields in OpenOffice Base will have ______ datatype.
(A) int (tiny)
(B) Boolean
(C) text (varchar)
(D) text (char)
Answer: (C) text(varchar)
5. Answer any 5 out of the given 6 questions. 5 x 1 = 5
(i) A ________ is a discussion style website similar to an online personal diary, used for creating personal web pages.
(A) WWW
(B) Web
(C) Blog
(D) Chat
Answer: (C) Blog
(ii) Natasha works as floor manager. She has been assigned a task for conducting regular _______ to ensure safety of life in case of any disaster or emergency by evacuating the place of danger.
(A) Cultural assembly
(B) Open house events
(C) Evacuation drill
(D) Trips and excursions
Answer: (C) Evacuation drill
(iii) _________ is an accessibility feature that assists people who have difficulty using a keyboard or a mouse (or both).
(A) Sticky keys
(B) Serial key
(C) Control key
(D) Toggle keys
Answer: (B) Serial Key
(iv) Network in which all computers have equal status is called _______.
(A) Peer-to-Peer architecture
(B) Central architecture
(C) Hierarchical architecture
(D) Client-server architecture
Answer: (A) Peer-to-Peer architecture
(v) _______ are text files with small pieces of data like a username and password.
(A) Operating System
(B) Antivirus
(C) Cookies
(D) Modem
Answer: (C) Cookies
(vi) DSL stands for _________.
(A) Digital System Line
(B) Data Subscriber Line
(C) Digital Subscriber Line
(D) Data Service Line
Answer: (C) Digital Subscriber Line
Section B
(Subjective Type Questions) 26 Marks
Answer any 3 out of the given 5 questions on Employability Skills in 20-30 words each. 3 x 2 = 6
6. How can cultural differences be a barrier to effective communication?
Answer: Cultural barriers is when people of different cultures are unable to understand each other’s customs, resulting in inconveniences and difficulties.
People sometimes make stereotypical assumptions about others based on their cultural background, this leads to difference in opinions and can be a major barrier to effective communication.
7. Explain any two misconceptions about entrepreneurship.
Answer: Misconceptions about Entrepreneurship are
(a) The misconception is that every business idea needs to be unique or special.
The businesses are common businesses that we see every day. But, each entrepreneur saw customer demand and brought a new idea into their business. A person can take an idea that is already there in the market and do something different with it.
(b) The misconception we have is that a person needs a lot of money to start a business.
The money used to start a business is called capital. Capital is important for starting. However, every business does not need a lot of capital to start. Depending on how much money you have or can borrow, you can start a business with that much money. Once you make more money, you can put that into your business to make it bigger.
8. Briefly discuss the significance of time management skills in order to succeed in life.
Answer: Time management is the ability to plan and control how you spend the hours of your day well and do all that you want to do.
Significance:
Time management is the thinking skill that helps you to
- complete tasks on time.
- make a daily timetable.
- make a good guess at how long it will take you to do something.
- submit homework and assignments on time.
- not waste time during the day.
9. Very often we hear about spam mails. Explain what are spam mails, and what should be done with such mails.
Answer: Sometimes we get mails from companies who are advertising a product or trying to attract you to their website. Such mails are called SPAM.
We should never respond to SPAM and delete it on a regular basis. We can set a filter to send all such spam in spam folder.
10. Mention any two ways to get clean and affordable energy.
Answer: Two ways to get clean and affordable energy are
- (a) Using solar power i.e., power generated using the sun does not cause pollution as it does not require the burning of non-renewable fuels, such as coal.
- (b) Use of biogas is also an eco-friendly alternative to natural gas.
Answer any 4 out of the given 6 questions in 20-30 words each. 4 x 2 = 8
11. Write the main steps to group drawing objects in Writer.
Answer: To group drawing objects:
- 1. Select one object, then hold down the Shift key and select the others you want to include in the group. The bounding box expands to include all the selected objects.
- 2. With the objects selected, hover the mouse pointer over one of the objects and choose Format > Group > Group from the menu bar or right-click and choose Group > Group from the pop-up menu.
12. What is the purpose of consolidating data in spreadsheets? Discuss briefly.
Answer: The main purpose of Data Consolidation is to gather your data together from separate worksheets into a master worksheet.
In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
13. Differentiate between LAN and WAN.
Answer: The difference between LAN and WAN
- LOCAL AREA NETWORK
- A local area network (LAN) is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.
- Usually, local area networks offer very high speeds and are used for connecting computers and peripherals such as printers, scanners, etc.
- WIDE AREA NETWORK
- A wide area network (WAN) is one which covers a broad area (i.e., any network that links across metropolitan, regional, or national boundaries).
The Internet is the most popular WAN, and is used by businesses, governments, non-profit organizations, individual consumers, artists, entertainers, and many others.
- A wide area network (WAN) is one which covers a broad area (i.e., any network that links across metropolitan, regional, or national boundaries).
14. What are the two parts of a cell reference while referencing data on other sheets? Explain with an example.
Answer: While referencing data on other sheets, the cell reference has two parts:
- the sheet name (’Checking Account’) and
- the cell reference (F3).
For example:
=’Savings Account’.F3.
Saving Account is the name of the sheet and F3 is the cell address which value we want to access.
Note that they are separated by a period.
15. Give any two benefits of creating relationships between tables in a database.
Answer: A relationship refers to an association or connection between two or more tables. When you relate two tables, you don’t need to enter the same data in separate tables.
Benefits of creating Relationships between tables in a database:
(a) Save time as there is no need to enter the same data in separate tables.
(b) Reduce data-entry errors.
(c) Summarize data from related tables.
16. Mention any two basic fire safety rules to be followed in any organization.
Answer: Basic Fire safety rules in an organization are :
- Fire escape plans must be installed at proper levels
- Conduct regular drills
- Smoke alarms must be placed at proper intervals
- Keep workplace a no-smoking zone
- Maintenance of safety equipment must be taken care of regularly
Answer any 3 out of the given 5 questions in 50 – 80 words each. 4 x 2 =8
17. What is the concept of mail merge in word processing software? Discuss in detail. Also give any two major benefits of using mail merge.
Answer: A mail merge is a way to take a letter you’ve written and send it to a whole bunch of people, personalizing it with information about them so they might think that you typed that letter personally for them.
A mail merge can also be a quick way to take a list of people’s mailing addresses and generate labels or envelopes with the address for a different person on each label or envelope.
The advantages of Mail Merge are as follows:
- 1. The Mail Merge feature makes it easy to send the same letter to a large number of people.
- 2. By using Mail Merge, we don’t have to type each recipient’s name separately in each letter.
- 3. We need to proofread only the main document.
- 4. It is economical and saves a lot of time.
- 5. It is one of the fastest ways to produce hundreds of personalised letters.
- 6. It is easy to edit the letter as a single change made in the main letter will be reflected in the letters meant for all other recipients.
18. Explain four types of hyperlinks that can be applied in spreadsheets.
Answer: Four types of hyperlinks:
- Internet: the hyperlink points to a web address, normally starting with http://
- Mail & News: the hyperlink opens an email message that is pre-addressed to a particular recipient.
- Document: the hyperlink points to a place in either the current worksheet or another existing worksheet.
- New document: the hyperlink creates a new worksheet.
19. Internet security is of prime concern nowadays. Using strong passwords can lower the risk of security breach on the Internet.
Himanshi has just created her first Internet based account. Help her by giving any four general guidelines for managing strong passwords.
Answer: General guidelines for strong passwords are: –
- (i) Password must be a combination of upper alphabet, lower alphabet, digits, and a special symbol.
- (ii) It must be 6 to 8 characters long.
- (iii) It must not be the name of your family, friends, pets, etc.
- (iv) It must not be any dictionary words.
- (v) It must not be your date of birth.
20. In the context of OpenOffice Base, explain the concept and significance of the following:
(a) Forms
(b) Reports
Answer:
(a) Forms: A form provides the user a systematic way of storing information into the database. It is an interface in a user specified layout that lets users to view, enter, and change data directly in database objects such as tables.
(b) Reports: A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format. Reports helps to get the summarized data.
21. Consider the table Product and write SQL queries for the following:
Table: Product
| PID | PNAME | PRICE | QUANTITY | CATEGORY |
| P01 | BOARD | 10000 | 2 | OFFICE |
| P02 | EYELINER | 700 | 50 | MAKEUP |
| P04 | PENCIL | 5 | 500 | SCHOOL |
| P05 | LAMP | 250 | 10 | DOMESTIC |
| P08 | BEDSHEET | 450 | 45 | DOMESTIC |
| P09 | LAPTOP | 75000 | 15 | OFFICE |
(a) To display names of all products whose category is “domestic”.
(b) To display product name and price whose quantity is less than 50.
(c) To display price and quantity of Laptop.
(d) To display name and quantity of those products whose price is above 5000.
Answer:
(a) SELECT PNAME FROM PRODUCT WHERE CATEGORY = “DOMESTIC”;
(b) SELECT PNAME, PRICE FROM PRODUCT WHERE QUANTITY < 50;
(c) SELECT PRICE, QUANTITY FROM PRODUCT WHERE PNAME = “LAPTOP”;
(d) SELECT PNAME, QUANTITY FROM PRODUCT WHERE PRICE > 5000;
For Visually Impaired Candidates
21. In the context of Database Management System, write a short note on the following:
(a) Database
(b) Table
(c) Field
(d) Composite Primary Key
Answer:
(a) Database: A database is an organized collection of data. You can visualize it as a container of information.
(b) Table: A table is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows. A table has a defined number of columns but can have any number of rows.
(c) Field: A column is a set of data values of a particular simple type, one for each row of the table. The columns provide the structure according to which the rows are composed. For example, cFirstName, or cLastName are fields in a row.
(d) Composite Primary Key: When primary key constraint is applied on one or more columns then it is known as Composite Primary Key.
