DE Shaw Executive Assistant Interview Questions and Answers

Q1. Code any program in 2 languages
Ans. 
I can code a program in Python and Java.
• I am proficient in both Python and Java programming languages.

• I have experience in developing web applications using Python and Java frameworks.

• I can write efficient and optimized code in both languages.

• I can develop programs for data analysis, machine learning, and automation using Python.

• I can develop enterprise-level applications using Java.

• Examples: Python - a program to scra...read more
Answered by AI
Add your answer
Q2. Behavioral questions on why you want to join?
Add your answer

Q1. Ridge and lasso regression difference
Ans. 
Ridge and lasso regression are both regularization techniques used in linear regression to prevent overfitting by adding penalty terms to the cost function.
• Ridge regression adds a penalty term equivalent to the square of the magnitude of coefficients, while lasso regression adds a penalty term equivalent to the absolute value of the magnitude of coefficients.

• Ridge regression tends to shrink the coefficients towards zer...read more
Answered by AI
Add your answer
Q2. Random forest vs decision tree vs xg boost
Ans. 
Random forest is an ensemble method using multiple decision trees, XGBoost is a gradient boosting algorithm that builds trees sequentially.
• Random forest is an ensemble learning method that builds multiple decision trees and combines their predictions.

• Decision tree is a single tree model that makes decisions based on features to predict outcomes.

• XGBoost is a gradient boosting algorithm that builds trees sequentially, op...read more
Answered by AI
Add your answer

Q1. Why do you not want to opt for higher studies
Add your answer
Q2. What to do when a team member is not collaborating
Add your answer

Logical, statistics, Aptitude, Data science and analytics

Q1. Difference between Delete and Truncate in SQL
Ans. 
Delete removes specific rows from a table, while Truncate removes all rows from a table.
• Delete is a DML command, while Truncate is a DDL command.

• Delete can be rolled back, while Truncate cannot be rolled back.

• Delete maintains the table structure and indexes, while Truncate resets the table structure and indexes.

• Delete triggers delete triggers and delete constraints, while Truncate does not trigger any triggers or const...read more
Answered by AI
Add your answer
Q2. Assumptions of regression
Ans. 
Assumptions of regression
• Linearity: The relationship between the independent and dependent variables is linear.

• Independence: The residuals are independent of each other.

• Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.

• Normality: The residuals are normally distributed.

• No multicollinearity: The independent variables are not highly correlated with each other.
Answered by AI
Add your answer

General aptitude test on an online platform with camera and mic monitoring.

Q1. One on one round with manager and senior manager. Basic questions about day to day responsibilities and tech stack.
Add your answer

The Aptitude round was of mediocre level, get well prepared for it and it is a qualifying round

Q1. Project Related Questions
Add your answer
Q2. Data Warehouse and modeling related questions, along with schema selection in various scenarios
Add your answer

Q1. About Myself, Why Axtria, Pharma related questions
Add your answer
Q2. Real life scenarios
Add your answer

Q1. About IC design
Add your answer
Q2. Resume based questions
Add your answer

Q1. Two Sum leetcode question
Add your answer
Q2. Spring Framework interview questions
Add your answer
Q3. Java 8 in depth
Ans. 
Java 8 introduced several new features including lambda expressions, streams, and functional interfaces.
• Lambda expressions allow for more concise code by enabling functional programming.

• Streams provide a way to process collections of objects in a functional style.

• Functional interfaces are interfaces with a single abstract method, which can be implemented using lambda expressions.

• Java 8 also introduced the Optional clas
Answered by AI
Add your answer

Q1. Project Architecture based question
Add your answer