Information Technology 4 Marks Quetions

(i) The Scenario is a tool to test “What-if” questions. Each scenario is named and can be edited and formatted separately. When you print the spreadsheet, only the contents of the currently active scenario are printed.
(ii) An absolute link contains all the information necessary to locate a resource and will stop working only if the target is moved.
(iii) A relative link locates a resource using an absolute URL as a starting point will stop working only if the start and target locations change relative to each other.
(iv) A macro is a saved sequence of commands or keystrokes that are stored for later use or to be used repeatedly.

(a) Using a microphone, the speaker can convey their messages.
(b) A web camera is used to have a real-life image of the person.
(c) Speakers are used to listen to the words of the speaker.
(d) Headsets are used to listen to the speaker without disturbing anyone nearby.

(a) Data redundancy means duplication of data computerised database avoids duplication of data and ensures that there is only one instance of certain data.
(b) Data inconsistency helps, if a single database is used by multiple users then it ensures that the same data is present for all the users.
(c) The DBMS can ensure different views for the different users of the database. This keeps the confidentiality of the data safe.
(d) Different users can use the same database to access the data according to their needs. Hence, DBMS provides the sharing of data and resources.

(i) There are 3 fields and 5 records in the table SHOPPE.
(ii) (a) SELECT Id, SName FROM SHOPPE WHERE Area= ‘Nehru Place’;
(b) SELECT * FROM SHOPPE ORDER BY SName;
(c) SELECT SName FROM SHOPPE WHERE Area=’CP’;

A template is a document model that you use to create other documents. For example, you can create a template for business reports that have your company’s logo on the first page. New documents created from this template will all have your company’s logo on the first page. Templates can contain anything that regular documents can contain, such as text, graphics, a set of styles, and user-specific setup information such as measurement units, language, the default printer, toolbar, and menu customization. To use a template to create a document:

• From the main menu, choose File → New → Templates and Documents. The Templates and Documents dialog box will open.
• In the box on the left, click the Templates icon if it is not already selected. A list of template folders appears in the center box.
• Double-click the folder that contains the template that you want to use. A list of all the templates contained in that folder appears in the center box.
• Select the template that you want to use. You can preview the selected template or view the template’s properties:
  • To preview the template, click the Preview icon. A preview of the template appears in the box on the right.
  • To view the template’s properties, Click the Document Properties icon. (For the location of the Document Properties icon) The template’s properties appear in the box on the right.
• Click Open. The Templates and Documents dialog box closes and a new document based on the selected template opens in Writer. You can then edit and save the new document just as you would any other document.