JCB Senior Tech Interview Questions and Answers

Q1. Spark question on optimization
Add your answer
Q2. SQL writting and optimization
Add your answer

Hackerearth problem on reversing the string & one more array question

Q1. Reverse the string
Ans. 
Reverse a given string
• Use built-in functions like reverse() in Python

• Iterate through the string in reverse order and append characters to a new string

• Use stack data structure to reverse the string
Answered by AI
Add your answer
Q2. SQL based windowing function
Add your answer

Q1. Data warehouse concepts
Add your answer

Topic is social media impact on personal relationships.

Q1. They asked sql queries, oops, ml concepts
Add your answer
Q2. What you know about Encapsulation?
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for better control over the data by preventing outside interference.

• Encapsulation is achieved in object-oriented programming languages through the use of classes and access modifiers.

• For example, in Java, you can use pr...read more
Answered by AI
Add your answer

Python DSA Leetcode style questions, prepare.

Just focus on the basics of pyspark.

Sql questions and python logics

Q1. About sql and python
Add your answer
Q2. Hadoop and kinit
Add your answer

Q1. Normalisation of database, views,stored procedures
Ans. 
Normalization is a process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a table into smaller tables and defining relationships between them.

• It helps in reducing data redundancy and inconsistencies.

• Views are virtual tables that are created based on the result of a query. They can be used to simplify complex queries.

• Stored procedures are precompiled...read more
Answered by AI
Add your answer