Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Conacent Consulting Team. If you also belong to the team, you can get access from here

Conacent Consulting Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Conacent Consulting Oracle Database Administrator Interview Questions and Answers

Updated 13 Mar 2021

Conacent Consulting Oracle Database Administrator Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Sep 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic architecture of Oracle rdbms 11g.
  • Ans. 

    Oracle rdbms 11g has a client-server architecture with a shared memory buffer cache.

    • Client-server architecture

    • Shared memory buffer cache

    • Background processes

    • Data files and redo log files

    • Control files

    • Instance and database

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to know how things going on around server and Oracle database.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.

Round 1 - Assignment 

Database Management system SQL and PlSQL

Round 2 - Assignment 

Database Base Management system SQL and PlSQL

Round 3 - Aptitude Test 

Database Management system

Round 4 - Aptitude Test 

Database Management system

Round 5 - Group Discussion 

Database Management system

Round 6 - Assignment 

Database Management system

Round 7 - Case Study 

Database Base Management system

Round 8 - HR 

(5 Questions)

  • Q1. Database Management system
  • Q2. SQL and PlSQL Mango Data And Manu Database Management system
  • Q3. C Language and C++Language and Java
  • Q4. Data Analysis and Data entry
  • Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP

Interview Preparation Tips

Interview preparation tips for other job seekers - Database Management system SQL and PlSQL and C Language and C++Language and Java And Web design and Web Developer
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How to sync primary and standby?
  • Ans. 

    Primary and standby databases can be synced using Data Guard in Oracle.

    • Configure Data Guard on primary and standby databases

    • Enable redo transport services

    • Monitor and resolve any synchronization issues

    • Perform switchover or failover when necessary

  • Answered by AI
  • Q2. Performance tuning?
Round 2 - HR 

(2 Questions)

  • Q1. Why you want to change the job?
  • Ans. 

    Seeking new challenges and growth opportunities in a dynamic environment.

    • Looking for new challenges to enhance my skills and knowledge

    • Seeking growth opportunities for career advancement

    • Interested in working in a more dynamic and innovative environment

  • Answered by AI
  • Q2. Expected salary.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Self about my fis experience
  • Q2. Tell about my contribution

Interview Preparation Tips

Interview preparation tips for other job seekers - No need
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. About oracle database functionality
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Are you aware of DevOp? How to use in producing output for client?
  • Ans. 

    Yes, DevOps is a set of practices that combines software development and IT operations to deliver high-quality software faster.

    • DevOps is a culture and set of practices that emphasizes collaboration, automation, and monitoring throughout the software development lifecycle.

    • It involves integrating development, testing, deployment, and operations teams to streamline the software delivery process.

    • By using DevOps, database a...

  • Answered by AI
  • Q2. What is the application that is better than Spark in AWS?
  • Ans. 

    AWS Glue is an application that is better than Spark in AWS.

    • AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load data for analytics.

    • It provides a serverless environment for running ETL jobs and supports various data sources and destinations.

    • AWS Glue also offers automatic schema discovery, data cataloging, and data transformation capabilities.

    • It integrates well wi...

  • Answered by AI
  • Q3. How do you connect to to AWS as a developer?
  • Ans. 

    To connect to AWS as a developer, you can use the AWS Management Console, AWS CLI, or AWS SDKs.

    • Use the AWS Management Console to access AWS services through a web-based user interface.

    • Utilize the AWS Command Line Interface (CLI) to interact with AWS services using commands in the terminal.

    • Leverage AWS Software Development Kits (SDKs) to integrate AWS services into your applications.

    • For example, you can use the AWS SDK ...

  • Answered by AI
  • Q4. What is the security system of AWS access?
  • Ans. 

    AWS provides a comprehensive security system for access control.

    • AWS Identity and Access Management (IAM) allows you to manage access to AWS services and resources.

    • IAM enables you to create and manage users, groups, and roles, and assign permissions to them.

    • AWS provides various authentication methods like username/password, multi-factor authentication, and integration with external identity providers.

    • Access can be contr...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Sometimes the interviewer can be a glober - who really doesn't know what they are talking about. They will even ask you what they do not know. They can even ask you things that are NOT applicable and they will stand with it to show that they know better. Above all as a candidate for the role that you really want to go with, ensure that you are aware of what you say, be prepared for the interview as if you know nothing. Ensure that you are well informed on the line of task. Also be prepated to provide the interviewer one good project that you had already carried out based on the application required for the profile. Be calm always if the company recruit you, it is their luck as you always have ample opportunity with other company as well.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. HADR,PERFORMANCE TUNING

I applied via Referral and was interviewed in Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Expert level SQL knowledge,questions on SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and if you don't know the answer asked in interview do not panic
Just assure the interviewer that ur ready to learn anything given an opportunity
Do not fake or do not show the desperation for the job
Never tell yes to everything
Provide a stipulated time for you to learn the process
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.

Round 1 - Assignment 

Database Management system SQL and PlSQL

Round 2 - Assignment 

Database Base Management system SQL and PlSQL

Round 3 - Aptitude Test 

Database Management system

Round 4 - Aptitude Test 

Database Management system

Round 5 - Group Discussion 

Database Management system

Round 6 - Assignment 

Database Management system

Round 7 - Case Study 

Database Base Management system

Round 8 - HR 

(5 Questions)

  • Q1. Database Management system
  • Q2. SQL and PlSQL Mango Data And Manu Database Management system
  • Q3. C Language and C++Language and Java
  • Q4. Data Analysis and Data entry
  • Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP

Interview Preparation Tips

Interview preparation tips for other job seekers - Database Management system SQL and PlSQL and C Language and C++Language and Java And Web design and Web Developer
Round 1 - One-on-one 

(3 Questions)

  • Q1. Tell me about your roles and responsibilities
  • Q2. How to add diskgroup in disks
  • Ans. 

    To add a diskgroup in disks, use the CREATE DISKGROUP command in Oracle ASM.

    • Ensure that the disks are initialized and partitioned

    • Use the ASMCA (ASM Configuration Assistant) or ASMCMD (ASM Command-Line Utility) to create the diskgroup

    • Specify the diskgroup name, redundancy level, and the disks to be included in the diskgroup

    • Example: CREATE DISKGROUP dg1 NORMAL REDUNDANCY DISK '/dev/sdb1', '/dev/sdc1'

  • Answered by AI
  • Q3. What will do in Real application cluater
  • Ans. 

    Real Application Cluster (RAC) is a cluster database with shared disk architecture.

    • RAC allows multiple instances to access a single database simultaneously.

    • It provides high availability and scalability.

    • RAC uses Oracle Clusterware to manage the cluster.

    • Load balancing and failover are automatic in RAC.

    • RAC requires additional hardware and software licenses.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Work hard automatically sucess will come

Skills evaluated in this interview

Tell us how to improve this page.

Conacent Consulting Oracle Database Administrator Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Junior Consultant
22 salaries
unlock blur

₹1 L/yr - ₹6 L/yr

Associate Consultant
16 salaries
unlock blur

₹2.8 L/yr - ₹11.8 L/yr

Consultant
8 salaries
unlock blur

₹2.8 L/yr - ₹9.4 L/yr

Software Developer
7 salaries
unlock blur

₹2.5 L/yr - ₹3.5 L/yr

Oracle Technical Consultant
6 salaries
unlock blur

₹2 L/yr - ₹6.5 L/yr

Explore more salaries
Compare Conacent Consulting with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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