Download AppGovt. JobsFree G.K. & Current AffairsScholarshipBlog
Free PracticeContact
📚 Exam by Category
▾
📰 FREE Current Affairs, GK & Quiz
📅 Upcoming Exams
🏦 Bank Exams 2026
🚆 Railway Exams
📍 State wise jobs
🎓 Teaching Exams
🏛 NTA UGC NET Exams
🔬 Medical Exams
⚙ Engineering Exams
📋 SSC Exams 2026
🛡 Police Exams
📚 State Wise General Knowledge
📰 States Current Affairs
🌾 ICAR AIEEA 2026
📝 SET Exams
🛠 Trade Apprentice Exams
⚕ Nursing Exams & Staff Nurse Vacancy
🛡 Defence Exams
🔧 ESE Exams 2026
🔬 CSIR UGC NET Exams
⚖ Law and Bare Acts
🔬 IIT JAM 2027
🚂 GATE 2027 Exams
💊 Pharmacy and Paramedicals Exams
🐾 Veterinary Sciences Exams
🏛 UPSC & State PSC Exams
⚖ Law and Judiciary Exam
🏢 Insurance Exams
Question Bank

Data Analytics - English

Duration: 120 · Questions: 100 · Max Marks: 100 · Language: 3

View Data Analytics Exam Page

Data Analytics

1
What is correlation in data analysis?
  1. A.A cause-and-effect relationship
  2. B.A statistical measure of association
  3. C.A visualization technique
  4. D.A data cleaning method
2
Which coefficient measures correlation?
  1. A.Pearson coefficient
  2. B.Regression slope
  3. C.Standard deviation
  4. D.Variance ratio
3
What does a correlation of 1 indicate?
  1. A.No relationship
  2. B.Perfect positive correlation
  3. C.Perfect negative correlation
  4. D.Causal relationship
4
Which value indicates no correlation?
  1. A.0
  2. B.1
  3. C.-1
  4. D.0.5
5
What does a negative correlation imply?
  1. A.One variable increases as another decreases
  2. B.Both variables increase together
  3. C.No relationship exists
  4. D.One variable causes another
6
Which tool calculates correlation?
  1. A.Python’s numpy.corrcoef
  2. B.Bar chart
  3. C.Pie chart
  4. D.Box plot
7
What does a correlation of -0.8 suggest?
  1. A.Weak positive correlation
  2. B.Strong negative correlation
  3. C.No correlation
  4. D.Causal link
8
Which type of data is needed for Pearson correlation?
  1. A.Categorical data
  2. B.Numerical data
  3. C.Text data
  4. D.Binary data
9
What does correlation measure?
  1. A.Strength and direction of a relationship
  2. B.Cause and effect
  3. C.Data variability
  4. D.Data frequency
10
Which correlation is non-linear?
  1. A.Pearson correlation
  2. B.Spearman correlation
  3. C.Linear regression
  4. D.Variance analysis
11
What does a correlation of 0.3 indicate?
  1. A.Strong positive correlation
  2. B.Weak positive correlation
  3. C.No correlation
  4. D.Strong negative correlation
12
Which visualization shows correlation?
  1. A.Histogram
  2. B.Scatter plot
  3. C.Pie chart
  4. D.Bar graph
13
What is a limitation of correlation?
  1. A.Ignores causation
  2. B.Requires large datasets
  3. C.Only works with text data
  4. D.Measures variability
14
Which correlation method uses ranks?
  1. A.Pearson
  2. B.Spearman
  3. C.Kendall
  4. D.Linear
15
What does a high positive correlation show?
  1. A.Variables move oppositely
  2. B.Variables move together
  3. C.No relationship
  4. D.One causes the other
16
Which software computes correlation?
  1. A.Excel’s CORREL function
  2. B.Word processor
  3. C.Image editor
  4. D.Web scraper
17
What does correlation not imply?
  1. A.Association
  2. B.Causation
  3. C.Direction
  4. D.Strength
18
Which data type suits Kendall correlation?
  1. A.Ordinal data
  2. B.Nominal data
  3. C.Text data
  4. D.Binary data
