Triple Point Technology Interview Questions and Answers

Q1. Java basics questions
Add your answer

Q1. Struts 1x questions and PL SQL
Add your answer

Q1. What are optimisation techniques in stored procedure
Ans. 
Optimisation techniques in stored procedures improve performance by reducing execution time and resource usage.
• Use proper indexing on tables involved in the stored procedure

• Minimize the use of cursors and loops

• Avoid using SELECT * and fetch only necessary columns

• Avoid using temporary tables if possible

• Use SET NOCOUNT ON to stop the message indicating the number of rows affected by a T-SQL statement
Answered by AI
Add your answer
Q2. Analyse the condition in query and optimise it.
Ans. 
The candidate is asked to analyse and optimize a given condition.
• Identify the key components of the condition and their interactions

• Consider potential areas for improvement or inefficiencies

• Propose specific changes or strategies to optimize the condition
Answered by AI
Add your answer

Q1. Integer Array rotation for K time
Ans. 
Rotate an integer array K times
• Create a temporary array to store elements that will be rotated

• Use modulo operator to handle cases where K is larger than array length

• Update the original array with elements from the temporary array
Answered by AI
Add your answer
Q2. Find the missing number in series of array of distinct numbers?
Ans. 
The missing number in a series of distinct numbers can be found by identifying the pattern and determining the missing element.
• Identify the pattern in the series of numbers.

• Determine the logic or rule governing the sequence.

• Apply the logic to find the missing number.

• Example: Series - 2, 4, 6, 10, 12, 14, Missing number is 8.
Answered by AI
Add your answer

There were 30 aptitude questions. Difficulty level was moderate.

Q1. Interview questions were basically from Java and SQL.
Add your answer

Q1. Asked about previous employments.
Add your answer

Graduation level aptitude test

Basic sdlc assignment

Q1. Basic sdlc questions
Add your answer

Basic Aptitude questions

SDLC Model, SQL and Advanced SQL questions, Case Study

Q1. Normal HR questions
Add your answer