Information Technology 2 Marks Quetions [Subject Skills]

ISP (Internet Service Provider) is a company that provides individuals and other companies access to the Internet. Internet Service Provider is used to join the Internet. Internet services typically provided by ISPs include Internet access, Internet transit, domain name registration, web hosting, and Usenet service. ISP does not provide E-mail addresses, e.g. MTNL, BSNL, Airtel etc.

Referential Integrity is a property of data stating that all its references are valid. In the context of relational databases, it is required that if a value of one attribute of a relation references a value of another attribute, then the referenced value must exist. Referential integrity is a database concept that is used to build and maintain logical relationships between two tables. It helps to maintain the accuracy and consistency of data in RDMS.

Two ways of inserting sheets in a workbook are as follows:
Select Insert → Sheet from the Menu Bar.
Right-click on the sheet tab and click on Insert Sheet.

Data → Consolidate provides a way to combine data from two or more ranges of cells into a new range while running one of the several functions (such as Sum or Average) on the data. During consolidation, the contents of cells from several sheets can be combined into one place. The effect is that copies of the identified ranges are stacked with their top left corners at the specified result position, and the selected operation is used in each cell to calculate the result value.

Use an OLE (Object Unking and Embedding) object to insert in a presentation either a new document or an existing one. Embedding inserts a copy of the object and details of the source program in the target document, that is the program that is associated with the file type in the operating system. The major benefit of an OLE object is that it is quick and easy to edit the contents just by double-clicking on it. You can also insert a link to the object that will appear as an icon rather than an area showing the contents itself.