Question
During which hours is the use of loudspeakers
prohibited, except in closed premises or during a public emergency?Solution
Noise Pollution Rules, 2000 Section 5 – Restrictions on the use of loud speakers/public address system (and sound producing instruments • Permission Requirement • Loudspeakers or public address systems cannot be used without written permission from the authority. • Night-Time Restrictions: Prohibited between 10:00 PM and 6:00 AM, except: • In closed premises (e.g., auditoriums, conference rooms, community halls). • During a public emergency. • Limited Exemptions for Festivals & National Functions • State Government may allow use from 10:00 PM to 12:00 midnight • Applicable only for cultural, religious, or festive occasions • Maximum: 15 days per calendar year • State/District Authorities must pre-specify such exempted days. • Definition of Festive/National Functions • Includes Republic Day, Independence Day, State Day, or other days notified by the Government. • Noise Level Restrictions • Public Places: Noise levels at the boundary of a public place where a loudspeaker, public address system, or other noise source is used must not exceed: o 10 dB(A) above the ambient noise standards for the area, or o 75 dB(A), whichever is lower. • Private Properties: The peripheral noise level of a privately owned sound system or sound-producing instrument must not exceed the ambient noise standards by more than 5 dB(A) at the boundary of the private property.
Which OLAP operation allows drilling down into more detailed data?
Which SQL clause is used to filter records after aggregation?
Which operation in OLAP allows selecting a single dimension from a cube?
In ETL pipelines, which step is primarily responsible for resolving inconsistencies and correcting data quality issues (e.g., missing values, inconsiste...
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
Which OLAP operation rotates the data axes to provide an alternative presentation?
Surrogate keys are used in data warehouses because:
A snowflake schema differs from a star schema mainly because:
Which of the following stores historical data for analysis?
Which of the following is NOT a characteristic of OLAP systems?