19
What does a correlation near 0 suggest?
  1. A.Strong relationship
  2. B.Weak or no relationship
  3. C.Perfect correlation
  4. D.Causal link
20
Which is a use of correlation in EDA?
  1. A.Identify variable relationships
  2. B.Clean missing data
  3. C.Create dashboards
  4. D.Store datasets
21
What does a correlation of -1 mean?
  1. A.No correlation
  2. B.Perfect negative correlation
  3. C.Weak correlation
  4. D.Positive correlation
22
Which factor affects correlation accuracy?
  1. A.Data outliers
  2. B.Visualization type
  3. C.Data storage
  4. D.Report format
23
What does correlation analysis help with?
  1. A.Predicting causation
  2. B.Exploring associations
  3. C.Formatting data
  4. D.Sharing reports
24
Which correlation ranges from -1 to 1?
  1. A.Pearson correlation
  2. B.Regression coefficient
  3. C.Variance measure
  4. D.Mode calculation
25
What does a scatter plot with tight clustering indicate?
  1. A.No correlation
  2. B.Strong correlation
  3. C.Causation
  4. D.Weak correlation
26
Which correlation is robust to outliers?
  1. A.Pearson
  2. B.Spearman
  3. C.Linear
  4. D.Variance
27
What does correlation assess?
  1. A.Data quality
  2. B.Variable interdependence
  3. C.Data frequency
  4. D.Data cleaning
28
Which is a common correlation error?
  1. A.Assuming causation
  2. B.Ignoring outliers
  3. C.Using visuals
  4. D.Cleaning data
29
What does a loose scatter plot suggest?
  1. A.Strong correlation
  2. B.Weak correlation
  3. C.Perfect correlation
  4. D.Causal relationship
30
Which method measures monotonic relationships?
  1. A.Pearson
  2. B.Spearman
  3. C.Linear regression
  4. D.Standard deviation
31
What is causation in data analysis?
  1. A.A statistical association
  2. B.A cause-and-effect relationship
  3. C.A visualization method
  4. D.A data transformation
32
Which is required to prove causation?
  1. A.Correlation analysis
  2. B.Controlled experiments
  3. C.Scatter plots
  4. D.Data cleaning
33
What does causation imply?
  1. A.Variables are unrelated
  2. B.One variable influences another
  3. C.Data is correlated
  4. D.Data is visualized
34
Which is a challenge in proving causation?
  1. A.Measuring correlation
  2. B.Confounding variables
  3. C.Creating charts
  4. D.Collecting data
35
What is a common causation error?
  1. A.Ignoring correlation
  2. B.Assuming correlation is causation
  3. C.Using scatter plots
  4. D.Cleaning datasets
36
Which method helps establish causation?
  1. A.Randomized control trials
  2. B.Correlation coefficients
  3. C.Bar charts
  4. D.Data aggregation
37
What does causation require?
  1. A.Strong correlation
  2. B.Evidence of influence
  3. C.Weak association
  4. D.Visual patterns
38
Which is an example of causation?
  1. A.Rain causes wet streets
  2. B.Ice cream sales correlate with summer
  3. C.Height correlates with weight
  4. D.Data correlates with time
39
What can mislead about causation?
  1. A.High correlation
  2. B.Data cleaning
  3. C.Visualization tools
  4. D.Data storage
40
Which factor complicates causation?
  1. A.Third-party variables
  2. B.Scatter plots
  3. C.Data formats
  4. D.Report designs
41
What is needed to confirm causation?
  1. A.Observational studies only
  2. B.Experimental design
  3. C.Correlation values
  4. D.Data visualization
42
Which is a sign of causation?
  1. A.Statistical association
  2. B.Direct influence
  3. C.Weak correlation
  4. D.Data patterns
43
What does causation analysis avoid?
  1. A.Data insights
  2. B.False conclusions
  3. C.Correlation study
  4. D.Data collection
44
Which study proves causation best?
  1. A.Cross-sectional study
  2. B.Controlled experiment
  3. C.Correlation analysis
  4. D.Data visualization
