Informatics Practices
Mention any three health hazards associated with inappropriate and excessive use of gadgets.
Answer
The three health hazards associated with inappropriate and excessive use of gadgets are as follows :
Impact on Hearing — Listening to loud music for over 15 minutes can cause hearing damage. Using headphones for long periods increases bacteria in the ears by over 700 times.
Impact on Bones and Joints — Technology affects posture due to prolonged sitting and repetitive movements, leading to muscle and joint strain. Repetitive Strain Injuries (RSIs) affect muscles, nerves, tendons, ligaments, and joints.
Eye Problems — Constant screen exposure from smartphones, laptops, and computers can damage vision, especially due to blue light, leading to potential vision loss. Computer Vision Syndrome (CVS) is a related eye condition.
Related Questions
Write MySQL statements for the following :
(i) To create a database named FOOD.
(ii) To create a table named Nutrients based on the following specification :
Column Name Data Type Constraints Food_Item Varchar(20) Primary Key Calorie Integer Richa, recently started using her social media account. Within a few days, she befriends many people she knows and some that she does not know. After some time, she starts getting negative comments on her posts. She also finds that her pictures are being shared online without her permission.
Based on the given information, answer the questions given below :
(i) Identify the type of cyber crime she is a victim of.
(ii) Under which act, she can lodge a complaint to the relevant authorities ?
(iii) Suggest her any two precautionary measures which she should take in future while being online to avoid any such situations.
Consider the given DataFrame 'Genre' :
No Type Code 0 Fiction F 1 Non-fiction NF 2 Drama D 3 Poetry P Write suitable Python statements for the following :
(i) Add a column called Num_Copies with the following data : [300, 290, 450, 760].
(ii) Add a new genre of type 'Folk Tale' having code as "FT" and 600 number of copies.
(iii) Rename the column 'Code' to 'Book_Code'.
Preeti manages database in a blockchain start-up. For business purposes, she created a table named BLOCKCHAIN. Assist her by writing the following queries :
TABLE : BLOCKCHAIN
id user value hash transaction_date 1 Steve 900 ERTYU 2020-09-19 2 Meesha 145 @345r 2021-03-23 3 Nimisha 567 #wert5 2020-05-06 4 Pihu 678 %rtyu 2022-07-13 5 Kopal 768 rrt4% 2021-05-15 7 Palakshi 534 wer@3 2022-11-29 (i) Write a query to display the year of oldest transaction.
(ii) Write a query to display the month of most recent transaction.
(iii) Write a query to display all the transactions done in the month of May.
(iv) Write a query to count total number of transactions in the year 2022.