Lauren Information Technologies Interview Questions and Answers

- 30 MCQ questions mostly related to HTML, JS & C#
- 2 easy-moderate coding questions

- Aptitude test on CoCubes (12 mins)
- English Test (speaking + writing + reading + listening) on Pearson platform

Q1. Print the following pattern: (was asked to complete test execution within 10 mins) ****4 ***444 **44444 *4444444 444444444
Add your answer
Q2. Find the length of longest substring composed of same digit, within a string of digits: (was asked to complete within 10 mins) E.g. 01241XXXXX901111 Output: 4 Explanation: "1111" is the longest substring
Ans. 
Find the length of longest substring composed of same digit within a string of digits.
• Iterate through the string and keep track of the current digit and its count

• Update the maximum count whenever a new digit is encountered

• Return the maximum count
Answered by AI
View 3 more answers
Q3. An SQL SPROC that is supposed to return tabular data is running slowly, what are the different ways you could debug it?
Ans. 1. Check for unnecessary columns in SELECT statement 2. Check if there's any cursor present in the SPROC 3. Check if columns have been properly indexed (specifically the columns being used in ORDER BY) 4. Check if data is being paged 5. etc.
Answered Anonymously
View 1 more answer
Q4. An API is running slow. Upon investigation it was found that SPROC running behind it is perfectly optimized. How can you debug this behavior of API? (You can neglect the resolve time & connect time of the ...read more
Ans. 
To debug the slow behavior of the API, analyze network latency, check for database issues, monitor server performance, and review code for potential bottlenecks.
• Analyze network latency to identify any issues with data transmission.

• Check for database issues such as slow queries or insufficient indexing.

• Monitor server performance to ensure it has enough resources and is not overloaded.

• Review the code for potential bottle...read more
Answered by AI
View 2 more answers

Q1. Check if two strings are anagrams of each other. Follow up question: solve it in O(N) time. (Time limit to solve question: 10 mins)
View 1 more answer
Q2. Given Tables: 1. Authors (AuthorId PK, Name) 2. Books (BookId PK, AuthorId FK, Name) 3. Orders (OrderId PK, BookID FK, AuthorId FK, StoreName) Write SQL query to print following information for each autho...read more
Add your answer
Q3. Questions about an open source distributive caching project that I implemented. Wanted to know what flaws do I see in the project and how do I plan to resolve them. Few follow up questions regarding cachin...read more
Add your answer

Q1. Given an array of integers (both positive and negative) find the maximum and second maximum number without using sort and using only single loop.
Ans. 
Find maximum and second maximum number in an array without using sort and single loop.
• Initialize max and secondMax variables to the smallest possible integer value

• Iterate through the array and update max and secondMax accordingly

• Return max and secondMax as the result
Answered by AI
View 1 more answer
Q2. Given Table: Weather (CityName, Date, Temperature) Write an SQL query which prints the following: "CityName, Today's Temperature, Yesterday's Temprature" (if yesterday's temperature doesn't exist, then p...read more
Add your answer
Q3. Given Table: ExamResults (StudentName, SubjectName, Marks) Write an SQL query to print the following: 1. "Student Name, Percentage" (Marks are out of 100) 2. List of all students having percentage great...read more
Add your answer

Q1. Basics logics of code.
Add your answer

Q1. Just be confident and calmly give ans with positive outcomes.
Add your answer