Question Discussion & Solution

The correct answer is Select, where, group by, having.

Additional Information

Six Operations to Order: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY. Because the database executes query components in a specific order,

SELECT select_list [ INTO new_table ]  [ FROM table_source ]

[ WHERE search_condition ]

[ GROUP BY group_by_expression ]

[ HAVING search_condition ]

[ ORDER BY order_expression [ ASC | DESC ] ]

Hence Option 4 is correct

The correct answer is DBMS.

Key Points

• DBMS is NOT antivirus software.
• A database is a collection of related data that depicts a real-world situation. A database system is made to be developed and filled with information for a certain activity.
• A database management system (DBMS) is software that stores and retrieves data for users while taking proper security precautions. It is made up of a collection of applications that manipulate the database.
• The DBMS accepts an application's request for data and informs the operating system to give the requested data.
• A database management system (DBMS) aids users and other third-party applications in storing and retrieving data in huge systems.
• Users can design their own databases using a database management system (DBMS).
• The term "DBMS" refers to the database user as well as other application applications. It serves as a link between the data and the software program.

• McAfee Corp. is a San Jose, California-based global computer security software corporation.
• Avast Antivirus is a cross-platform internet security suite created by Avast for Microsoft Windows, macOS, Android, and iOS.
• Avira Operations GmbH & Co. KG is a German multinational computer security software firm best known for its Avira Free Security antivirus software. 

The logic followed here is:-

The first two words are antonyms of each other.

'Always' is antonym of 'Never'.

Similarly,

The fourth word should be the antonym of the third word.

'Down' is antonym of 'Up'.

So, Never : Always :: Up : Down.

Hence, the correct answer is "Down".

Water Pollution:

• Water pollution occurs when harmful substances often chemicals or microorganisms contaminate a stream, river, lake, ocean, aquifer, or other body of water, degrading water quality and rendering it toxic to humans or the environment.
• Water pollution is a major environmental issue in India.
• The largest source of water pollution in India is untreated sewage.
• Other sources of pollution include agricultural runoff and unregulated small-scale industry.
• Most rivers, lakes, and surface water in India are polluted due to industries, untreated sewage, and solid wastes.

Hence, option 1 is the correct answer. 

​

​Untreated Sewage

• A 2007 study found that the discharge of untreated sewage is the single most important source of pollution of surface and groundwater in India.
• There is a large gap between the generation and treatment of domestic wastewater in India.
• The problem is not only that India lacks sufficient treatment capacity but also that the sewage treatment plants that exist do not operate and are not maintained.

1. Agriculture run-off: Farms discharge large quantities of agrochemicals, organic matter, drug residues, sediments, and saline drainage into water bodies. Nevertheless, agricultural pollution, aggravated by increased sediment runoff and groundwater salinization, is also becoming an issue.
2. Unregulated small-scale industries and religious practices comparatively have less contribution to water pollution in major rivers of India.