MockQuestions MockQuestions
Interviews Questions by Career
Interviews Questions by Company
Interviews Questions by Topic
Get Started
Interview Coach 1:1
Gain the confidence you need by asking our professionals any interview scenario, question, or answer you are unsure about.
Let Us Review Your Answers
Our interviewing professionals will gladly review and revise any answer you send us. Allowing you to craft perfect responses for your next job interview.
Interview Questions by Topic
Interview Questions by Career
Interview Questions by Company

e-Zest Solutions Interview
Questions

28 Questions and Answers by Ryan Brunner

Published March 9th, 2020 | Ryan has over 10 years of experience interviewing
candidates in the healthcare, public service, and private manufacturing/distribution industries.
Question 1 of 28
When would you utilize a trigger within Oracle to execute a function automatically?
View Answers
How to Answer
To answer this question, it is important to first have an understanding of what a trigger is within Oracle. Simply defined, a trigger is a named block stored within the database that executes on its own when a certain even takes place. While you talk about your understanding of what a trigger is, be sure that you explain that you understand how to create a trigger in Oracle and that you understand that proper situations to utilize them in.
1000s of Interview Questions
Win your next job by practicing from our question bank. We have thousands of questions and answers created by interview experts.
Suggested
Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
Suggested Career
Interview Q&As
Continue practicing by visiting these similar question sets
Software Developer
Web Developer
Web Architect
Computer Programmer
Computer Scientist
Top 25 e-Zest Solutions Ltd. Interview Questions with Full Content
1.
When would you utilize a trigger within Oracle to execute a function automatically?
To answer this question, it is important to first have an understanding of what a trigger is within Oracle. Simply defined, a trigger is a named block stored within the database that executes on its own when a certain even takes place. While you talk about your understanding of what a trigger is, be sure that you explain that you understand how to create a trigger in Oracle and that you understand that proper situations to utilize them in.

Ryan's Answer #1
"In the current work that I do in Oracle, I utilize triggers to prevent invalid transactions within the software that I am working with. I have a full understanding of how to write create trigger statements using declaration statements, executable statements and exception handling statements to set the appropriate triggers. If hired for this role here at e-Zest Solutions, you could have full confidence in my ability to utilize triggers within Oracle."
Ryan's Answer #2
"With my two prior years spent working on Oracle, I have written database triggers using insert, update and delete statements that are issued against a table. These database triggers allow our end users to be able to reap the benefits of the triggers. The instances that I've utilized database triggers have been for pulling statistical information from the tables within the system."
2.
Would you say that you are a goal oriented on the job? What would I be able to do as your manager to help you achieve your goals if hired here at e-Zest Solutions?
At the heart of this question lies your interviewers desire to see what motivates you as a potential employee at e-Zest Solutions. Make it clear to your interviewer that you certainly are motivated by on the job goals and do this by using an example of a time where you were motivated by and achieved a goal. Then, think deeply about the type of manager that you like to work for in terms of goal setting and helping our achieve your goals. Let your interviewer know what type of management styles you appreciate the most while being open to any style.

Ryan's Answer #1
"I would definitely say that I am goal oriented on the job in wanting to contribute any way that I can to the overall benefit of the organization. In my current organization, our leadership focuses on overall sales numbers at the end of the year. To help achieve these goals, our department creates our own goals to help achieve the sales numbers needed to succeed. Last year, one of those goals was to be as creative as possible in our user experience design processes. With the launch of an exciting new app midyear, sales numbers skyrocketed and our department was instrumental in that. For me, it was important that we determined our goals as a team with the final stamp of approval from our manager. While this style of management really helped motivate me, I can thrive under any management style as long as expectations and goals for my work are clearly set."
Ryan's Answer #2
"For me, my day to day work is much more meaningful when I have goals to work for. In my current role, we have set timelines for our projects and this helps lay the framework for our goals. If hired for this position, my expectations of you as my manager would be to have goals clearly defined and a supportive atmosphere to be provided to work within."
3.
What SDLC models are you familiar in working with?
As a software engineer, you are very familiar with the software development life cycle. For this question, your interviewer is looking to hear what models you have worked on in the past. While there isn't necessarily a right or wrong answer to this question, try to show your flexibility to working with different SDLC models by bringing up your past experiences. Then, show you have knowledge of different models like the waterfall model or agile model. It is also a good idea to use this question as an opportunity for you to learn more about e-Zest Solutions by asking your interviewer which model they work off of.

