Question
How much should be removed from 893127 so that the
resulting number is divisible by 5?Solution
ATQ,
We have, 893127 ÷ 5 = 178625.4
So, remainder when 893127 is divided by 5 = 0.4 × 5 = 2
Therefore, amount to be removed = 2
Which clause is used to sort the results in SQL?
Which SQL clause is used to filter records after aggregation?
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
A Fact Constellation Schema is also called:
What is the primary function of ETL in a data warehouse environment?
Which of the following stores historical data for analysis?
Which of the following is NOT a characteristic of OLAP systems?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which of the following is a real-time data warehouse application?
Data cleansing is primarily concerned with:
