Question
Which of the following international scientific
organisations approves the names of elements, symbols and unit?Solution
The International Union of Pure and Applied Chemistry (IUPAC): Â It is the world authority on chemical nomenclature and terminology, including the naming of new elements in the periodic table; on standardized methods for measurement; and on atomic weights, and many other critically evaluated data. Dr Lynn M. Soby is the Executive Director of IUPAC.
A star schema in a data warehouse consists of:
A snowflake schema differs from a star schema mainly because:
Which of the following is used to maintain information about the structure of a data warehouse?
In a data warehouse, which type of table stores quantitative data for analysis?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
Which SQL function returns the total number of rows in a table?
Which SQL keyword is used to combine results from two queries and remove duplicates?
What is a data mart?