Ryan's Answer #1
"During my training in software engineering and in my early career, the waterfall model was the standard. In this model, each phase of the development process happens in a set order and projects using this model are easily managed. But over time, as the development projects that I have led have become more complicated and intricate, I have implemented the spiral model. This model has allowed the ability of end users to give feedback early on and often during development and helps to build a more customized product to our customers."
Ryan's Answer #2
"In my current position with XYZ Company, my department utilizes the agile model in development life cycle. Since our products are so tailored to the needs of our customers, we get a working product very early on in the process and then I work hand in hand with customers to fine tune the software moving forward. It is a very effective model that has built a great reputation for our software among customers. I also have familiarity working with the iterative model and it has similar advantages to the agile model. If I were hired here at e-Zest Solutions, can you expand on what models you use here in your software development life cycle?"
4.
Do you have experience working with different CASE tools? If so, what do you have experience with?
The world of software engineering has greatly benefited from advancements in computer aided software engineering tools. Because e-Zest Solutions is at the forefront of the industry, your interviewer will be looking to hear which tools you have experience with. Make sure not to concern yourself with providing a correct answer here, but rather focus on your flexibility to learn new aides when needed while explaining what you have experience with.

Ryan's Answer #1
"In my current role, I regularly utilize both diagramming and web development tools. The diagram tools assist our software projects by outlining the system data and components in a graphical form for us and this saves us a great amount of time while also being very reliable. The web development tools greatly help me visualize site changes that I am making because I don't have a deep background in web development. If hired for this position, I'd look forward to learning other CASE tools for prototyping, quality assurance and maintenance."
Ryan's Answer #2
"During my career and in my experience with CASE tools, most of my experience is in the lower CASE elements that focus on coding and testing the software after initial development. CASE tools have certainly made life as a software engineer more efficient and effective and I'd look forward to learn any new CASE tools if hired for this position here at e-Zest Solutions."
5.
A huge part of our business here at e-Zest Solutions is designing software for iOS. In this role, how would you steer away from retain cycles when using closures in Swift programming language?
This question allows your interviewer to assess your technical knowledge and skills in designing apps for iOS products in a very simple way. To successfully answer it, make sure that you can speak knowledgeably about the swift programming language and using closures to capture and store references within the software. To piece together everything for your interviewer, give a clear understanding of why retain cycles must be avoided in your processing.

Ryan's Answer
"Because ARC handles most of the memory knowledge in Swift, I know ARC is prone to memory leaking and this can cause major issues in apps over time. The fix that I've used in my career to avoid retain cycles is using weak references in my coding."
6.
Tell me about the most interesting project you have worked on this year and the biggest thing you learned from it.
Discuss with the interviewer one of your recent projects that particularly piqued your interest. Did it stretch you professionally? What was the biggest takeaway for you from that particular project?

Ryan's Answer #1
"In my previous role we were working on a variety of projects with fingerprint recognition software. One of the most interesting projects was a fingerprint-based ATM system. It was a test project for a large banking institution. In addition to learning a great deal about fingerprint recognition, I was also able to learn a lot about the critical relationship between software and security."
Ryan's Answer #2
"I find the majority of the projects that I have been working on this past year to be very interesting. If I had to choose one, I would choose to work on the Uber app. Since I am still in my internship, I didn't have any major contributions; however, I learned a lot about on-demand apps and building a friendly user interface."
7.
If hired for this position here at e-Zest Solutions, would you be comfortable handling overall project manager responsibilities for new software development?
As a skilled software engineer, you have all of the necessary tools in your bag to be a successful engineer at e-Zest Solutions. This question is allowing your interviewer to get a better sense of your project management skills and people skills if you were to join the team at e-Zest Solutions. In your answer, talk about your ability to estimate the time and cost of a project, the staffing needed and the overall scope of planning for a particular project. If you have direct experience in being the lead on a large development project, be sure to discuss that experience with your interviewer.

Ryan's Answer #1
"Looking to join the team here at e-Zest Solutions directly out of college, I feel very confident in my abilities to manage the entire scope of a new development project. I have leadership experience as my campus' president of the software engineering club. In that role, I developed skills that would help me utilize staff and resources in the best way possible. During my internship, I was exposed to the planning stages of new projects and I have a very good feel of estimating the budget and length of time needed to have a fully functional system."
Ryan's Answer #2
"I would absolutely be comfortable if tasked with project manager duties here at e-Zest Solutions. In my last two roles, I have led successful projects that started with great planning and budgeting process and went through to completion with great people and processes in place under my leadership. While it's not a regular duty for me in my current role, I always welcome leadership duties."
8.
In your experience in software testing, would you consider yourself proficient in both testing and debugging processes?
As a reputable provider of software, e-Zest Solutions relies on their software testing engineers to both test and debug their products when necessary. Make your interviewer aware that you are knowledgeable on both processes by briefly explaining each process as you've worked on them in the past. Then, talk about your openness to working both testing and debugging processes if hired for this position.

