Upload Button Icon Add office photos

Filter interviews by

Greystar Oracle Technical Consultant Interview Questions, Process, and Tips

Updated 10 Feb 2024

Greystar Oracle Technical Consultant Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. What is concurrent program, steps to register
  • Ans. 

    A concurrent program is a program that can be run simultaneously with other programs. Steps to register a concurrent program include defining the program, creating a concurrent program executable, and registering the program with Oracle Applications.

    • Define the concurrent program by specifying its name, short name, application, and other details

    • Create a concurrent program executable by specifying the program's execution...

  • Answered by AI
  • Q2. Difference between procedure and functions
  • Ans. 

    Procedures and functions are both stored program units in Oracle. Procedures are used to perform an action, while functions return a value.

    • Procedures are used to perform a specific action or set of actions, while functions are used to return a single value.

    • Procedures do not return values, while functions always return a value.

    • Procedures can have input and output parameters, while functions can only have input parameter...

  • Answered by AI
  • Q3. What is triggers ?
  • Ans. 

    Triggers are database objects that are automatically executed in response to specified events.

    • Triggers are used to enforce business rules, maintain data integrity, and automate tasks.

    • They can be defined to execute before or after an event like insert, update, or delete.

    • Triggers can be written in PL/SQL or Java.

    • Examples of triggers include auditing changes to a table, updating related records, or validating data before

  • Answered by AI
  • Q4. What is flex fields
  • Ans. 

    Flex fields are customizable fields in Oracle applications that allow users to capture additional data specific to their business needs.

    • Flex fields are used to extend the functionality of Oracle applications by adding custom fields.

    • They can be configured to capture different types of data, such as text, numbers, dates, or even images.

    • Flex fields provide a flexible and scalable solution for organizations to adapt their ...

  • Answered by AI
  • Q5. What is exceptions ?
  • Ans. 

    Exceptions are events that occur during the execution of a program and disrupt the normal flow of instructions.

    • Exceptions are used to handle errors and abnormal conditions in a program.

    • They allow the program to gracefully handle unexpected situations.

    • Exceptions can be thrown and caught, allowing for error handling and recovery.

    • They can be categorized into different types, such as checked and unchecked exceptions.

    • Exampl...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Many questions about sales.

Interview Preparation Tips

Interview preparation tips for other job seekers - Great

Interview Questionnaire 

1 Question

  • Q1. General Questions about background and MBA

Interview Preparation Tips

Round: Group Discussion
Experience: Knowing most of the people in my group discussion made it a little easier for me. The group digressed from the topic a few times but there was no ruckus after-all.
Tips: Note the points on a paper that you want to say during the GD.
Maintain eye contact with everyone.
When the coordinator asks you to summarize the GD, never start with "I think". Just summaries it. No value additions at this stage.
Dont speak for the sake of it. Dont be loud. Let your points be loud.
And finally, using statements like," let the gentle man complete his point", "please maintain the decorum", do work. ;)
Duration: 10 minutes

Round: HR Interview
Experience: The interviewers are really experienced and they will somehow always know when you are lying. In my case specifically, it was a very general interview and it was more focused on the fact if i will be able to sustain the work pressure.
Tips: Be honest.
SMILE.
If you dont know something, be honest about it and tell them you will learn it at the first moment possible.
Know about the company as much as possible.
Rest is really cool.

General Tips: Dress properly.
Shave. {And if a female, then look good. (I know that you already take care of that)}
Always carry a pen.
If asked for some concept, and if it can be explained on paper, DO THAT, it shows your concepts are clear.
Dont fumble or guess. If you dont know it, just say it.
Skill Tips: Practice talking to your peer regularly. Improvise upon your confidence. Make sure that the company needs you more than you need the company.
Skills: Communication , Presentation skills
College Name: KJ SOMAIYA INSTITUTE OF MANAGEMENT STUDIES AND RESEARCH
Motivation: Real estate. I like this sector.
Fortune 500 company and world leader in its sector.
Funny Moments: During the technical interview, the interviewer asked me to tell him any 5 core finance questions. My own choice. And later, he asked me only to answer them.
So basically, i took my own technical interview.

