AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Azentio Senior Plsql Developer Interview Questions, Process, and Tips
Azentio Senior Plsql Developer Interview Experiences
1 interview found
Anonymous
I applied via Walk-in and was interviewed in Oct 2024. There were 3 interview rounds.
Four questions and bout 2 hrs and topics covered are exceptions,database.
(2 Questions)
- Q1. What is index ? and types?
- Ans.
An index is a database object that improves the speed of data retrieval operations on a table.
Indexes are used to quickly locate data without having to search every row in a table.
Types of indexes include B-tree indexes, bitmap indexes, and function-based indexes.
Examples of indexes are primary keys, unique constraints, and indexes created explicitly on columns.
- Q2. What is trigger?
- Ans.
A trigger is a PL/SQL block that is automatically executed in response to certain events on a particular table or view.
Triggers can be used to enforce business rules, audit changes, or replicate data.
They can be classified as row-level triggers (executed for each row affected) or statement-level triggers (executed once for the entire statement).
Examples of trigger events include INSERT, UPDATE, DELETE operations on a t
(2 Questions)
- Q1. What is materialized view?
- Ans.
A materialized view is a database object that contains the results of a query and is stored on disk for faster access.
Materialized views store the results of a query like a table, allowing for faster access to data.
They are updated periodically to reflect changes in the underlying data.
Materialized views are commonly used in data warehousing and reporting applications.
Example: CREATE MATERIALIZED VIEW mv_sales AS SELEC...
- Q2. Difference between union and union all?
- Ans.
Union combines and removes duplicates, Union All combines without removing duplicates.
Union combines result sets and removes duplicates
Union All combines result sets without removing duplicates
Union is slower than Union All as it involves removing duplicates
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. Collections,SQL
Interview Questionnaire
1 Question
- Q1. Case Studies
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2020. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. I have got questions about vsam files and about SQL queries.
- Q2. What is my previous work and project roles and responsibilities.?
Interview Preparation Tips
I applied via Company Website and was interviewed before Jun 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. If fresher is attending the interview then mostly they'll ask questions from resume What are generics, UML diagram for the proper medicine suggestions based on the patient allergies to a particular drug ...
Interview Preparation Tips
First round: versant test
Second round: Technical Interview 1
Third round: Technical Interview 2
Feedback of best of the 2 technical interviews will be considered.
IF selected will receive a call from HR
Nirban Chatterjee
I applied via Naukri.com and was interviewed before Oct 2019. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Normal php questions like overriding,overloading,traits,interface,abstarct class nothing else.. It was online but in 2016.
- Q2. Go though those topic as they are very important and asked in most companies.
Interview Preparation Tips
Interview Questionnaire
3 Questions
- Q1. Tell us about yourself
- Ans.
I am a business analyst with experience in data analysis and project management.
I have a degree in business administration
I have worked with various industries including healthcare and finance
I am skilled in data visualization and reporting
I have experience in leading cross-functional teams
I am proficient in SQL and Excel
- Q2. What is your area of interest?
- Ans.
My area of interest is data analysis and visualization.
I enjoy working with large datasets and finding insights through data analysis.
I have experience using tools such as Excel, Tableau, and Python for data analysis and visualization.
I am interested in exploring new data sources and learning new techniques for data analysis.
For example, I recently worked on a project analyzing customer behavior data for a retail compa...
- Q3. What are the other companies you have applied to and how many rounds of the selection process have you cleared there?
Interview Preparation Tips
Experience: The selection process was open for students from all branches. Around 70 students were shortlisted based on their resume. Shortlisting was mainly on CGPA basis and on an average 5 top students were shortlisted from each branch.
Round: Test
Experience: There was a written test conducted for shortlisted candidates. The test was primarily based on the CAT pattern where questions were asked from verbal reasoning, logical reasoning and quantitative aptitude. The test comprised of 2 sections. First section comprised of 3 HR questions:
Why do you want to join this company?
Tell us about yourself.
Describe a situation where you displayed leadership skills.
These 3 questions were to be typed out in 150–200 words each in a total of 20 minutes. Second section started immediately after this. 25 minutes were given to answer 35 multiple choice questions from various sections including 10 coding based questions. The difficulty level was medium.
Duration: 45 minutes
Total Questions: 38
Round: HR Interview
Experience: They asked me to tell them about myself and also some puzzles and core field related questions. Interview was conducted using Skype. It started with basic HR question and then the interviewer asked me about my area of interest. He asked two questions from that field and then asked me to solve one guesstimate case. There was another question on the definition of data analysis.
My area of interest was Operations Research. First he asked me to explain transportation problem and second question was about solving a transshipment problem using Excel solver software. Other candidates were also asked some puzzles and several other HR questions.
College Name: IIT ROORKEE
Preetij Amin
Interview Questionnaire
4 Questions
- Q1. Since you do not have a background in analytics, is there anything you've done that would relate to it?
- Ans.
Yes, I have experience in data analysis and visualization through Excel and Tableau.
I have worked on multiple projects where I had to analyze and visualize data using Excel and Tableau.
I have created dashboards and reports to present data insights to stakeholders.
I have also used statistical analysis to identify trends and patterns in data.
I am currently learning Python and SQL to further enhance my data analysis skill
- Q2. Since you know e-commerce so well, why not go for a start-up?
- Ans.
I am interested in the stability and growth opportunities offered by an established company.
I value the stability and resources of an established company
I am interested in the opportunity to work with a diverse range of clients and industries
I believe my skills and experience are better suited to a larger organization
I am open to exploring start-up opportunities in the future
- Q3. Do you have any plans for higher studies?
- Ans.
Yes, I am planning to pursue a Master's degree in Business Administration.
I have researched various MBA programs and have shortlisted a few that align with my career goals.
I plan to take the GMAT exam and apply to these programs in the next year.
I believe that a higher education degree will equip me with advanced skills and knowledge to excel in my role as a Business Analyst.
- Q4. Estimate the size of racks of rice in a store in any area
- Ans.
The size of racks of rice in a store can vary depending on the store's location, size, and target market.
The size of the store can determine the size of the racks
The target market can determine the quantity of rice sold and therefore the size of the racks
The location of the store can determine the size of the racks based on the available space
The type of rice sold can also determine the size of the racks
Observation of ...
Interview Preparation Tips
Experience: The tests are held using the platform of Cocubes. First section has HR questions such as "why Axtria?" and other stuff. I don't think its really necessary and I presume that nobody looks at it. The sections 2, 3 and 4 are fairly easy. But since the test is easy, you should also keep this in mind that the cutoff might be high. The coding section had basic question of C, C++ and Java. Don't worry even if you don't know java. All in all, the questions are very "do-able" and one should easily crack them.
Tips: I'd advice aspirants to go through the concepts of OOPs; just a brief glance at it, not necessarily mastering it. There's no negative marking, so try attempting all the questions. Also the test is of 2 hours with 60 minutes for sections 2, 3 and 4.
Round: Group Discussion
Experience: The GD round is quite simple. A group is formed of 8-10 people. Everyone gets a chance to speak, unless it's your bad day with a cartoon character in the same group with you.
One person didn't really want, but was forced to appear for the selection process. So from the very beginning, he was trying for a "suicide". So there was a bit of negation in arguments which might have killed us all. But the interviewers really want everyone to put up their points and gave equal opportunities.
Before proceeding with your points, each of us had to introduce ourselves and then put up our points. There was a lot of desperation in my GD, so there were moments when people were actually arguing. So one really had to grab their chance when speaking.
The other groups had topics like, "Social media in daily life", "Pros and cons of using Cloud", etc. Their GD was very methodical, everyone speaking turn by turn and in the end anyone was asked to conclude the session.
In the end, about 2 people are eliminated, so in order to fail, you really have to suck at public speaking. Otherwise, take it for granted that you're going through for the next round.
Tips: I'd suggest people to have a go at number 3 or 4, once you've gauged the nature of the discussion. Try to put up all your points very briefly, giving an example or two. Don't negate other people's arguments and agree with people who's thoughts are in line with yours. Even if you want to negate others, do it very subtly. Try to be involved as much as possible. Be the best listener, moderate the GD when you're not active and when you're speaking, be very confident.
Duration: 10-12 minutes
Round: Guesstimate Interview
Experience: Since I did not have any background in analytics, the interviewer had to ask me other questions. At first she asked me about statistics, which I was not really confident about. At this point, I was almost certain to crash out. But luckily, the next question she asked me was the above guesstimate. This being one of my stronger skills, was quite OK for me, and I handled this question well enough. The interviewer was quite impressed with my approach and was smiling as if advertising for Colgate, at the end of the interview. This instilled some confidence in me, that I was going through, at least for this round. But this was, as one would say, lady luck, saving me. Other candidates, who had a background in analytics, were asked only about their previous internships (not too technical).
Tips: If you have a background in analytics, then just go through all your projects. If you do not have any such skills, then brush up your guesstimates. Other person who was like me, was asked to estimate the time after which a boiler needed maintenance (he was from Mechanical). Another guy was asked how would one determine that a person is fraud or not; if he withdrew about 10K in first three months and then 50K in the 4th month, from his credit card. So case-study and guesstimates are a must if you don't have analytics on your CV.
Round: HR Interview
Experience: There was a panel of 3 interviewers. Other candidates (analytics guys) were simply asked to convince them that they would work for the company for the foresee-able future. I, on the other hand, was asked to convince them, why I am the guy for Axtria. I had to defend myself, for having internships in different backgrounds and how would I be suitable for analytics. Then they asked me that since I had worked in an logistics company, why did not I go for my own start-up. Again I said a few things, which was basically running around, why do I want to work for Axtria. Luckily, I managed to convince them in the end. But still I did not have that good a feeling about this round. When asked about higher studies, I told them that I had plans but not in the near future.
Tips: This one was pretty dependent on how you'd defend your CV. But otherwise, it should be a very simple experience for analytics guys. Axtria goes for elimination rather than selection in its process. So unless you really suck at giving interviews, you can give yourself a fair chance of getting selected. Also, since they have a 3 month long training period, it is not really necessary that you have analytics on you CV. But for a guy like me, you have to be very convincing about yourself and make them believe that Axtria and you are a match made in heaven.
General Tips: If you're confident with conversing in English and are convincing enough, it shouldn't be really difficult. Also, the conversion rate is about 0.5 i.e. half of the shortlisted people are going to get selected. So there's no need to be nervous.
Skills: Data Analysis, Probability And Statistics, Guesstimation Cases
College Name: IIT Kharagpur
Funny Moments: After selection was complete, a girl asked: Sir, do we have to work on Sundays?
Sahil Chhabra
Interview Questionnaire
1 Question
- Q1. For me there was just one interview combined of guesstimates and Puzzles
Interview Preparation Tips
Experience: Consisted of 5 sections - English, Quant, Logical Reasonong, Statistics, Probability/Analytical questions. 10 questions per section. Medium level difficulty. It was followed by an subjective test by 1 question. The question was describe the most challenging experience while working in a Team.10 mins for this question
Tips: Practise Quant and logical reasoning. Stay focussed and confident.
Duration: 60 minutes
Total Questions: 50
Round: Group Discussion
Experience: First 1 min everyone has to speak then the group has to conclude in last 5 mins.
Tips: Reading newspaper is a must.
Duration: 20 minutes
Round: Interview
Experience: 1. Estimate the length of your hairs.2. What will you infer from the data of your collage (if provided) consisting of name contact details rank and sitting/not sitting for placements.3. Divide a disk/circle into 8 equal parts.4. 100 coins to be put into infinite boxes. How to place so that by just taking the EXACT number of boxes I can have money of any denomination under 100.5. 10% discount followed by 15% discount and then vice-versa. Which is better for shopekeeper?
Tips: Ans to last 33. three cuts4. 1 2 4 8 16 32 375. same for both
General Tips: Read about the company and work profile before hand. It helps a lot to frame the answer of Why Axtria?
Skill Tips: Practise and stay confident
Skills: Quantitative, communication skills
College Name: IIT Kharagpur
Motivation: Analytical job. Tremendous growth opportunities.
P B Viswa Vardhan
Interview Questionnaire
14 Questions
- Q1. He gave me a puzzle to solve
- Q2. What is your GRE score ?
- Ans.
I apologize, but I do not have a GRE score as it is not applicable to my role as a Business Analyst.
As a Business Analyst, my skills and experience are evaluated through my work history, education, and certifications.
GRE scores are typically required for admission to graduate programs, but not for a Business Analyst position.
My focus is on utilizing my analytical and problem-solving skills to support business decisions
- Q3. What is your CAT score ?
- Ans.
CAT score is not applicable for a Business Analyst role.
CAT score is a standardized test for admission to management programs.
It is not relevant for a Business Analyst role.
Business Analysts require skills in data analysis, problem-solving, and communication.
Other relevant qualifications for a Business Analyst role include a degree in business, economics, or a related field, and experience in data analysis or project m
- Q4. Why do you want to join our firm?
- Ans.
I am impressed with the company's reputation and growth potential.
Your company has a strong reputation in the industry.
I am excited about the opportunity to work with a talented team.
I believe your company's growth potential aligns with my career goals.
Your company's values and mission resonate with me.
I am impressed with the innovative projects your company is working on.
- Q5. Who is the CEO of our company ?
- Ans.
I'm sorry, I don't have access to that information.
No data available
I don't have access to that information
- Q6. You have written some PORs in you CV, But I feel this is not at all a POR!!! ?
- Q7. What are your plans for the future?
- Ans.
My plans for the future include continuous learning, career growth, and contributing to the success of the company.
Continuously improve my skills and knowledge through training and development programs
Take on challenging projects and responsibilities to advance my career
Collaborate with colleagues to achieve company goals and objectives
- Q8. How do people remember you by ? define it in one word
- Ans.
Reliable
Consistent in meeting deadlines and delivering quality work
Trustworthy and dependable
Known for being organized and detail-oriented
- Q9. What are your 2 strengths ?
- Ans.
My strengths are attention to detail and problem-solving skills.
Attention to detail helps me identify potential issues and ensure accuracy in my work.
Problem-solving skills enable me to analyze complex situations and find effective solutions.
For example, in my previous role, I was able to identify a flaw in the company's inventory management system and proposed a solution that saved the company thousands of dollars.
I a...
- Q10. What is your weakness?
- Ans.
My weakness is public speaking.
I tend to get nervous when speaking in front of large groups.
I am actively working on improving my public speaking skills through practice and training.
I have found that preparing thoroughly and practicing beforehand helps me feel more confident.
I also try to focus on the message I am trying to convey rather than my own nerves.
- Q11. What people dont like in you ?
- Q12. Where do you see yourself 5 years down the line ?
- Ans.
In 5 years, I see myself as a senior business analyst leading a team and contributing to the growth of the company.
Leading a team of business analysts
Contributing to the growth of the company through data-driven insights and recommendations
Continuing to develop my skills and knowledge in the field of business analysis
Building strong relationships with stakeholders and clients
Exploring opportunities for process improvem
- Q13. What is your JEE Rank, 10th and Inter Math score ?
- Ans.
I do not have the JEE rank, but my 10th and Inter Math scores are above average.
I do not have my JEE rank available at the moment.
However, my 10th and Inter Math scores are above average.
I can provide more details on my academic achievements and relevant experience.
For example, I have completed a course in data analysis and have experience in using SQL for data querying.
- Q14. He too asked me a puzzle on probability
Interview Preparation Tips
Experience: The test was organized by cocubes.com .After writing many tests in cocubes.com , I felt a little better and easier.
Tips: Answers the questions you know. Don't forget to tick all the left overs before submitting the test if there are no negative markings :P .Write the exam in your normal pace. Don't panic or get tensed. Just be your self
Duration: 50 minutes
Total Questions: 50
Round: Group Discussion
Experience: We were 15 in the group. This wasn't like normal GDs. We were given a minute each to speak. I was the last member to speak. Almost all the points were covered. I did add new points and new dimensions to the discussion.
Tips: You will find many tips on the Internet.The most important thing I felt was " Create interest in people to listen to what you are speaking, And Speak the right things". Maintain Eye contact. Smile often. Always add points to the make the discussion constructive.
Round: Interview
Experience: I was a bit stressed out when he pointed out that I didn't do the works which actually I did them. But I always kept my cool. Answered him wisely.
Tips: Be Honest. take your time. Never admit the things which he will try to confuse you. Better answer him the right way than answering him quickly. Be a thoughtful person
Round: Interview
Experience: I was honest through out the interview.
Tips: Always be Honest. Keep your confidence levels high.Do your Homework. Prepare before hand for the most important HR questions. Don't fumble upon in front of the interviewer. Rehearse the answers which you have written down in front of a mirror or Best Friend. I prefer Friends to mirror as mirrors don't give you feedback :P .
General Tips: Be Honest.Just Recollect your past events.
Skill Tips: "Be yourself and " Sell the buyer what he is looking for ""
Skills: Quick learning, Confidence, Logical reasoning
College Name: IIT Kharagpur
Motivation: Good learning environment and Data Analysis is an emerging field.
Funny Moments: As soon as I entered the room HR was busy doing some phone calls and stuff, After a minute I asked him whether He was tensed :P :D
Azentio Interview FAQs
Tell us how to improve this page.
Azentio Interviews By Designations
- Azentio Software Developer Interview Questions
- Azentio Software Engineer Interview Questions
- Azentio Senior Business Analyst Interview Questions
- Azentio Business Analyst Interview Questions
- Azentio Software Development Engineer Interview Questions
- Azentio Java Developer Interview Questions
- Azentio Trainee Interview Questions
- Azentio Data Scientist Interview Questions
- Show more
Interview Questions for Popular Designations
- Plsql Developer Interview Questions
- Software Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- Java Developer Interview Questions
- Senior Software Developer Interview Questions
- Full Stack Developer Interview Questions
- Application Developer Interview Questions
- DOT NET Developer Interview Questions
- Show more
Azentio Senior Plsql Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
427
salaries
|  ₹2.7 L/yr - ₹10 L/yr |
|
Senior Software Engineer
207
salaries
| ₹5.1 L/yr - ₹17.1 L/yr |
|
Software Developer
146
salaries
| ₹2.7 L/yr - ₹10.8 L/yr |
|
Business Analyst
131
salaries
| ₹4 L/yr - ₹14 L/yr |
|
Plsql Developer
93
salaries
| ₹3 L/yr - ₹10.5 L/yr |
Thomson Reuters
Oracle Cerner
NextComm Corporation
Chetu
- Home >
- Interviews >
- Azentio Interview Questions >
- Azentio Senior Plsql Developer Interview Questions
