Download App

Information Technology 4 Marks Quetions

IT Set 6 · CBSE STD 10 (CBSE - English Medium). 5 questions.

Questions

4 Marks Quetions

🎯

Test yourself on this topic

5 questions · timed · auto-graded

Question 14 Marks
Reema has been appointed as an SME in an IT-based company. Tell her the following:
(i) What is a workplace emergency?
(ii) Name the workplace emergencies that may happen.
Answer
(i) A workplace emergency is an unforeseen situation that threatens your employees, customers, or the public; disrupts or shuts down workplace operations; or causes physical or environmental damage.
(ii) Emergencies may be natural or manmade and include the following:
  • Floods
  • Hurricanes
  • Tornadoes
  • Fires
  • Toxic gas releases
  • Chemical spills
  • Radiological accidents
  • Explosions
  • Civil disturbances
  • Workplace violence resulting in bodily harm and trauma.
View full question & answer→
Question 24 Marks
Yuan is learning about databases. But, he didn’t understand the concept of fields, records, and tables. Answer to him the following queries: 
(i) How are fields, records, and a table related to each other? Explain with the help of an example.
(ii) What are the main purposes of a database system?
Answer
(i) Fields are a type of information. A record contains logically related fields.
A table contains logically related records.

Image
In table Emp, EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20,000 represents one complete record.
(ii) The main purposes of a DBMS are
  • Storage of information
  • Retrieval of information quickly.
  • Sorting, selecting data that satisfies certain and readable format,
  • Produce the report in some standardized and readable format.
View full question & answer→
Question 34 Marks
Consider the following table: MASTER 
Image
(i) How many fields and records are there in the table MASTER?
(ii) Write the SQL queries to:
(a) Display all the records according to Age.
(b) Display the Name and Department of the person having a salary of less than 20000.
(c) Display the Name of the person having an age less than 30.


Answer
(i) There are 5 fields and 5 records in the table MASTER.
(ii) (a) SELECT * FROM MASTER ORDER BY Age;
(b) SELECT Name, Department FROM MASTER WHERE Salary<20000;
(c) SELECT Name FROM MASTER WHERE Age<30;
View full question & answer→
Question 44 Marks
Ram wants to compress a picture. Write the steps through which he can do so.
Answer

(i) The SUBTOTAL function is listed in the mathematical category of functions. It is used to calculate subtotals for a given range with the help of another function defined within it. The general syntax of the SUBTOTAL function is as follows: SUBTOTAL (Function; Range)
Here, the Function is the index number for one of the functions

(ii) Any 5 functions with their function index number are:

FunctionFunction Index
Average ()1
Count ()2
Counta ()3
Max ()4
Min ()5
View full question & answer→
Question 54 Marks
Simran wants to know about Subtotal. Answer the given questions for her.
(i) What is the SUBTOTALO function?
(ii) Names of any 5 functions with their function index number.
Answer

(i) The SUBTOTAL function is listed in the mathematical category of functions. It is used to calculate subtotals for a given range with the help of another function defined within it. The general syntax of the SUBTOTAL function is as follows: SUBTOTAL (Function; Range)
Here, the Function is the index number for one of the functions

(ii) Any 5 functions with their function index number are:

FunctionFunction Index
Average ()1
Count ()2
Counta ()3
Max ()4
Min ()5
View full question & answer→
Generate Paper FreeAll IT Set 6 topics