Add office photos
Filter interviews by
Chain-Sys Oracle Technical Consultant Interview Questions and Answers
Updated
19 Jan 2024
Chain-Sys Oracle Technical Consultant Interview Experiences
3 interviews found
I applied via Walk-in and was interviewed in Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Oracle sql technical like joins, Subquery, constraints, dml, ddl, tcl statements, procedures and functions
- Ans. Definitions and explanations gave for all above questions
Answered
Anonymously
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Just prepared well for technical, you can learn many new things from here.
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
-
Result
-
I was interviewed in Dec 2023.
Round 1 - Technical
(2 Questions)
- Q1. Self introduction , about previous project And related questions in previous project
- Q2. Function , DML , function syntax, d/w drop and delete
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be bold and study well
Interview experience
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Aptitude Test
Basic Aptitude test which you can clear easily
Round 3 - Coding Test
Just be confident and it will be basic and intermediate topic on sql and plsql
Interview Preparation Tips
Interview preparation tips for other job seekers - Learn the basics of sql/plsql and you'll be able to clear interview easily
Top trending discussions
View All
Salary Discussions, Hike & Promotions
2w
a senior consultant
Retention offer
Hello,
Current offer from CG - Total 21.5L, fixed as 19.4 and rest bonus
Retention offer from Deloitte - Total 19.1, fixed as 15.5 and rest bonus (4L)
I understand the offer is less but my manager explained that Deloitte's hikes are better in the market and on an average, I can get 15% every year with good performance.
The same hikes in CG are around 5-6% so financially, my salary growth will definitely be more in Deloitte.
Please give me suggestions. I have good management and projects in Deloitte with WLB but I would like to have some perspective on offered CTC too
Got a question about Chain-Sys?
Ask anonymously on communities.
Interview questions from similar companies
Oracle Database Administrator Interview Questions & Answers
Solugenix India Private Limited
Anonymous
posted on 3 Oct 2021
Interview Questionnaire
4 Questions
- Q1. Need more concentrate on performance tuning, golden gate, restores
- Q2. Strong in core dba
- Ans.
Being strong in core DBA means having a deep understanding of database architecture, performance tuning, backup and recovery, and security.
Proficient in SQL and PL/SQL
Expertise in database installation, configuration, and maintenance
Skilled in performance tuning and optimization
Experience in backup and recovery procedures
Knowledge of database security and access control
Familiarity with database monitoring and troublesh...
- Q3. Strong in OEM
- Ans.
OEM is Oracle Enterprise Manager, a tool for managing Oracle databases.
Strong knowledge of OEM is essential for effective database administration
Ability to configure and customize OEM for specific needs
Experience with using OEM for performance tuning and monitoring
Familiarity with OEM's various features, such as backup and recovery, security, and patching
Knowledge of how to troubleshoot issues with OEM
- Q4. Core dba tasks
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - be strong in core dba and other topics also
Oracle Database Administrator Interview Questions & Answers
Solugenix India Private Limited
Anonymous
posted on 30 Jan 2023
Interview experience
Bad
Difficulty level
Hard
Process Duration
4-6 weeks
Result
Selected
I applied via Approached by Company and was interviewed before Jan 2022. There was 1 interview round.
Round 1 - Technical
(3 Questions)
- Q1. Nothing related to project. no rac in project but asked all questions on rac.
- Ans. You need to have 15 years in 6 years.
- Q2. You applied for junior position ? hahahaha
- Q3. You understand right
Answered
Anonymously
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - you should be over talented to crack the interview.
Senior Oracle Database Administrator Interview Questions & Answers
Solugenix India Private Limited
Anonymous
posted on 7 Oct 2020
I applied via Recruitment Consultant and was interviewed in Sep 2020. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Good technical discussion on Oracle database technology like RMAN, Dataguard, Performance tuning, Upgrades, Patching.
- Q2. Delivery Lead Role responsibilities
- Q3. Resource Manager Role responsibilities
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I was contacted by Suseela Budda from Solugenix HR Team for senior oracle dba role on 28th Aug 2020 via email. we had discussion on job position and my profile details on 2nd Sep 2020. Later my interview was scheduled thru Microsoft Teams video for the 1st round of technical discussion on 4th Sep 2020 about 45 mins and cleared the same.
2nd round of technical discussion scheduled on 8th Sep 2020 and rescheduled to 9th Sep 2020 due to Panel unavailability. Had cleared the interview (35 Mins) on next day 9th Sep 2020. 3rd round of interview with Director Madhu scheduled on 11th Sep 2020 for 1 hr. HR called me on 16th Sep 2020 and greeted that i have cleared all rounds of interviews. Need all education and experiences documents and i have shared all docs by next day. HR called me again on 18th Sep 2020 to inform me that Director round feedback is shared and am selected for Lead DBA role due to my Resource Management skills and Delivery Skills. Also informed that offer discussion will be happening next week with HR manager.
I waited for 10 days for HR Manager/HR Recruiter to come back and i did not get any response and i tried reaching them several times.
upon calling 2-3 times Suseela HR picked my call and informed that offer is pending due to Director Madhu has fallen sick due to COVID-19 and had to wait for next week to get approval to release offer letter.
Also she suggested me to look into other opportunities.
This is my pathetic experience with Solugenix India.
My question is -
1) if project sow is not signed and trying to recruit upfront and wasting my time and their time.
else
2) Are they misusing my education/experience/ID proofs (Original Photo Copy) for other purpose.
Am just concerned about this and i strongly do not recommend this company for interviews.
Regards,
Naresh Thummeti
2nd round of technical discussion scheduled on 8th Sep 2020 and rescheduled to 9th Sep 2020 due to Panel unavailability. Had cleared the interview (35 Mins) on next day 9th Sep 2020. 3rd round of interview with Director Madhu scheduled on 11th Sep 2020 for 1 hr. HR called me on 16th Sep 2020 and greeted that i have cleared all rounds of interviews. Need all education and experiences documents and i have shared all docs by next day. HR called me again on 18th Sep 2020 to inform me that Director round feedback is shared and am selected for Lead DBA role due to my Resource Management skills and Delivery Skills. Also informed that offer discussion will be happening next week with HR manager.
I waited for 10 days for HR Manager/HR Recruiter to come back and i did not get any response and i tried reaching them several times.
upon calling 2-3 times Suseela HR picked my call and informed that offer is pending due to Director Madhu has fallen sick due to COVID-19 and had to wait for next week to get approval to release offer letter.
Also she suggested me to look into other opportunities.
This is my pathetic experience with Solugenix India.
My question is -
1) if project sow is not signed and trying to recruit upfront and wasting my time and their time.
else
2) Are they misusing my education/experience/ID proofs (Original Photo Copy) for other purpose.
Am just concerned about this and i strongly do not recommend this company for interviews.
Regards,
Naresh Thummeti
Chain-Sys Interview FAQs
How many rounds are there in Chain-Sys Oracle Technical Consultant interview?
Chain-Sys interview process usually has 2 rounds. The most common rounds in the Chain-Sys interview process are Resume Shortlist, Aptitude Test and Coding Test.
How to prepare for Chain-Sys Oracle Technical Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Chain-Sys. The most common topics and skills that interviewers at Chain-Sys expect are Oracle Apps, Oracle Apps Technical, R12, Data Extraction and O2C.
What are the top questions asked in Chain-Sys Oracle Technical Consultant interview?
Tell us how to improve this page.
Chain-Sys Interviews By Designations
- Chain-Sys Oracle Technical Consultant Interview Questions
- Chain-Sys Programmer Interview Questions
- Chain-Sys Software Developer Interview Questions
- Chain-Sys Associate Functional Consultant Interview Questions
- Chain-Sys Data Engineer Interview Questions
- Chain-Sys Oracle Financial Functional Consultant Interview Questions
- Chain-Sys SAP Consultant Interview Questions
- Chain-Sys Software Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle SCM Functional Consultant Interview Questions
- Oracle Database Administrator Interview Questions
- Oracle Functional Consultant Interview Questions
- Oracle Financial Functional Consultant Interview Questions
- Oracle Application Technical Consultant Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- Oracle Developer Interview Questions
- Oracle Consultant Interview Questions
- Show more
People are getting interviews through
based on 1 Chain-Sys interview
WalkIn
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Interview Questions from Similar Companies
Fast track your campus placements
40%
less
than the average Oracle Technical Consultant Salary in India
View more details
Chain-Sys Oracle Technical Consultant Reviews and Ratings
based on 3 reviews
Rating in categories
|
Associate Consultant
110
salaries
|  ₹2.9 L/yr - ₹9.5 L/yr |
|
Oracle Technical Consultant
68
salaries
| ₹2.3 L/yr - ₹7.8 L/yr |
|
Programmer
62
salaries
| ₹3 L/yr - ₹7.2 L/yr |
|
Test Engineer
58
salaries
| ₹2.5 L/yr - ₹6 L/yr |
|
Software Analyst
53
salaries
| ₹4 L/yr - ₹8 L/yr |
Explore more salaries
Compare Chain-Sys with
Infosys
Compare
TCS
Compare
Wipro
Compare
HCLTech
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Chain-Sys Interview Questions >
- Chain-Sys Oracle Technical Consultant Interview Questions
Share an Interview