Scribd
Upload
40 views3 pages

Ekak Innovations Interview Questions

The document contains a set of interview questions and answers for Ekak Innovations, covering topics in Python, SQL, Machine Learning, and Databases. Key Python concepts include decorators, lists vs. tuples, and features of the language. SQL questions address query writing, normalization, and the differences between WHERE and HAVING, while Machine Learning focuses on overfitting, supervised vs. unsupervised learning, and the bias-variance trade-off.

Uploaded by

anurag152agarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
40 views3 pages

Ekak Innovations Interview Questions

The document contains a set of interview questions and answers for Ekak Innovations, covering topics in Python, SQL, Machine Learning, and Databases. Key Python concepts include decorators, lists vs. tuples, and features of the language. SQL questions address query writing, normalization, and the differences between WHERE and HAVING, while Machine Learning focuses on overfitting, supervised vs. unsupervised learning, and the bias-variance trade-off.

Uploaded by

anurag152agarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Interview Questions for Ekak Innovations

Python Questions

Q: What are Python's key features?

A: - Interpreted and dynamically typed

- High-level language with simple syntax

- Extensive standard libraries and third-party modules

- Supports OOP and functional programming

- Portable and cross-platform

Q: What is the difference between a list and a tuple in Python?

A: List: Mutable, uses []

Tuple: Immutable, uses ()

Performance: Tuples are faster

Q: What is a Python decorator?

A: A decorator is a function that modifies the behavior of another function without changing its code.

Example:

@decorator

def greet():

print('Hello!')

SQL Questions

Q: What is the difference between WHERE and HAVING?

A: - WHERE filters rows before grouping.


Interview Questions for Ekak Innovations

- HAVING filters after GROUP BY.

Q: Write a query to get the second highest salary from an Employee table.

A: SELECT MAX(salary) FROM Employee WHERE salary < (SELECT MAX(salary) FROM Employee);

Q: Explain normalization.

A: Normalization reduces redundancy.

1NF: Atomic values

2NF: No partial dependency

3NF: No transitive dependency

Machine Learning Questions

Q: What is overfitting and how to prevent it?

A: Overfitting: Model fits training data too well.

Prevention: Cross-validation, regularization, pruning, more data

Q: Difference between supervised and unsupervised learning?

A: Supervised: Labeled data (e.g., classification)

Unsupervised: Unlabeled data (e.g., clustering)

Q: What is the bias-variance trade-off?

A: Bias: Error from wrong assumptions

Variance: Sensitivity to training data


Interview Questions for Ekak Innovations

Goal: Balance both for generalization

Database Questions

Q: What is ACID in databases?

A: Atomicity, Consistency, Isolation, Durability - ensure reliable transaction processing

Q: What is indexing? How does it improve performance?

A: Indexing speeds up data retrieval (e.g., via B-trees), improving SELECT performance.

Q: Explain the difference between INNER JOIN and LEFT JOIN.

A: INNER JOIN: Returns matching rows

LEFT JOIN: Returns all rows from left table, plus matched from right

You might also like