45
What does causation clarify?
  1. A.Data relationships
  2. B.Why outcomes occur
  3. C.Data frequency
  4. D.Data cleaning
46
Which is harder to prove?
  1. A.Correlation
  2. B.Causation
  3. C.Association
  4. D.Patterns
47
What can causation studies control?
  1. A.Data formats
  2. B.External factors
  3. C.Visualization types
  4. D.Data storage
48
Which is a causation requirement?
  1. A.Temporal precedence
  2. B.Weak correlation
  3. C.Data aggregation
  4. D.Scatter plots
49
What does causation analysis need?
  1. A.Simple correlations
  2. B.Rigorous testing
  3. C.Basic visuals
  4. D.Raw data
50
Which confuses correlation with causation?
  1. A.Observational data misinterpretation
  2. B.Controlled experiments
  3. C.Data cleaning
  4. D.Visualization design
51
What does causation establish?
  1. A.Data patterns
  2. B.Direct impact
  3. C.Weak links
  4. D.Data formats
52
Which is critical for causation?
  1. A.Eliminating confounders
  2. B.Measuring correlation
  3. C.Creating charts
  4. D.Collecting data
53
What does causation help predict?
  1. A.Data trends
  2. B.Outcome changes
  3. C.Data errors
  4. D.Data storage
54
Which study avoids causation errors?
  1. A.Correlation study
  2. B.Experimental study
  3. C.Observational study
  4. D.Data visualization
55
What does causation require beyond correlation?
  1. A.Visual evidence
  2. B.Causal evidence
  3. C.Data cleaning
  4. D.Data patterns
56
What is the purpose of the `SELECT` statement in SQL?
  1. A.To create a new database
  2. B.To update existing records in a table
  3. C.To retrieve data from one or more tables
  4. D.To delete records from a table
57
Which SQL clause is used to specify which table to retrieve data from?
  1. A.`SELECT`
  2. B.`FROM`
  3. C.`WHERE`
  4. D.`ORDER BY`
58
Which SQL keyword is used to filter the records in a query based on a condition?
  1. A.`SELECT`
  2. B.`FROM`
  3. C.`WHERE`
  4. D.`ORDER BY`
59
Which clause is used to sort the result set in SQL?
  1. A.`WHERE`
  2. B.`ORDER BY`
  3. C.`GROUP BY`
  4. D.`HAVING`
60
In which clause is the `HAVING` keyword used?
  1. A.After `GROUP BY`
  2. B.Before `GROUP BY`
  3. C.After `ORDER BY`
  4. D.Before `FROM`
61
What is the correct SQL syntax for filtering records after grouping them?
  1. A.`WHERE`
  2. B.`GROUP BY`
  3. C.`HAVING`
  4. D.`ORDER BY`
62
Which of the following joins retrieves records that have matching values in both tables?
  1. A.`LEFT JOIN`
  2. B.`RIGHT JOIN`
  3. C.`FULL JOIN`
  4. D.`INNER JOIN`
63
Which SQL join returns all records from the left table and matching records from the right table?
  1. A.`INNER JOIN`
  2. B.`RIGHT JOIN`
  3. C.`LEFT JOIN`
  4. D.`FULL JOIN`
64
Which SQL join returns all records from the right table and matching records from the left table?
  1. A.`LEFT JOIN`
  2. B.`RIGHT JOIN`
  3. C.`INNER JOIN`
  4. D.`FULL JOIN`
65
Which SQL join returns all records from both tables, with matching rows from both sides where available?
  1. A.`LEFT JOIN`
  2. B.`RIGHT JOIN`
  3. C.`FULL JOIN`
  4. D.`INNER JOIN`
66
What is the purpose of the `GROUP BY` clause in SQL?
  1. A.To arrange the rows in the result set
  2. B.To group rows that have the same values in specified columns
  3. C.To sort the result set
  4. D.To filter the records based on conditions
67
Which SQL clause is used with aggregate functions like COUNT, SUM, AVG, etc.?
  1. A.`ORDER BY`
  2. B.`WHERE`
  3. C.`GROUP BY`
  4. D.`HAVING`
