Question
It will be Saturday on November 12, 2022. What will be
the day on November 12, 2028?Solution
Number of odd days in normal year is '1' and number of odd days in leap year is '2'.
There are 4 normal years (2023, 2025, 2026 and 2027) and 2 leap years, 2024 and 2028, from November 12, 2022 to November 12, 2028.
So, number of odd days will be,
From November 12, 2022 to November 11, 2023: 1
From November 12, 2023 to November 11, 2024: 2
From November 12, 2024 to November 11, 2025: 1
From November 12, 2025 to November 11, 2026: 1
From November 12, 2026 to November 11, 2027: 1
From November 12, 2027 to November 11, 2028: 2
So, total number of odd days is '8'.
Odd number of days is '1' (Odd number of days is the remainder).
So, on November 12, 2028, it will be Sunday.
Fact constellation schema is best described as:
In a star schema, what is the primary characteristic of the fact table?
What is meant by 'cardinality' in data modeling?
Which of the following best describes the primary function of a database index?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which process ensures data in a data warehouse is consistent and clean?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which of the following is NOT a common OLAP operation?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which SQL clause is used to filter records after aggregation?