Ryan's Answer #1
"Yes, I definitely would consider myself proficient in both testing and debugging software. My current role that I've held for four years since graduating from college has exposed me to both processes. In testing, I use known conditions and predefined methods to test for expected outcomes to find errors within the system. I utilize testing prior to new software rollouts. The debugging process happens to already released software that has had issues and comes with unknown conditions and unpredictable outcomes. In this process, my goal is to find the cause of the error to fix it efficiently and effectively to roll an updated program back out to end users."
Ryan's Answer #2
"While a majority of my career has been focused on software testing, I am very familiar with debugging processes as well. If hired for this position, I would take the time to focus on debugging processes to bring myself up to speed while being able to hit the ground running on testing processes."
9.
Talk about a time when things didn't go as planned on the job. What was the situation and what allowed your to persevere in that situation?
As a professional in the tech industry, you have likely had a project that failed, a promotion that passed you over or a meltdown occur at some point in time. Realizing that your interviewer fully understands and expects that failure happens, talk openly and honestly about a situation where you experienced failure or failed plans. Most importantly in your answer, focus on how you overcame the particular situation and discuss lessons that you learned moving forward that you can bring to this role at e-Zest Solutions.

Ryan's Answer #1
"A couple of years ago in my first role as a UI designer out of college, my team was tasked with coming up with a very short notice proposal for a potential high end customer. With a week turnaround time, I set right to spending my time gathering information on the company to build a mock design. When the proposal was submitted, I found out that the potential customer scoffed at my idea and the customer went with another organization's proposal for their use. The biggest piece of feedback that I got was that the UI design just wasn't conducive to the type of customers they were expecting. From that point forward, whether it has been with short notice or long-term products, I take the time to communicate with key decision makers from clients to gather information for making my design as user friendly as possible."
Ryan's Answer #2
"Last year, I was working on a large scale project that put me face to face with a key customer. After traveling onsite with the customer to spend time with them, I exchanged contact information with two of the key decision makers. In the weeks following, I was sending them follow up emails with our business proposals and was getting frustrated at the lack of response from the clients. After my manager had questioned the viability of the potential customer, I picked up the phone and called them directly. It turns out that their responses back to me were being sent to a junk email folder that I neglected to consider. I apologized for the mistake, took action quickly and we came to a great agreement on future business together. After having a laugh about it with my boss, I now incorporate diligent communication follow ups both by phone and email with customers while also regularly checking all email inboxes."
10.
The software we develop here at e-Zest Solutions requires you to have working knowledge of both privileges and roles within Oracle. Can you talk about your knowledge and experience of both within Oracle?
On the development end of software, your role at e-Zest Solutions will require you to have knowledge of the differences between user privilege and role. Your role will put you working with end users on the two roles and explaining your knowledge of the two will be important to your interviewer. Give a basic understanding that privilege relates to the right to execute SQL statements and another user's objects as defined by Oracle. Then talk about roles being created by administrators to grant privileges to their users.

Ryan's Answer #1
"In my current role, I have great working knowledge of both role and privilege within Oracle as I work with the system administrators of our end users very closely. I work with them on using the grant and revoke commands to define the roles or their users and grant permissions within their system. To do this, I have to gain strong knowledge on the different people that are allowed access to the system and what they will be doing with their access."
Ryan's Answer #2
"As you can see from my resume, it has been a few years since I've worked directly with Oracle but I do have great working knowledge of the system. To best explain my knowledge, privileges control the ability to run SQL statements with the database and my role has been to outline those privileges for our end users. Then, roles group together different privileges for each end user. In my past work, I'm most familiar with creating the different roles within the system and then working with key decision makes with our end users to grant the privileges to the roles we defined."
View All 28 e-Zest Solutions Questions and Answers
Sign up to access our library of 50,000+ Q&As,
plus coaches for one-on-one support, so you can interview more confidently.
More Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
Suggested Career
Interview Q&As
Continue practicing by visiting these similar question sets
Software Developer
Web Developer
Web Architect
Computer Programmer
Computer Scientist
About Our Interview Q&As
Our interview questions and answers are created by experienced recruiters and interviewers. These questions and answers do not represent any organization, school, or company on our site. We do not claim they will be asked in any interview you may have. Our goal is to create interview questions and answers that will best prepare you for your interview, and that means we do not want you to memorize our answers. You must create your own answers, and be prepared for any interview question in any interview.