Sd Biosensor Healthcare R&D Executive Interview Questions and Answers

Basics of java and aome advance level java and also wotk on some data structure . In case you are expirenced be clear with your projects. Be prepared for the manegerial round also .

Basic programms like reversal of string.

Q1. Manegerial round along with system designing some behaviourial questions were also there System design questions
Ans. Practice concepts like indexing and pratitioning ,queations may be asked abt it
Answered Anonymously
Add your answer
Q2. Knowledge of azure and power bi is additional
Add your answer

Nice aptitude questions of logical reasons and data interpretation

Q1. Why should we hire you?
Add your answer
Q2. What does your previous colleagues describe you?
Add your answer
Q3. Self introduction
Add your answer
Q4. General questions from resume
Add your answer

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

RESEARCH ASSIGNMENT ON THE TB SPACE

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are applied to a set of rows related to the current row in a query result.

• They can be used to calculate running totals, averages, ranks, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. How do you find the code performance issue in the code deployed in production?
Ans. 
To find code performance issues in production, use monitoring tools and profiling techniques.
• Use monitoring tools like New Relic, AppDynamics, or Datadog to track performance metrics and identify bottlenecks.

• Use profiling techniques like CPU profiling, memory profiling, and network profiling to pinpoint specific areas of the code that are causing performance issues.

• Analyze logs and error messages to identify patterns a...read more
Answered by AI
View 1 more answer
Q2. What is asynchronous programming
Ans. 
Asynchronous programming is a programming paradigm that allows multiple tasks to run concurrently without blocking each other.
• Asynchronous programming is used to improve the performance of applications that require a lot of I/O operations.

• It involves the use of callbacks, promises, and async/await keywords in JavaScript.

• Asynchronous programming can be used in both front-end and back-end development.

• Examples of asynchro...read more
Answered by AI
Add your answer
Q3. Write a program to change background after every 0.5 sec interval to orange,white,green on button click in Angular?
Ans. 
Program to change background color on button click in Angular
• Create a button in Angular template

• Add click event listener to the button

• Use setInterval() function to change background color after every 0.5 sec

• Use ngStyle directive to change background color dynamically
Answered by AI
Add your answer
Q4. How to load a component only after 3 of my services are loaded?
Ans. 
Use Angular's 'resolve' property to load component after services are loaded.
• Create a resolver service that waits for all three services to complete before resolving.

• Add the resolver service to the 'resolve' property of the component's route.

• Access the resolved data in the component using the ActivatedRoute service.

• Example: { path: 'my-component', component: MyComponent, resolve: { data: MyResolverService } }
Answered by AI
Add your answer
Q5. What is difference between iquerable and ienumrable
Ans. 
IQueryable is for querying data from a source that implements IQueryable interface while IEnumerable is for iterating over a collection of data.
• IQueryable is used for deferred execution while IEnumerable is used for immediate execution.

• IQueryable is used for querying data from a remote data source while IEnumerable is used for querying data from an in-memory collection.

• IQueryable is more efficient for large datasets as...read more
Answered by AI
Add your answer
Q6. When you go with entity framework and ado.net
Ans. 
Entity Framework is an ORM while ADO.NET is a data access technology.
• Entity Framework is easier to use and provides more abstraction than ADO.NET.

• ADO.NET is faster and more flexible than Entity Framework.

• Use Entity Framework for simple CRUD operations and ADO.NET for complex queries and performance-critical applications.
Answered by AI
Add your answer