Add office photos
Filter interviews by
Yardi Systems SQL Developer Interview Questions and Answers for Freshers
1 interview found
I applied via Recruitment Consulltant and was interviewed in Jul 2023.
4 Interview Rounds
Resume Shortlist Round
Aptitude Test Round
Easy to medium Questions which contain Aptitude + Technical questions
Group Discussion Round
Group Discussion on random topic was done among 25-30 people
Technical Round (3 Questions)
- Q1. Asked Questions about Sql queries ,theory. Add Answer
- Q2. Sql theoritical questions Add Answer
- Q3. Ci/cd pipeline use case View Answers (1)
Interview Preparation Tips
- SQL
Skills evaluated in this interview
Interview questions from similar companies
Full Stack Software Developer Interview Questions
Cactus Communications
Anonymous
posted on 15 Oct 2024
Selected
I applied via Approached by Company and was interviewed before Oct 2023.
3 Interview Rounds
One-on-one Round (2 Questions)
- Q1. Explain Solid Principles View Answers (1)
- Q2. Explain Dependency InJection View Answers (1)
Technical Round (2 Questions)
- Q1. Explain Entity FrameWork or any Design Pattern View Answers (1)
- Q2. Explain Routing in Angular View Answers (1)
HR Round (2 Questions)
- Q1. What is your goal View Answers (1)
- Q2. What are your strenght and weaknes View Answers (1)
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Aug 2022.
3 Interview Rounds
Resume Shortlist Round
Technical Round (2 Questions)
- Q1. C# oops concept .net core Add Answer
- Q2. Sql server Database Add Answer
HR Round (3 Questions)
- Q1. Discussion of about of your company Add Answer
- Q2. Salary discussion And benefits Add Answer
- Q3. Features About of your company Add Answer
Interview Preparation Tips
CodingNinjas
I was interviewed in Dec 2020.
2 Interview Rounds
Coding Test Round (2 Questions)
Round duration - 60 minutes
Round difficulty - Medium
Hackerrank is a good paltform and very flexible, our webcam was turned on in order to prevent students from cheating
- Q1. Find the lone set bit You are given a single non-negative integer ‘N’ who’s binary representation consists of a single ‘1’ digit and the rest of the digits are ...read more View Answers (3)
- Q2. Count Ways To Reach The N-th Stairs You have been given a number of stairs. Initially, you are at the 0th stair, and you need to reach the Nth stair. Each time ...read more View Answers (4)
HR Round (1 Question)
Round duration - 40 minutes
Round difficulty - Hard
Round was conducted on zoom platform. There were 40 students there and then each one of them were assigned break-out rroms for interviews.
- Q1. Basic HR Questions
What are your future goals? Tell me about your short term and long-term goals.
What motivates you?
View Answers (1)
Interview Preparation Tips
Tip 1 : try to keep only those things in resume on which you have very good command and you should be able to answer all of the questions(upto moderate level) related to your technical skills
Tip 2 : mention your projects with brief description, try avoiding very high level description because some times reader might not be able to understand your work, keep it descriptive and understandable
Tip 1 : major team project is helpful
Tip 2 : list down only the related achievements with the role you are applying for
Skills evaluated in this interview
I was interviewed in Oct 2020.
3 Interview Rounds
Coding Test Round (1 Question)
Round duration - 90 minutes
Round difficulty - Easy
This round was scheduled for 9am in the morning. The test environment was pretty good . I didn't face any issues on the HireVeu platform. The first test was of Aptitude and then in next section it was Technical MCQ's. The level of questions were mid to high level of difficulty.
- Q1. DBMS Questions What is DML and DDL? Write an SQL query to print the FIRST_NAME from Worker table after replacing ‘a’ with ‘A’. Write an SQL query to print detai...read more View Answers (1)
Coding Test Round (1 Question)
Round duration - 60 minutes
Round difficulty - Medium
The exam was on the same Platform. The first question was about the most difficult Project I've worked on. I have to record a video in that particular platform and then move to the next questions. There was option for a demo video of 1 minute in which you can practice your answers and then can record your answer in the next video of max 5 minutes. The next 2 question were Coding Problems of moderate difficulty and you've to record your approach and then proceed towards solving the code and then record a video stating if you succeed or not and what better could you've done to make it work.
- Q1. Sum Of N Digit Palindromes You are given an integer 'N'. Your task is to return the sum of all N-digit numbers which are palindrome. A number is said to...read more View Answers (3)
Face to Face Round (2 Questions)
Round duration - 45 minutes
Round difficulty - Medium
This round was scheduled for 3pm. The interviewer was quite friendly. He asked about me and told me to relax and then answer. He started with asking questions from my Project and how the ideas behind the Project. My Project was related to Deadlock So he asked whether I can implement my Project on any environment. I answered . Then one of my internship Project was related to Web development so He asked me about the backend of the Project. He gave me a few SQL queries and some general DBMS concepts based on the response about using Mysql in the Project. He asked me a few things about AWS and Cloud Computing which I answered. At last he asked some LINUX commands and corrected me once and was satisfied with my answers.
- Q1. OS Questions 1) What is Kernel? 2) What is Deadlock? 3) Why you use Binary semaphores instead of Counting Semaphores? 4) What is threads? What is hardware threa...read more View Answers (1)
- Q2. DBMS & Trees Questions
1) Explain DDL VS DML.
2) Explain Normalization
3) B+ Trees and it's working.View Answers (1)
Interview Preparation Tips
Tip 1 : Practice at least 5-7 Codes daily from the beginning of preparation.
Tip 2 : Be thoroughly prepared with concepts of Data Structure, Database and Operating System
Tip 3 : Always go through the Company's Job description and About the Company and prepare your answers according to that
Tip 4 : Only mention Projects that you've complete idea about.
Tip 1 : Have a few Projects on your resume and make sure you know it all about your Projects.
Tip 2 : Only mention the Skills you feel you are confident about. Never lie on your resume.
Skills evaluated in this interview
I was interviewed before Sep 2020.
3 Interview Rounds
Coding Test Round (2 Questions)
Round duration - 150 Minutes
Round difficulty - Medium
This first round was the Online test which was 1 Hour 95 Minutes Long. It was Divided
as Follows.
1. Aptitude Section (Arithmetic + Analytical) 14 Questions – 26 Minutes
2. Technical MCQs( Computer Science) 14 Questions – 19 Minutes
3. Coding Question – 20 Minutes
4. Coding Question – 30 Minutes
5. Coding Questions :
- Q1. Water You are given an array 'ARR' of positive integers, each of which represents the number of liters of water in that particular bucket, we have to ma...read more View Answers (1)
- Q2. K Max Sum Combinations You are given two arrays/lists ‘A’ and ‘B’ of size ‘N’ each. You are also given an integer ‘K’. You have to find the ‘K’ maximum and vali...read more View Answers (2)
Video Call Round (1 Question)
Round duration - 150 Minutes
Round difficulty - Medium
This was an Online F2F Technical Round conducted on CodePair : Hackerrank. So, Basically You have to Run and Submit ( Pass All Test cases) in the Interview Round also (Like normal Coding Test) in Codepair: Hackerrank & along with that You should have to explain your Code and Approach to the Interviewers.
- Q1. Minimum Fountains There is a one-dimensional garden of length 'N'. On each of the positions from 0 to 'N', there is a fountain, and this fountai...read more View Answers (2)
Video Call Round (2 Questions)
Round duration - 150 Minutes
Round difficulty - Medium
This was also an Online F2F Technical Round conducted on Codepair : Hackerrank.
Dynamic Programming Based Not So Easy Level:
Best Time to Buy and Sell Stock
Best Time to Buy and Sell Stock II
Dynamic Programming Based Not So Medium Level
Best Time to Buy and Sell Stock with Cooldown
Best Time to Buy and Sell Stock with Transaction Fee
Dynamic Programming Based Hard Level
Best Time to Buy and Sell Stock III
Best Time to Buy and Sell Stock IV
They asked me a Lot of Questions like:
How did you arrive at this Solution ?
Why is this Approach Right ?
Can You do this in Better time & space complexities ? (Although I have done in Best time Complexity but they asked this to check my confidence level on my codes).
A lot of Variants based on Constraints.
- Q1. Best Time To Buy and Sell Stock You have been given an array 'PRICES' consisting of 'N' integers where PRICES[i] denotes the price of a given st...read more View Answers (3)
- Q2. Buy and Sell Stock You are Harshad Mehta’s friend. He told you the price of a particular stock for the next ‘N’ days. You can either buy or sell a stock. Also, ...read more View Answers (4)
Interview Preparation Tips
Tip 1 : Solve atleast 300 coding questions.
Tip 2 : Have some good projects on resume.
Tip 3 : Be truthful.
Tip 1 : Have 2 or 3 good projects.
Tip 2 : Don't lie on your resume.
Skills evaluated in this interview
I was interviewed before Sep 2020.
2 Interview Rounds
Coding Test Round (2 Questions)
Round duration - 80 minutes
Round difficulty - Easy
This round was scheduled in the evening hours around 7pm at Hackerrank platform and all the participants were required to fill a form which was shared 2 days prior to the test date. This form was filled out probably for the security reasons and to ensure that no one disinterested participant gives the test.
- Q1. Ways To Make Coin Change You are given an infinite supply of coins of each of denominations D = {D0, D1, D2, D3, ...... Dn-1}. You need to figure out the total ...read more View Answers (4)
- Q2. Find Duplicate You have been given an integer array/list(ARR) of size N which contains numbers from 0 to (N - 2). Each number is present at least once. That is,...read more View Answers (1)
Video Call Round (2 Questions)
Round duration - 45 minutes
Round difficulty - Hard
This round was conducted on Zoom platform. I was shared the invitation link one day prior to the interview and also was told the name of my interviewer. I looked at the profile of the interviewer at linked.in and got a better understanding of what kind of person he was and prepared accordingly. The round was scheduled at 3 :00 pm on 20th August and I was eagerly waiting for the clock hands to reach 3 o'clock since morning and finally I went in front of him after wearing a white shirt and a black coat over it along with a tie over it.
- Q1. First negative integer in every window of size “k” You have been given an array of integers 'ARR' and an integer ‘K’. You need to find the first negativ...read more View Answers (2)
- Q2. Basic Aptitude Questions There are 2 jugs with 4 litres and 5 litres of water respectively. The objective is to pour exactly 7 litres of water in a bucket. How ...read more Add Answer
Interview Preparation Tips
Tip 1 : Practice all DSA questions from interview bit
Tip 2 : Do Atleast 3 project one should be major, if it's in web dev it would be beneficial.
Tip 3 : Should be good in communication skills
Tip 1 : resume should be short and descriptive
Tip 2 : mention all the important projects that you have worked on
Tip 3 : better if resume is enclosed in single page
Skills evaluated in this interview
I was interviewed before Sep 2020.
2 Interview Rounds
Coding Test Round (2 Questions)
Round duration - 75 minutes
Round difficulty - Hard
This was a pure coding round consisting of three questions where time allotted for one easy question was 15 minutes while the other two questions were to solved in 30 minutes each.
total time = 15+30+30= 75 minutes
- Q1. Set Bits Write a program to count the number of 1's in the binary representation of an integer. Input format : The only line of input contains a single inte...read more View Answers (1)
- Q2. Longest Increasing Subsequence 'N' students are standing in a row. You are given the height of every student standing in the row. Your task is to find t...read more View Answers (3)
Video Call Round (1 Question)
Round duration - 45 minutes
Round difficulty - Hard
There were 2 interviewers and the round was carried out on code pair platform of HackerRank
- Q1. Burning Candles Prateek is a kindergarten teacher. He wants to give some candies to the children in his class. All the children stand in a line and each of them...read more View Answers (2)
Interview Preparation Tips
Tip 1 : Single page resume but brief
Tip 2 : Major team product is must
Tip 3 : Regular coding practice on GFG, Leetcode and coding ninjas type platforms
Tip 1 : Consists the brief of your skill set
Tip 2 : Github link of projects should be provided
Tip 3 : Mention clearly if you have done a team project
Skills evaluated in this interview
I was interviewed before Sep 2020.
2 Interview Rounds
Coding Test Round (2 Questions)
Round duration - 75 minutes
Round difficulty - Medium
2 coding questions
- Q1. Check BST Given a binary tree with N number of nodes, check if that input tree is BST (Binary Search Tree) or not. If yes, return true, return false otherwise. ...read more View Answers (2)
- Q2. Reverse Linked List Given a singly linked list of integers. Your task is to return the head of the reversed linked list. For example: The given linked list is 1...read more View Answers (6)
Video Call Round (1 Question)
Round duration - 45 minutes
Round difficulty - Medium
- Q1. Validate BST Given a binary tree with N number of nodes, check if that input tree is BST (Binary Search Tree) or not. If yes, return true, return false otherwis...read more View Answers (3)
Interview Preparation Tips
Tip 1 : Practice more.
Tip 2 : Solve questions on Coding ninjas and Leetcode.
Tip 3 : Make good projects.
Tip 1 : Keep it short.
Tip 2 : Mention your projects in brief.
Skills evaluated in this interview
I was interviewed before Sep 2020.
2 Interview Rounds
Coding Test Round (3 Questions)
Round duration - 90 minutes
Round difficulty - Medium
It was conducted in the evening at around 7:00 p.m.
The hackerrank environment is clearly the best for conducting coding exams as it provides a decent interface for debugging and testing purposes.
There were 3 questions- 1 of easy level and 2 of medium level.
- Q1. Pythagorean Triplets You are given an array of n integers (a1, a2,....,an), you need to find if the array contains a pythagorean triplet or not. An array is sai...read more View Answers (3)
- Q2. Ways to arrange balls Given ‘a’ balls of type ‘A’, ‘b’ balls of type ‘B’ and ‘c’ balls of type ‘C’. You need to find the total number of ways to arrange the bal...read more View Answers (3)
- Q3. LCS of three strings Given three strings A, B and C, the task is to find the length of the longest common sub-sequence in all the three strings A, B and C. A su...read more View Answers (4)
Video Call Round (1 Question)
Round duration - 60 minutes
Round difficulty - Easy
The round was conducted on CodePair platform which provides a IDE along with a video call for interviews.
There were 2 interviewers and both were friendly.
I was first asked about the various subjects I have studied in my curriculum. Then I was asked about my favourite programming language to which I answered Python.
After this, they asked various confusing questions based on function calling, argument passing and pass by object reference concept in Python.
Then they asked about the implementation of dictionary in Python and wanted me to design one with the help of lists(arrays) and optimize its search, add and delete operations. (Could be done with hashing and probing).
Then they asked questions from subjects like Computer Architecture and Theory of Computation (Basic questions were asked so you should just remember the key topics in the subject).
- Q1. Delete a Node from Linked List You have been given a linked list of integers. Your task is to write a function that deletes a node from a given position, 'P...read more View Answers (3)
Interview Preparation Tips
Tip 1 : For an intern position in any big company, the most important thing is practicing data structures. Solve as many questions as you can on platforms like Coding Ninjas. First start picking up questions topic-wise and once you gain a decent confidence in every topic, start hitting harder questions randomly on various platforms. (Practice a minimum of 300 questions).
Tip 2 : If you are stuck at solving any question, instead of looking up for a code solution try to read discussions and see various approaches people are applying. This will surely make you prepared for the way in which the interviews are designed. Always keep a clock ticking while solving a problem as spending too much time while practicing surely makes you slow in the Online Tests and Interviews.
Tip 3 : Again specifically for internship preparation, focus mainly on the subjects that have been taught to you till now. As in many colleges Database Management, Operating Systems and Computer Networks are not taught till the 4th semester so you could easily focus on subjects in your curriculum. OOPS concepts are very important!
Tip 1 : In On-Campus internship drives it is generally not required to have a very charming resume with a load of projects as the companies understand the candidate as a 4th semester student.
Tip 2 : But still if there is even a single decent project genuinely build by the student then it is more than sufficient.
Skills evaluated in this interview
Yardi Systems Interview FAQs
The duration of Yardi Systems SQL Developer interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Yardi Systems Interviews By Designations
- Yardi Systems Software Engineer Interview Questions
- Yardi Systems SQL Developer Interview Questions
- Yardi Systems Software Engineer Trainee Interview Questions
- Yardi Systems Software Developer Interview Questions
- Yardi Systems Software Analyst Interview Questions
- Yardi Systems Web Designer Interview Questions
- Yardi Systems Application Support Engineer Interview Questions
- Yardi Systems Engineer Trainee Interview Questions
- Show more
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Yardi Systems SQL Developer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Software Engineer
319
salaries
|  ₹4 L/yr - ₹8.5 L/yr |
|
Software Analyst
272
salaries
| ₹5 L/yr - ₹12 L/yr |
|
Senior Software Analyst
152
salaries
| ₹5.9 L/yr - ₹15.5 L/yr |
|
Compliance Auditor
69
salaries
| ₹2.9 L/yr - ₹5.4 L/yr |
|
Software Engineer Trainee
65
salaries
| ₹4.5 L/yr - ₹6 L/yr |
RealPage
MRI Software
Buildium
Entrata
Calculate your in-hand salary
- Home >
- Interviews >
- Yardi Systems Interview Questions >
- Yardi Systems SQL Developer Interview Questions for Fresher
