Schlumberger Interview Questions, Process, and Tips

If everyone is cheating you should also do it?

Q1. Everyhting about project..
Add your answer
Q2. Linear vs logistic regression
Ans. 
Linear regression is used for continuous variables, while logistic regression is used for binary outcomes.
• Linear regression is used to predict a continuous outcome based on one or more input variables.

• Logistic regression is used to predict the probability of a binary outcome based on one or more input variables.

• Linear regression assumes a linear relationship between the independent and dependent variables, while logist...read more
Answered by AI
Add your answer
Q3. Normalization in dbms
Ans. 
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables and establishing relationships between them.

• It helps in reducing data redundancy, minimizing data anomalies, and improving data consistency.

• There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with spec...read more
Answered by AI
Add your answer
Q4. List array difference etc
Ans. 
Array difference is finding the elements that are present in one array but not in another.
• Use set operations like difference to find elements in one array but not in another.

• Example: arr1 = ['a', 'b', 'c'], arr2 = ['b', 'c', 'd'], arr_diff = set(arr1) - set(arr2) = ['a']
Answered by AI
Add your answer

Just easy or medium level leetcode questions

The topic was how AI is affecting softare developer

Q1. SQL table distributions.
Add your answer
Q2. ADF switching questions?
Add your answer
Q3. How do you optimize the performance?
Ans. 
Performance optimization in data engineering involves tuning queries, indexing, partitioning, and utilizing appropriate hardware.
• Tune queries by optimizing SQL code, using appropriate joins, and avoiding unnecessary operations.

• Utilize indexing to speed up data retrieval by creating indexes on frequently queried columns.

• Partition data to distribute it across multiple nodes or servers for parallel processing.

• Utilize appr...read more
Answered by AI
Add your answer
Q4. What is stored procedure?
Ans. 
A stored procedure is a set of SQL statements that can be saved and reused in a database management system.
• Stored procedures are used to perform a specific task or set of tasks in a database.

• They can accept input parameters and return output parameters.

• Stored procedures can improve performance by reducing the amount of data sent between the database and the application.

• They can also enhance security by controlling acce...read more
Answered by AI
Add your answer
Q5. Ranking functions in SQL?
Ans. 
Ranking functions in SQL are used to assign a rank to each row based on a specific criteria.
• Ranking functions include RANK(), DENSE_RANK(), and ROW_NUMBER()

• RANK() assigns a unique rank to each distinct row

• DENSE_RANK() assigns a unique rank to each distinct row without gaps

• ROW_NUMBER() assigns a unique sequential integer to each row
Answered by AI
Add your answer
Q6. Modelling questions.
Add your answer