Information Technology 4 Marks Quetions

(a) A Database Management System (DBMS) is a collection of programs that enable users to create, and maintain a database, and control all the access to the database. The primary goal of the DBMS is to provide an environment that is both convenient and efficient for users to retrieve and store information.
(b) The advantages of using DBMS for school are as follows:

• In school, DBMS is used to store data about students, teachers, and any other related things at a centralized location.
• It provides security to the personal information of the school, stored in it.

(i) There are 6 fields and 7 records in the table SummerCamp.
(ii) (a) SELECT * FROM SummerCamp WHERE DOB BETWEEN 02/02/09 AND 06/03/10;
(b) SELECT * FROM SummerCamp WHERE Gender=’F’;
(c) SELECT * FROM SummerCamp ORDER BY FirstName;

(a) To update a table of contents when changes are made to the document:

• Right-click anywhere in the TOC
• From the pop-up menu, choose Update IndexYTable. The writer updates the table of contents to reflect the changes in the document.

You can also update the index from the Navigator by right-clicking on Indexes → Table of Contents1 and choosing Index → Update from the pop-up menu.
(b) To delete the table of contents from a document:

• Right-click anywhere in the TOC.
• From the pop-up menu, choose Delete Index/Table. The writer deletes the table of contents.

A Scenario is a set of values that Calc saves for a group of cells. Whenever we run a scenario Calc automatically substitutes the saved cell values into a connected formula to give us an output. By having different scenarios for the same group of cells we can get different results from the formula and compare these results to know which is the most suitable set of values for us.
For example, if you wanted to calculate the effect of different interest rates on a car loan, you could add a scenario for each interest rate, and quickly view the results. This will help you to easily find out the most desirable rate of interest for availing the loan. A Scenario is a tool to test “what-if” questions e.g., what happens if I replace THIS value with THAT value? Each scenario has a name and can be edited and formatted separately. You can easily switch between different scenarios for a group of cells by using the scenario drop-down list or scenario navigator.