68
What does the `ORDER BY` clause do?
  1. A.Filters data
  2. B.Groups data
  3. C.Sorts the result set
  4. D.Retrieves data from a table
69
Which of the following aggregate functions is used to calculate the average of a set of numeric values?
  1. A.`SUM()`
  2. B.`AVG()`
  3. C.`COUNT()`
  4. D.`MAX()`
70
Which of the following SQL keywords is used to remove duplicates from the result set?
  1. A.`DISTINCT`
  2. B.`GROUP BY`
  3. C.`UNION`
  4. D.`HAVING`
71
What is the default sorting order in the `ORDER BY` clause?
  1. A.Ascending
  2. B.Descending
  3. C.Random
  4. D.Alphabetical
72
Which of the following is the correct SQL syntax to combine the result set of two SELECT queries, excluding duplicates?
  1. A.`SELECT * FROM table1 UNION SELECT * FROM table2`
  2. B.`SELECT * FROM table1 INNER JOIN table2`
  3. C.`SELECT * FROM table1 LEFT JOIN table2`
  4. D.`SELECT * FROM table1 FULL JOIN table2`
73
Which of the following SQL functions returns the number of rows in a table?
  1. A.`SUM()`
  2. B.`COUNT()`
  3. C.`AVG()`
  4. D.`MAX()`
74
Which of the following clauses is used to retrieve unique records from a query result?
  1. A.`DISTINCT`
  2. B.`GROUP BY`
  3. C.`HAVING`
  4. D.`WHERE`
75
How do you write a SQL query to retrieve records with `price` greater than 100 and less than 500?
  1. A.`SELECT * FROM products WHERE price > 100 AND price < 500`
  2. B.`SELECT * FROM products WHERE price BETWEEN 100 AND 500`
  3. C.`SELECT * FROM products WHERE price IN (100, 500)`
  4. D.`SELECT * FROM products WHERE price = 100 TO 500`
76
Which SQL clause is used to apply a filter to the result set after grouping records?
  1. A.`WHERE`
  2. B.`HAVING`
  3. C.`ORDER BY`
  4. D.`DISTINCT`
77
What will be the result of the following SQL query: `SELECT COUNT(*) FROM orders WHERE status = 'Shipped'`?
  1. A.It will return the sum of orders with the status 'Shipped'
  2. B.It will return the total number of orders with the status 'Shipped'
  3. C.It will return the highest order number
  4. D.It will return a list of all shipped orders
78
What does the `INNER JOIN` keyword do in SQL?
  1. A.Returns only unmatched rows from both tables
  2. B.Returns all rows from both tables
  3. C.Returns only matching rows from both tables
  4. D.Returns all rows from the left table and matching rows from the right table
79
Which SQL clause is used to eliminate duplicate records from the result set?
  1. A.`GROUP BY`
  2. B.`WHERE`
  3. C.`DISTINCT`
  4. D.`ORDER BY`
80
Which SQL function is used to find the highest value in a column?
  1. A.`SUM()`
  2. B.`MAX()`
  3. C.`MIN()`
  4. D.`AVG()`
81
What does the `LEFT JOIN` keyword do in SQL?
  1. A.Returns only the matching rows from both tables
  2. B.Returns all rows from the right table
  3. C.Returns all rows from the left table and matching rows from the right table
  4. D.Returns all rows from both tables
82
Which SQL keyword is used to combine the result of two `SELECT` queries while removing duplicates?
  1. A.`INNER JOIN`
  2. B.`UNION`
  3. C.`LEFT JOIN`
  4. D.`FULL JOIN`
83
What does the `WHERE` clause do in SQL?
  1. A.Specifies the order of rows in the result set
  2. B.Groups rows based on common values
  3. C.Filters rows based on conditions
  4. D.Specifies the table to retrieve data from
84
Which clause is used in SQL to group rows based on a column and apply aggregate functions like `SUM`, `COUNT`, etc.?
  1. A.`WHERE`
  2. B.`GROUP BY`
  3. C.`HAVING`
  4. D.`ORDER BY`
