Question
If Sudhir was born on 3rd October 1995. Samar
was born on 3 days before Sudhir. The Republic day of that year fell on Thursday. Which day was Samar born?Solution
Samar was born on 30st September 1995. 26th January 1995, was Thursday Days upto 30st September 1995 from 26th January = 5 + 28 + 31 + 30 + 31 + 30 + 31 + 31 + 30 = 247 = 35 weeks + 2 days = Thursday + 2 days = Saturday
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?
Relevant for Exams:
