Information Technology 4 Marks Quetions

(i) INSERT Command: It is used to add a single record or multiple records into a table.
Syntax:
INSERT INTO (col1, col2…)
VALUES (val1, val2);

(ii) SELECT Command: It is used to query or retrieve data from a table in the database.
Syntax:
SELECT column_list FROM table_name WHERE ;

(iii) DELETE Command: To discard unwanted data from a database, the delete command is used.
Syntax:
DELETE FROM WHERE ;

(iv) DCL Command: These commands are used to assign security levels in a database that involves multiple user setups. They are used to grant defined roles and access privileges to the users.
e.g. GRANT and REVOKE command.

(a) An Internet Service Provider (ISP) is an organization that provides you with access to the Internet via wired or wireless connection. To use the Internet, you need an Internet connection.
(b) Internet connections are provided by Internet Service Providers (ISPs) such as Bharat Sanchar Nigam Limited (BSNL), MTNL, Airtel, Vodafone, Reliance, Tata Indicom, etc.
(c) The home users use cable modem(type of broadband connection) and Wi-Fi(Wireless Fidelity). It is a popular technology that allows an electronic device such as a computer or mobile phone to exchange data wirelessly over a network.
(d) Satellites orbit around the Earth and provide necessary links for telephone and television services.

(a) There are 8 fields and 6 records in the table Employee.

(b) (i) SELECT E_name, Salary FROM Employee WHERE Salary< = 16000;(ii) SELECT* FROM Employee WHERE Commission >=300;(iii) SELECT *FROM EMPLOYEE WHERE Profile="CLERK’;

Question 20.
Ajay is learning about the different terms and commands of a database. He came across the following terms. Tell him the definition of the following. (4)
(i) Insert command
(ii) Select command
(iii) Delete command
(iv) DCL command
Answer:
(i) INSERT Command: It is used to add a single record or multiple records into a table.
Syntax:
INSERT INTO (col1, col2…)
VALUES (val1, val2);
(ii) SELECT Command: It is used to query or retrieve data from a table in the database.
Syntax:
SELECT column_list FROM table_name WHERE ;
(iii) DELETE Command: To discard unwanted data from a database, the delete command is used.
Syntax:
DELETE FROM WHERE ;
(iv) DCL Command: These commands are used to assign security levels in a database that involves multiple user setups. They are used to grant defined roles and access privileges to the users.
e.g. GRANT and REVOKE command.

(i) At cell F2, type = D2*E2 and then copy this formula using Fill handle in range F3 : F5.
(ii) At cell G2, type = C2-D2 and then copy this formula using fill handle in range G3 : G5.
(iii) At cell H2, type = IF (G2 > = 0, G2*E2, 0) and copy this formula using the Fill handle in the range H3 : H5.
(iv) Fie should create a chart of any type to graphically represent his data.

You can modify an existing style in the style gallery in two ways:
1. To change an existing style using the Style dialog, right-click on the required style in the Styles and Formatting window and select Modify from the pop-up menu. The Style dialog displayed depends on the type of style selected. Each style dialog has several tabs.
2. To change a style from a selection:

• Step 1: Open the Styles and Formatting dialog.
• Step 2: In the document, select an item that has the format you want to adopt as a style.
• Step 3: In the Styles and Formatting dialog, select the style you want to update (single-click, not double-click), then long-click on the arrow next to the New Style from the Selection icon and click on Update Style.

AutoUpdate applies to paragraph and frame styles only. If the AutoUpdate option is selected on the Organizer page of the Paragraph Style or Frame Style dialog, applying direct formatting to a paragraph or frame using this style in your document automatically updates the style itself. You can also update styles by copying or loading them from a template or another document.