Samsung Electro-Mechanics Machine Learning Scientist - Big Data/NLP Interview Questions and Answers

Q1. Normalization in SQL, What is Cursor in SQL
Ans. 
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity. A cursor in SQL is a database object used to retrieve and manipulate data row by row.
• Normalization in SQL involves breaking down a large table into smaller tables and defining relationships between them to reduce redundancy.

• Cursors in SQL are used to fetch and process individual rows returned by a query...read more
Answered by AI
View 1 more answer
Q2. .Net Core and API based questions
Add your answer
Q3. Abstract and interface difference
Ans. 
Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.
• Abstract classes can have constructors, fields, and non-abstract methods along with abstract methods

• Interfaces can only have abstract methods and constants

• A class can implement multiple interfaces but can only inherit from one abstract class
Answered by AI
View 1 more answer
Q4. Const and read only difference in C#
Ans. 
Const keyword is used to declare constants at compile time, while read-only keyword is used to create immutable fields that can only be assigned a value at runtime.
• Const values are determined at compile time and cannot be changed, while read-only values can only be assigned a value once at runtime.

• Const fields are implicitly static, while read-only fields are not.

• Example: const int x = 5; read-only int y = 10;
Answered by AI
Add your answer
Q5. Azure basic fundamental questions
Add your answer
Q6. Sample query to join tables using SQL
Ans. 
Sample query to join tables using SQL
• Use the JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to be selected from each table

• Use the ON keyword to specify the join condition
Answered by AI
Add your answer

There were 4 sections and first one was quant, second one was logical, third was English and finally 3 coding questions in last section

4 codes and 5 technical questions

Q1. Explain multi threading
Ans. 
Multi threading is the ability of a CPU to execute multiple threads concurrently.
• Allows for parallel execution of tasks, improving performance

• Each thread has its own stack and runs independently

• Threads can communicate and synchronize using shared memory

• Examples: running multiple tasks simultaneously in a web server, processing data in parallel
Answered by AI
Add your answer
Q2. What is polymorphism
Ans. 
Polymorphism is the ability of a single function or method to operate on different types of data.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• It enables a single interface to be used for different data types.

• Examples include method overloading and method overriding in object-oriented programming.
Answered by AI
Add your answer
Q3. Diff b/w inner and outer joins
Ans. 
Inner join returns only the rows that have matching values in both tables, while outer join returns all rows from both tables.
• Inner join: returns rows with matching values in both tables

• Outer join: returns all rows from both tables, with NULL values where there is no match

• Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Example: Outer join - SELECT * FROM table1 LEFT OUTER JOIN table
Answered by AI
Add your answer

Aptitude test, quant, grammer, logical

Online sales vs offline sales

Q1. Tell me about your self
Add your answer
Q2. What have you done is your internship?
Ans. 
During my internship, I worked on developing sales strategies, conducting market research, and assisting with client presentations.
• Developed sales strategies to target new clients

• Conducted market research to identify potential leads

• Assisted in creating and delivering client presentations

• Collaborated with the sales team to analyze sales data and trends
Answered by AI
Add your answer

Q1. Basic and advanced concepts
Add your answer

Q1. Average difficult level and covered everything from basics
Add your answer

Q1. It was very friendly discussion to test our communications skills and team handling activities etc
Add your answer

Q1. Again technical round to cover scenario based questions
Add your answer

Topic given you need to stand out

Case study given regarding marketing opportunity

Q1. Interview taken
Add your answer

Data structures, linq and .net core related questions

Q1. Angular and .net core related questions
Add your answer

Q1. About salary discussion
Add your answer