Question
It was Thursday on February 8, 2024, then, what will be the
day on February 8, 2028?Solution
The number of odd days in a normal year is '1' and the number of odd days in a leap year is '2'.
There are 3 normal years (2025, 2026 and 2027) , 1 leap year i.e., 2024 from February 8, 2024 to February 8, 2028
So, number of odd days will be:
From February 8, 2024 to February 7, 2025: 2
From February 8, 2025 to February 7, 2026: 1
From February 8, 2026 to February 7, 2027: 1
From February 8, 2027 to February 7, 2028: 1
So, total number of odd days = 5 Thus, on February 8, 2028 it will be Tuesday.
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
Recursive CTEs are mainly used for:
To rename a column in a SELECT query result, you use:
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL keyword prevents duplicate rows in result?
Which operator is used to combine results of two SELECT queries and remove duplicates?
What is the result of SELECT COUNT(NULL) on any table?
Which of the following SQL constructs avoids returning duplicate rows?
What is a 'stored procedure' in SQL?
