Question
Write the few points for the healthy use of technology.
✓
Answer
Healthy use of Technology:
(i) Take tech breaks, both huge and little. A tech break can be as little as venturing far from your work area to go for a short stroll over the room or
as enormous as proclaiming an innovation power outage for a whole day every week.
(ii) Inspect your inspirations. Have a go at eliminating the quantity of posts or announcements you make every day. Approach yourself whether you are posting for narcissistic reasons or with genuine association as an objective.
(iii) Give your work or diversion space an ergonomic makeover. Why not dedicate some an opportunity to improving the spots where you spend such an
extensive amount your day? A superior put work area seat or better lighting can have an enormous effect on your physical and enthusiastic prosperity.
(iv) Mood killer the lights—every one of them. To abstain from upsetting your rest rhythms, turn off the entirety of your screens an hour or two preceding you hit the sack and give your eyes a rest.
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
The following is the code related to the data structure QUEUE
Now answer the following based on the code given:
(a) What is the purpose of EnQueue function
(# Statement-1) defined above:
(i) It is a user defined function to scan / access QUEUE elements
(ii) It is a pre defined function to scan / access QUEUE elements
(iii) It is a user defined function working on double ended queue
(iv) It is a user defined function working on circular queue
(b) What is the line QUEUE.append(VALUE)
(# Statement-2) doing
(i) This will add the element at the end of the QUEUE
(ii) This will remove the element from the end of the QUEUE
(iii) This will add the element at the beginning of the QUEUE
(iv) This will remove the element from the beginning of the QUEUE
(c) Conceptually if the QUEUE is already full , what will happen
(i) PEEK() function will be executed
(ii) OVERFLOW occurs
(iii) UNDERFLOW occurs
(iv) We may still add more elements in it.
(d) What is the use of the variable VALUE used in argument (# Statement-1)
(i) This is the position of FRONT
(ii) This is the position of REAR
(iii) This is an element added in a QUEUE
(iv) This is the name of the list
(e) When the else part (# Statement-3) of the above code will be executed
(i) When the length of the QUEUE is zero
(ii) When the length of the QUEUE is one
(iii) When the length of the QUEUE is more than one
(iv) This part of the code will always executed
Dhruv Kumar of class 12 is writing a program to create a CSV file “Teacher.csv” which will store the teacher information entered by user. He has written the following code. As a programmer, help him to successfully execute the given task. Write appropriate statement / function/ code against fill ups.
Uplifting Skills Hub India is a knowledge and skill community which has an aim to uplift the standard of knowledge and skills in the society. It is planning to setup its training centers in multiple towns and villages pan India with its head offices in the nearest cities. They have created a model of their network with a city, a town and 3 villages as follows.
As a network consultant, you have to suggest the best network related solutions for their issues/problems raised in (a) to (d) keeping in mind the distances between various locations and other given parameters.
Shortest distances between various locations:
| VILLAGE 1 to B_TOWN | 2 KM |
| VILLAGE 2 to B_TOWN | 1.0 KM |
| VILLAGE 3 to B_TOWN | 1.5 KM |
| VILLAGE 1 to VILLAGE 2 | 3.5 KM |
| VILLAGE 1 to VILLAGE 3 | 4.5 KM |
| VILLAGE 2 to VILLAGE 3 | 2.5 KM |
| A_CITY Head Office to B_HUB | 25 KM |
Number of Computers installed at various locations are as follows:
| B_TOWN | 120 |
| VILLAGE 1 | 15 |
| VILLAGE 2 | 10 |
| VILLAGE 3 | 15 |
| A_CITY OFFICE | 6 |
Note:
• In Villages, there are community centers, in which one room has been given as training center to this organization to install computers.
• The organization has got financial support from the government and top IT companies.
(a) Suggest the most appropriate location of the SERVER in the B_HUB (out of the 4 locations), to get the best and effective connectivity. Justify your answer.
(b) Suggest the best wired medium and draw the cable layout (location to location) to efficiently connect various locations within the B_HUB.
(c) Which hardware device will you suggest to connect all the computers within each location of B_HUB?
(d) Which service/protocol will be most helpful to conduct live interactions of Experts from Head Office and people at all locations of B_HUB?
Answer the following questions.
Table: Employee
| No | Name | Salary | Zone | Age | Grade | Dept |
| 1 | Mukul | 30000 | West | 28 | A | 10 |
| 2 | Kritika | 35000 | Centre | 30 | A | 10 |
| 3 | Naveen | 32000 | West | 40 | 20 | |
| 4 | Uday | 38000 | North | 38 | C | 30 |
| 5 | Nupur | 32000 | East | 26 | 20 | |
| 6 | Moksh | 37000 | South | 28 | B | 10 |
| 7 | Shelly | 36000 | North | 26 | A | 30 |
Table: Department
| No | DName | MinSal | MaxSal | HOD |
| 10 | Sales | 25000 | 32000 | 1 |
| 20 | Finance | 30000 | 50000 | 5 |
| 30 | Admin | 25000 | 40000 | 7 |
(a) Based on these tables write SQL statements for the following queries:
(i) Display the details of all the employees who work in Sales department.
(ii) Display the Salary, Zone, and Grade of all the employees whose HOD is Nupur.
(iii) Display the Name and Department Name of all the employees.
(iv) Display the names of all the employees whose salary is not within the specified range for the corresponding department.
(v) Display the name of the department and the name of the corresponding HOD for all the departments.
(b) Identify the Foreign Keys (if any) of these tables. Justify your choices.
Mr. Iqbal is a programmer, who has recently joined the company and given a task to write a python code to perform the following binary file operations with the help of two user defined functions/modules:
→(a)
How can we contribute to a greener environment?
Consider the SchoolBus table given below:
(a) State the command that will give the output as:
Area_covered
Yamuna Vihar
Krishna Nagar
Vasundhara
(i) select area_covered from schoolbus where transporter Yadav Co.'and transporter='Bhalla Co.';
(ii) select area_covered from schoolbus where not transporter-Yadav Co.'and transporter=Bhaila Co.';
(iii) select area_covered from schoolbus where transporter - Yadav Co.'
OR transporter'Bhalla Co.';
(iv) select area_covered from schoolbus where transporter IN("Yadav co.", -Bhalla co."):
Choose the correct option:
(i) Both (i) and (ii). (ii) Both (iii) and (iv).
(iii) Any of the options (i), (ii) and (iv) (iv) Only (iii)
(b) What will be the output of the following command?
Select * from schoolbus where distance=20 order by charges;
(c) Ravi has given the following command to obtain the Longest distance Select max(distance) from schoolbus where group by transporter;
But he is not getting the desired result.
Help him by writing the correct command.
(i) select max(distance) from schoolbus where group by transporter;
(ii) select transporter, max(distance) from schoolbus group by distance;
(iii) select transporter, max(distance) group by transporter from schoolbus;
(iv) select transporter, max(distance) from schoolbus group by transporter;
(d) Help Saumya to write the command to display the name of the transporter who is having lowest capacity in his schoolbus?
(i) select transporter.min(capacity) from schoolbus;
(ii) select transporter.max(capacity) from schoolbus:
(iii) select transporter.min(capacity) from schoolbus group by transporter:
(iv) select transporter.maximum(capacity)
(e) Choose the appropriate primary key.
(i) Transporter (ii) Area_covered (iii) Rtno (iv) Charges
Table: School Bus
| Rtno | Area_covered | Capacity | Noofstudents | Distance | T ransporter | Charges |
| 1 | Vasantkunj | 100 | 120 | 10 | Shivamtravels | 100000 |
| 2 | HauzKhas | 80 | 80 | 10 | Anand travels | 85000 |
| 3 | Pitampura | 60 | 55 | 30 | Anand travels | 60000 |
| 4 | Rohini | 100 | 90 | 35 | Anand travels | 100000 |
| 5 | Yamuna Vihar | 50 | 60 | 20 | Bhalla Co. | 58000 |
| 6 | Krishna Nagar | 70 | 80 | 30 | Yadav Co. | 80000 |
| 7 | Vasundhara | 100 | 110 | 20 | Yadav Co. | 100000 |
| 8 | Paschim Vihar | 40 | 40 | 20 | Speed travels | 55000 |
Area_covered
Yamuna Vihar
Krishna Nagar
Vasundhara
(i) select area_covered from schoolbus where transporter Yadav Co.'and transporter='Bhalla Co.';
(ii) select area_covered from schoolbus where not transporter-Yadav Co.'and transporter=Bhaila Co.';
(iii) select area_covered from schoolbus where transporter - Yadav Co.'
OR transporter'Bhalla Co.';
(iv) select area_covered from schoolbus where transporter IN("Yadav co.", -Bhalla co."):
Choose the correct option:
(i) Both (i) and (ii). (ii) Both (iii) and (iv).
(iii) Any of the options (i), (ii) and (iv) (iv) Only (iii)
(b) What will be the output of the following command?
Select * from schoolbus where distance=20 order by charges;
(c) Ravi has given the following command to obtain the Longest distance Select max(distance) from schoolbus where group by transporter;
But he is not getting the desired result.
Help him by writing the correct command.
(i) select max(distance) from schoolbus where group by transporter;
(ii) select transporter, max(distance) from schoolbus group by distance;
(iii) select transporter, max(distance) group by transporter from schoolbus;
(iv) select transporter, max(distance) from schoolbus group by transporter;
(d) Help Saumya to write the command to display the name of the transporter who is having lowest capacity in his schoolbus?
(i) select transporter.min(capacity) from schoolbus;
(ii) select transporter.max(capacity) from schoolbus:
(iii) select transporter.min(capacity) from schoolbus group by transporter:
(iv) select transporter.maximum(capacity)
(e) Choose the appropriate primary key.
(i) Transporter (ii) Area_covered (iii) Rtno (iv) Charges
Answer the following questions.
Bills
| Bill No | Date | I_Code | qty |
|
1 1 2 2 2 3 4 4 5 5 5 |
2010-04-01 2010-04-01 2010-04-01 2010-04-01 2010-04-01 2010-04-02 2010-04-02 2010-04-02 2010-04-03 2010-04-03 2010-04-03 |
1002 3001 1001 1002 2003 2002 2002 2003 2003 3001 3002 |
2 1 3 1 2 1 4 2 2 1 3 |
Items
| I_Code | Name | Category |
|
1001 1002 1003 2001 2002 2003 3001 3002 |
2010-04-01 2010-04-01 2010-04-01 2010-04-01 2010-04-01 2010-04-02 2010-04-02 2010-04-02 |
1002 3001 1001 1002 2003 2002 2002 2003 |
(a) Based on these tables write SQL statements for the following queries:
(i) Display the average rate of a South Indian item.
(ii) Display the number of items in each category.
(iii) Display the total quantity sold for each item.
(iv) Display total quantity of each item sold but don't display this data for the items whose total quantity sold is less than 3.
(v) Display the details of bill records along with Name of each corresponding item.
(v) Display the details of the bill records for which the item is 'Dosa'.
(vi) Display the details of the bill records for which the item is 'Dosa'.
(vii) Display the bill records for each Italian item sold.
(viii) Display the total value of items sold for each bill.
(b) Identify the Foreign Keys (if any) of these tables. Justify your answer.
(c) Answer with justification (Think independently. More than one answers may be correct. It all depends on your logical thinking):
(i) Is it easy to remember the Category of item with a given item code? Do you find any kind of pattern in the items code? What could be the item code of another South Indian item?
(ii) What can be the possible uses of Bills table? Can it be used for some analysis purpose?
(iii) Do you find any columns in these tables which can be NULL? Is there any column which must not be NULL?
Mr. Mathew is a programmer, who has recently joined the company and given a task to write a python code to perform update operation in binary file (stud.dat) which contain admno (Admission No) and fee(Fee paid by student).
He has succeeded in writing partial code and has missed out certain statements, You as an expert of Python have to provide the missing statements.
(a)
On the basis of given dataframe answer the following questions:
| Account | Name | Rep | Manager | Product | Quantity | Price | Status | |
| 0 | 714466 | Tata | Saryu | Abhishek | CPU | 1 | 30000 | presented |
| 1 | 714466 | Tata | Saryu | Abhishek | Software | 1 | 10000 | presented |
| 2 | 714466 | Tata | Saryu | Abhishek | Maintenance | 2 | 5000 | pending |
| 3 | 737550 | Infosys | Saryu | Abhishek | CPU | 1 | 35000 | declined |
| 4 | 146832 | Sapient | Taneja | Abhishek | CPU | 2 | 65000 | won |
| 5 | 218895 | IBM | Taneja | Abhishek | CPU | 2 | 40000 | pending |
| 6 | 218895 | IBM | Taneja | Abhishek | Software | 1 | 10000 | presented |
| 7 | 412290 | Oracle | Joe | Abhishek | Maintenance | 2 | 5000 | pending |
| 8 | 740150 | Flipkart | Joe | Abhishek | CPU | 1 | 35000 | declined |
| 9 | 141962 | Byju | Charu | Arush | CPU | 2 | 65000 | won |
| 10 | 163416 | Gradup | Charu | Arush | CPU | 1 | 30000 | presented |
| 11 | 239344 | Funtoot | Charu | Arush | Maintenance | 1 | 5000 | pending |
| 12 | 239344 | Funtoot | Charu | Arush | Software | 1 | 10000 | presented |
| 13 | 307599 | SQL | Naveen | Arush | Maintenance | 3 | 7000 | won |
| 14 | 688981 | PiE | Naveen | Arush | CPU | 5 | 100000 | won |
| 15 | 729833 | Amazon | Naveen | Arush | CPU | 2 | 65000 | declined |
| 16 | 729833 | Amazon | Naveen | Arush | Monitor | 2 | 5000 | presented |
(i) To print the complete dataframe Name wise.
(ii) To print the dataframe Name wise, Rep waise and Manage wise.
(iii) To print the data frame Manager and Rep wise.
(iv) To print the data frame Manager and Rep price wise
(v) To print the sum of the price, manager and rep wise.
(vi) To print the mean and count of the price which belong to each manager and rep.
(vii) To print the sum of the price which belong to each manager and rep.
(viii) To print the sum of the price which belong to each manager and rep along with Product belongs to them. Fill the NaN with 0.