I applied via Naukri.com and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. The angle subtended on a clock when the time is 3.20
  • Ans. 

    The angle subtended on a clock when the time is 3.20 is 40 degrees.

    • To find the angle subtended, we need to calculate the difference between the hour and minute hands.

    • At 3:00, the hour hand is at 90 degrees and the minute hand is at 0 degrees.

    • For every minute, the minute hand moves 6 degrees.

    • At 20 minutes past 3, the minute hand would have moved 20 * 6 = 120 degrees.

    • The hour hand also moves slightly. In 20 minutes, it m...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure you read up on the company and its performance/ activities so that you may make relevant points during interview
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me something about yourself.
  • Q2. Where do you see yourself after 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Introduce yourself
  • Q2. Last ctc and location
  • Ans. 

    My last CTC was $90,000 and I was located in New York City.

    • Last CTC: $90,000

    • Location: New York City

  • Answered by AI
Round 2 - Aptitude Test 

It was confidential, related to knowledge and skill.

Round 3 - One-on-one 

(4 Questions)

  • Q1. Introduce youself
  • Q2. What is your experience, brief your role
  • Q3. I was given a situation to tackle with my knowledge and experience.
  • Q4. I was asked for salary expectation.

Interview Preparation Tips

Topics to prepare for NoBroker Senior Associate interview:
  • customer support
  • Escalation Management
Interview preparation tips for other job seekers - After selection, one skill test and mock test will be lined up for further step.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

A masterplan exercise was given to the candidates

Round 2 - Technical 

(2 Questions)

  • Q1. Experience to support the job requirements
  • Ans. 

    I have over 10 years of experience in consulting, with a focus on project management, client relations, and problem-solving.

    • Managed multiple projects simultaneously, ensuring deadlines were met and budgets were adhered to

    • Developed strong relationships with clients, leading to repeat business and referrals

    • Utilized problem-solving skills to identify and address issues within projects, resulting in successful outcomes

    • Led ...

  • Answered by AI
  • Q2. Tell me a little about myself yourself
  • Ans. 

    Experienced Senior Consultant with a background in project management and client relations.

    • Over 10 years of experience in consulting roles

    • Strong project management skills, including leading cross-functional teams

    • Proven track record of building and maintaining client relationships

    • Expertise in developing and implementing strategic business solutions

    • Excellent communication and presentation skills

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Base location preferences
  • Q2. Notice period
Interview experience
3
Average
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Aug 2022. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. Tell about yourself
  • Q2. Why did you apply at CBRE
  • Q3. They will test your real estate knowledge
  • Q4. How much do you know about market
  • Ans. 

    I have a strong understanding of market trends, competition, consumer behavior, and industry dynamics.

    • I regularly analyze market reports, industry news, and competitor strategies to stay informed.

    • I have experience conducting market research, identifying target markets, and developing marketing strategies.

    • I understand the importance of staying updated on market trends and adapting strategies accordingly.

    • I have successfu...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - They just see if you have people skills and are presentable- for sales profile.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Dec 2023. There were 4 interview rounds.

Round 1 - Aptitude Test 

30 minutes aptitude test having maths, English and reasoning

Round 2 - Group Discussion 

Group of 6 group discussion round with 2 people

Round 3 - Case Study 

20 minute case based interview

Round 4 - HR 

(3 Questions)

  • Q1. Both technical and HR round
  • Q2. Tell me about yourself
  • Q3. Porter 5 forces
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about your job responsibilities?
  • Q2. Why do you wanna switch?

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare questions as per your previous job role they will ask you about you current or previous roles and responsibilities and some basic questions of accounting some golden rules and journal entries.

Greystar Interview FAQs

How many rounds are there in Greystar Oracle Technical Consultant interview?
Greystar interview process usually has 1 rounds. The most common rounds in the Greystar interview process are Technical.
What are the top questions asked in Greystar Oracle Technical Consultant interview?

Some of the top questions asked at the Greystar Oracle Technical Consultant interview -

  1. What is concurrent program, steps to regis...read more
  2. difference between procedure and functi...read more
  3. what is trigger...read more

Tell us how to improve this page.

Greystar Oracle Technical Consultant Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

JLL Interview Questions
4.1
 • 351 Interviews
CBRE Interview Questions
4.2
 • 263 Interviews
NoBroker Interview Questions
3.1
 • 232 Interviews
Sobha Interview Questions
3.9
 • 127 Interviews
Lodha Group Interview Questions
4.0
 • 125 Interviews
DLF Interview Questions
3.9
 • 74 Interviews
View all
Senior Associate
43 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
12 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Accountant
12 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Greystar with

JLL

4.1
Compare

CBRE

4.2
Compare

NoBroker

3.2
Compare

Sobha

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview