Roche Diagnostics Interview Questions, Process, and Tips

Asked me to sort array 30 discussion how many hair cuts in 1year in india

Q1. What is web socket
Ans. 
Web socket is a communication protocol that provides full-duplex communication channels over a single TCP connection.
• Web socket allows for real-time, bi-directional communication between a client and a server.

• It is commonly used in applications that require live updates, such as chat applications or online gaming.

• Web socket connections are initiated through a handshake process and can remain open for as long as needed.

• ...read more
Answered by AI
Add your answer
Q2. How many haircuts in india in 24 hours
Ans. 
It is impossible to accurately determine the number of haircuts in India in 24 hours without specific data.
• The number of haircuts in India in 24 hours would depend on the population, number of hair salons, and average time taken for a haircut.

• Factors such as holidays, weekends, and special events could also affect the number of haircuts in a day.

• Without concrete data on the above factors, it is not possible to provide
Answered by AI
Add your answer
Q3. Auth2 vs jwt explain in detail
Ans. 
OAuth2 is an authorization framework while JWT is a token format for authentication.
• OAuth2 is an authorization framework used for delegated access to resources.

• JWT is a token format that can be used for authentication and information exchange.

• OAuth2 involves obtaining an access token from an authorization server.

• JWT is a self-contained token that contains user information and can be verified without querying a database...read more
Answered by AI
Add your answer
Q4. How ssl works and proxy works
Ans. 
SSL works by encrypting data transmitted between a client and server, while a proxy acts as an intermediary for requests.
• SSL (Secure Sockets Layer) encrypts data transmitted between a client and server to ensure privacy and security.

• SSL uses cryptographic protocols to establish a secure connection, typically using public key infrastructure (PKI).

• A proxy server acts as an intermediary between a client and server, forwar...read more
Answered by AI
Add your answer

Q1. Tell me about current job responsibilities.
Ans. 
Currently responsible for overseeing team performance, developing strategies, and ensuring project deadlines are met.
• Leading a team of 10 employees in project management

• Developing and implementing strategies to improve efficiency

• Monitoring progress and ensuring deadlines are met

• Collaborating with other departments to achieve company goals
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why do you want to join Roche.
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. 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