AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Xyz Company Database Admin Interview Questions and Answers
Xyz Company Database Admin Interview Experiences
3 interviews found
Abhiram Kuruva
It was moderate and also easy to crack
(2 Questions)
- Q1. Write a SQL queries
- Ans.
SQL queries to retrieve data from a database
Use SELECT statement to retrieve data from tables
Use WHERE clause to filter results based on specific conditions
Use JOIN clause to combine data from multiple tables
- Q2. Use case when while writing a query
- Ans.
Using a case statement in a query to handle different conditions
Use CASE statement to handle different conditions in a query
CASE can be used for conditional logic within SELECT, WHERE, ORDER BY clauses
Example: SELECT column1, CASE WHEN condition1 THEN 'Result1' ELSE 'Result2' END AS new_column FROM table_name
Skills evaluated in this interview
I applied via Referral and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me about your self
- Q2. Tell me about your leadership skills
Interview Preparation Tips
- Leadership Skills
- Team Management
Java, oops, data structures
Calandars, percentage
What people are saying about Xyz Company
Interview questions from similar companies
I applied via Company Website and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Conflict management
- Q2. Financial forecasting and vendor management
- Q3. Alteryx, SQL
Interview Preparation Tips
- Read the JD to understand the probable questions.
- Ask your queries and understanding about the requirements.
- Smile
- Be yourself
- Prepare introduction in line with the job
Senior Associate Interview Questions & Answers
Motilal Oswal Financial Services
Anonymous
posted on 6 Dec 2021
I applied via Recruitment Consultant and was interviewed in Jun 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. NOTHING SPECIAL
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Check palindrome , anagram of string with O(n)
- Ans.
To check palindrome and anagram of a string with O(n), use a hash table to store character frequencies.
Create a hash table to store the frequency of each character in the string.
For palindrome, check that no more than one character has an odd frequency.
For anagram, compare the hash tables of the two strings.
If the hash tables are equal, the strings are anagrams.
If the hash tables differ by only one character, the strin...
- Q2. Optimized solutions and core principles applied in OOPS
- Ans.
Optimized solutions and core principles applied in OOPS
Encapsulation, Inheritance, Polymorphism, Abstraction are core principles of OOPS
Optimized solutions can be achieved through efficient algorithms and data structures
Design patterns like Singleton, Factory, Observer can also be used for optimized solutions
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview before May 2021.
(1 Question)
Round duration - 45 Minutes
Round difficulty - Hard
- Q1.
Find the Duplicate Number Problem Statement
Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...
- Ans.
Find the duplicate number in an integer array containing numbers from 0 to (N - 2).
Iterate through the array and keep track of the frequency of each number using a hashmap.
Return the number that appears twice in the array.
The duplicate number is always present in the given array.
(1 Question)
Round duration - 50 Minutes
Round difficulty - Easy
- Q1.
Bubble Sort Problem Statement
Sort an unsorted array of non-negative integers using the Bubble Sort algorithm, which swaps adjacent elements if they are not in the correct order to sort the array in non-d...
- Ans.
Bubble Sort is used to sort an array of non-negative integers in non-decreasing order by swapping adjacent elements if they are not in the correct order.
Iterate through the array and compare adjacent elements, swapping them if they are in the wrong order.
Repeat this process until the array is sorted in non-decreasing order.
Time complexity of Bubble Sort is O(n^2) in worst case.
Example: For input [6, 2, 8, 4, 10], the o
(1 Question)
Round duration - 60 Minutes
Round difficulty - Medium
- Q1.
Unweighted Graph Shortest Path Problem
You are tasked with finding the shortest path between two houses in the city of Ninjaland, represented as an unweighted graph. The city has
Nhouses numbered from 1 ... - Ans.
Find the shortest path between two houses in a city represented as an unweighted graph.
Use breadth-first search (BFS) algorithm to find the shortest path in an unweighted graph.
Start BFS from the source house and keep track of the shortest path to each house.
Once the destination house is reached, backtrack to find the shortest path.
Consider using a queue data structure to implement BFS efficiently.
Round duration - 60 Minutes
Round difficulty - Easy
Interview Preparation Tips
Tip 1 : online resources
Tip 2 : cracking the coding interview by Gayle laykemann this is one of the best book for learning the concept at the initial level. Start practicing the approaches mention in the book once done apply the same to similar level pattern questions.
Tip 3 : geeks for geeks start from school level and then move towards easy medium and hard once done practice the previous year questions
Tip 1 : precise clear concise and well written
Tip 2 : mentions the skills sets along with the projects
Skills evaluated in this interview
I applied via Company Website and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Reason for job switch. Reason for role switch. Technical role related questions.
Interview Preparation Tips
I applied via Company Website and was interviewed before Oct 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. I was asked mostly about my profile and there expectations.
Interview Preparation Tips
I applied via Referral and was interviewed in Mar 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Do you know about hedge funds?
- Ans.
Hedge funds are investment funds that use various strategies to generate high returns for their investors.
Hedge funds are typically only available to accredited investors due to their high-risk nature.
They often use leverage and derivatives to amplify returns.
Hedge funds can invest in a wide range of assets, including stocks, bonds, commodities, and currencies.
Some famous hedge funds include Bridgewater Associates, Ren...
Interview Preparation Tips
Xyz Company Interview FAQs
Tell us how to improve this page.
Xyz Company Interviews By Designations
- Xyz Company Software Developer Interview Questions
- Xyz Company Analyst Interview Questions
- Xyz Company Software Engineer Interview Questions
- Xyz Company Intern Interview Questions
- Xyz Company Executive Interview Questions
- Xyz Company Business Analyst Interview Questions
- Xyz Company Data Analyst Interview Questions
- Xyz Company Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Database Analyst Interview Questions
- Database Administrator DBA Interview Questions
- Senior Database Administrator Interview Questions
- SQL Database Developer Interview Questions
- Senior Database Developer Interview Questions
- Show more
Xyz Company Database Admin Interview Process
based on 4 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Developer
1.1k
salaries
|  ₹11 L/yr - ₹37 L/yr |
|
Software Engineer
957
salaries
| ₹16.1 L/yr - ₹37.8 L/yr |
|
Manager
642
salaries
| ₹11.5 L/yr - ₹47.4 L/yr |
|
Senior Software Engineer
493
salaries
| ₹13.5 L/yr - ₹44.6 L/yr |
|
Team Lead
415
salaries
| ₹10.4 L/yr - ₹40 L/yr |
JPMorgan Chase & Co.
Wells Fargo
Citicorp
HSBC Group
- Home >
- Interviews >
- Xyz Company Interview Questions >
- Xyz Company Database Admin Interview Questions
