Question
In a Math exam, the average score of 50 students is 68.
The ratio of boys to girls in the class is 3:2. If the average score of the boys is 70, what is the average score of the girls?Solution
Total marks obtained by all 50 students = 50×68 = 3400 Number of Girls = 2/5 of 50 = 20 Number of boys = 30 Total marks obtained by Boys = 30×70 = 2100 Marks obtained by girls = 3400-2100 = 1300 Average of Girls marks = 1300/20 = 65
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which analytics type is focused on predicting future outcomes?
What is meant by 'cardinality' in data modeling?
Data cleansing is primarily concerned with:
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 the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
Which of the following best describes a Data Warehouse?
Which of the following best describes a fact constellation schema in a data warehouse?
A surrogate key is:
Which of the following best describes the primary function of a database index?