ShieldSquare Interview Questions and Answers

Q1. SLQ basic questions
Add your answer
Q2. SQL Joins
Add your answer

Q1. SQL qeus to find 5th max salary of an employee from employee_table.
Add your answer
Q2. Find avg salary of employees for each department & order employee within a department by age.
Add your answer
Q3. Different between SLA & OLA
Add your answer
Q4. Views AND Triggers in SQL
Add your answer

Q1. SQL Functions, Range, Rank, Dense Rank questions
Add your answer
Q2. Ticket Management
Add your answer

Q1. Managerial Round
Add your answer
Q2. Work Experience
Add your answer

Q1. Compensation Discussion
Add your answer

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
Add your answer
Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
Ans. 
The query selects all columns and calculates the total amount for each customer in table t2.
• The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.

• The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.

• The 'select *' statement selects all columns from the table along with the calculated total amount.

• The 'sum(amt) over (partiti...read more
Answered by AI
Add your answer
Q3. How many Customers has purchased same item on the Same day more than onnce
Ans. 
To find customers who purchased the same item multiple times on the same day.
• Identify unique customers who purchased the same item multiple times on the same day

• Check for duplicate transactions by customer and item on the same day

• Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
Answered by AI
Add your answer

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

2 coding questions .
topics were array and string

Q1. 2D array question and a linkedlist question (find the middle element of the list)
Add your answer
Q2. Dbms questions like keys ,normalization, acid properties, types of network layer , deadlock in os
Add your answer

Q1. Detect loop in a linkedlist
Ans. 
Use Floyd's Tortoise and Hare algorithm to detect loop in a linked list.
• Initialize two pointers, slow and fast, at the head of the linked list.

• Move slow pointer by one step and fast pointer by two steps.

• If they meet at any point, there is a loop in the linked list.
Answered by AI
Add your answer
Q2. SQL queries basic level .
Add your answer

Q1. Oops questions like inheritance and interface
Add your answer
Q2. Sql queries from leetcode hard level
Add your answer

Q1. ACID Properties
Ans. 
ACID properties are a set of properties that guarantee reliable and consistent transactions in a database system.
• Atomicity ensures that either all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a valid state before and after the transaction.

• Isolation ensures that the concurrent execution of transactions results in a system state that would be obtai...read more
Answered by AI
Add your answer
Q2. What are Idempotent HTTP Requests?
Ans. 
Idempotent HTTP requests are requests that can be repeated multiple times without changing the result beyond the initial request.
• Idempotent requests have the same outcome no matter how many times they are executed.

• GET, PUT, and DELETE HTTP methods are typically idempotent.

• POST requests are not idempotent as they can create new resources with each execution.
Answered by AI
Add your answer
Q3. Questions regarding your project, and how did you learn from the projects and tasks assigned to you?
Add your answer
Q4. System Design
Add your answer

Q1. About yourself, your past work experience and why you want to get into this role The interviewer was very calm and just wanted to learn about the background.
Add your answer

Q1. All behavioural questions- 1 how do your prioritise your work? 2 do you have experience in managing cross functional teams? 3 what if one of your Co-worker decline working on a project, How would you tackl...read more
Add your answer

Q1. Again all behavioural questions- How do you work with large volume of works? How do you manage work life balance? How do you give harsh feedbacks to your coworkers?
Add your answer

Q1. All behavioural questions again- same as above just a bit here and there asked in different ways
Add your answer

Q1. Questions related to devops tools such as azure terraform kubernetes.
Add your answer
Q2. Java concurrency and exception handling
Add your answer

Q1. Why do you want to join this organization?
Ans. 
I am impressed by the company's innovative approach to DevOps and its commitment to continuous improvement.
• I am excited about the opportunity to work with cutting-edge technologies and tools in a collaborative environment.

• I admire the company's strong reputation for fostering professional growth and development.

• I believe my skills and experience align well with the organization's goals and values.
Answered by AI
Add your answer
Q2. Expected salary
Ans. 
My expected salary is based on my experience, skills, and the market rate for Devops Engineers.
• I have researched the average salary range for Devops Engineers in this location.

• I am looking for a competitive salary that reflects my expertise and contributions.

• I am open to discussing salary based on the overall compensation package offered.
Answered by AI
Add your answer

A 90-minute coding test on HackerRank, which includes one medium, one easy, and one hard question.

Q1. What is the index of the first occurrence where a pattern string matches with a text string?
Add your answer
Q2. Given a string, how can we find the minimum length substring whose sum is greater than or equal to a specified target?
Add your answer