Question
If a meaningful four-letter English word is formed by
using the 2nd, 5th, 6th and 10th letter (from the left end) of the word ‘COMPONENTS’ then which of the following will be third letter of the word formed from the left end? If more than one such meaningful word is formed mark 'Y' as your answer. If no meaningful word is formed, mark 'Z' as your answer.Solution
The 2nd, 5th, 6th and 10th letters are 'O', 'O', 'N' and 'S' respectively. A meaningful four-letter English word formed by these letters is: ‘SOON’. The 3rd letter of the word from the left end is: 'O’
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?