Question
15.001% of 799.99 - 3/11% of 1099.99 + 111.002 =
? What will come in place of question marks ‘?’ in the following questions. (You do not have to calculate the exact value)Solution
15% of 800 – 3/11 % of 1100 + 111 = ? 120 – 3 + 111 = ? ? = 231 - 3 = 228
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
A surrogate key is:
Which of these is NOT an ensemble method?
Which of the following best describes a Data Warehouse?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
What is meant by 'cardinality' in data modeling?
Which OLAP operation allows users to view data at different levels of granularity?