85
Which of the following SQL queries will return the second highest salary from the `employees` table?
  1. A.`SELECT MAX(salary) FROM employees WHERE salary NOT IN (SELECT MAX(salary) FROM employees)`
  2. B.`SELECT MIN(salary) FROM employees WHERE salary NOT IN (SELECT MAX(salary) FROM employees)`
  3. C.`SELECT MAX(salary) FROM employees`
  4. D.`SELECT salary FROM employees LIMIT 1 OFFSET 1`
86
What is the purpose of the `FULL JOIN` keyword in SQL?
  1. A.To return only matching rows from both tables
  2. B.To return all rows from both tables, with nulls in places where there is no match
  3. C.To return all rows from the left table
  4. D.To return all rows from the right table
87
What does the `SELECT DISTINCT` statement do?
  1. A.Retrieves all columns from the table
  2. B.Retrieves unique values from the specified column
  3. C.Deletes duplicate rows from the table
  4. D.Retrieves rows based on a condition
88
Which SQL clause is used to define the conditions to filter rows after performing a `GROUP BY` operation?
  1. A.`HAVING`
  2. B.`WHERE`
  3. C.`ORDER BY`
  4. D.`DISTINCT`
89
Which of the following statements correctly joins two tables, `employees` and `departments`, based on a common `department_id` column?
  1. A.`SELECT * FROM employees JOIN departments ON employees.department_id = departments.department_id`
  2. B.`SELECT * FROM employees, departments WHERE employees.department_id = departments.department_id`
  3. C.`SELECT * FROM employees INNER JOIN departments ON employees.department_id = departments.department_id`
  4. D.All of the above
90
Which SQL keyword is used to retrieve data from multiple tables based on matching values?
  1. A.`JOIN`
  2. B.`UNION`
  3. C.`SELECT`
  4. D.`INSERT`
91
Which SQL function is used to calculate the total sum of a numeric column?
  1. A.`COUNT()`
  2. B.`SUM()`
  3. C.`AVG()`
  4. D.`MAX()`
92
What does the `LIMIT` clause do in SQL?
  1. A.It restricts the number of rows returned in a query result
  2. B.It groups the rows based on a column value
  3. C.It filters rows based on conditions
  4. D.It specifies the sorting order of rows
93
Which SQL statement retrieves the top 5 employees with the highest salaries?
  1. A.`SELECT * FROM employees ORDER BY salary DESC LIMIT 5`
  2. B.`SELECT * FROM employees WHERE salary > 5`
  3. C.`SELECT * FROM employees ORDER BY salary ASC LIMIT 5`
  4. D.`SELECT * FROM employees WHERE salary IN (TOP 5)`
94
What does the `COUNT(*)` function do in SQL?
  1. A.Counts the total number of rows in a table
  2. B.Counts the number of unique rows
  3. C.Sums the values of a column
  4. D.Calculates the average value of a column
95
How do you write a SQL query to fetch all columns from the `students` table where the `age` is greater than 18?
  1. A.`SELECT * FROM students WHERE age > 18`
  2. B.`SELECT age FROM students WHERE age > 18`
  3. C.`SELECT * FROM students AND age > 18`
  4. D.`SELECT students WHERE age > 18`
96
Which of the following statements will return the average salary from the `employees` table?
  1. A.`SELECT AVG(salary) FROM employees`
  2. B.`SELECT SUM(salary) FROM employees`
  3. C.`SELECT MAX(salary) FROM employees`
  4. D.`SELECT MIN(salary) FROM employees`
97
Which SQL clause is used to sort the result set based on a specified column?
  1. A.`WHERE`
  2. B.`ORDER BY`
  3. C.`GROUP BY`
  4. D.`HAVING`
98
Which of the following aggregate functions in SQL returns the total number of rows in a table?
  1. A.SUM
  2. B.COUNT
  3. C.AVG
  4. D.MAX
99
What does the SQL `SUM()` function do?
  1. A.Returns the average of values
  2. B.Returns the sum of a numeric column
  3. C.Returns the count of rows
  4. D.Returns the minimum value in a column
100
Which aggregate function would you use to find the highest value in a numeric column?
  1. A.COUNT
  2. B.MAX
  3. C.MIN
  4. D.AVG