5 CMS IT Services Oracle Database Administrator Interview Questions & Answers | Complete Prep Guide 2025

CMS IT Services Oracle Database Administrator Interview Experiences

1 interview found

Oracle Database Administrator Interview Questions & Answers

posted on 19 Dec 2022

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 Resume tips

Round 2 - Technical

(5 Questions)

Q1. How oracle architecture is work. How to check if user password expired If dataguard not in synch what steps to follow and synch the standby database from primary. What is ASM and how to start and stop ASM....

Ans.

Oracle architecture is a multi-tiered structure that includes the client, application server, and database server.

Oracle architecture consists of multiple components such as the client, application server, and database server.
The client sends requests to the application server, which in turn communicates with the database server.
The database server manages the storage, retrieval, and manipulation of data.
Oracle archite...

Answered by AI

Add your answer

Q2. What is SGA and PGA?

Ans.

SGA (System Global Area) is a shared memory region that stores data and control information for an Oracle database. PGA (Program Global Area) is a memory region that stores data and control information for a single Oracle session or process.

SGA is shared by all users and processes connected to the database
SGA includes the database buffer cache, shared pool, and redo log buffer
PGA is private to each individual session o...

Answered by AI

Add your answer

Q3. What is Dataguard and standby?

Ans.

Dataguard is a feature of Oracle Database that provides high availability, data protection, and disaster recovery.

Dataguard is used to create and maintain one or more standby databases that can be used for failover or disaster recovery purposes.
It works by continuously applying changes from the primary database to the standby database(s) to keep them synchronized.
In case of a failure or disaster, the standby database c...

Answered by AI

Add your answer

Q4. What is difference between TNS and LISTENER?

Ans.

TNS is a network protocol used to connect to Oracle databases, while LISTENER is a process that listens for incoming connection requests.

TNS (Transparent Network Substrate) is a protocol used to establish connections between clients and Oracle databases.
LISTENER is a process that runs on the database server and listens for incoming connection requests.
TNS resolves the service name to the database's network address, all...

Answered by AI

Add your answer

Q5. How to start RFS and MRP Service.

Ans.

To start RFS and MRP Service in Oracle Database, you can use the ALTER SYSTEM command.

Connect to the Oracle Database as a user with SYSDBA or SYSOPER privilege.
To start RFS (Remote File Server) Service, execute the following command: ALTER SYSTEM SET REMOTE_LISTENER='listener_name' SCOPE=SPFILE;
To start MRP (Managed Recovery Process) Service, execute the following command: ALTER DATABASE RECOVER MANAGED STANDBY DATABAS

Answered by AI

Add your answer

Skills evaluated in this interview

Top trending discussions

View All

Salary Discussions, Hike & Promotions

I have got an offer of 34 LPA from TCS and Capgemini . I have 11 years of experience , Azure Developer. Can you please guide / suggest which company should I join . I am confused since both are offering the s... read more

Got a question about CMS IT Services?

Ask anonymously on communities.

Interview questions from similar companies

Software Engineer Interview Questions & Answers

Wipro

Anonymous

posted on 16 Sep 2021

I was interviewed before Sep 2020.

Round 1 - Coding Test

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

Q1.

Sum of Two Numbers Represented as Arrays

Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

Ans.

Given two numbers represented as arrays, calculate their sum and return the result as an array.

Iterate through the arrays from right to left, adding digits and carrying over if necessary
Handle cases where one array is longer than the other by considering the remaining digits
Ensure the final sum array does not have any leading zeros

Answered by AI

Add your answer

Round 2 - Face to Face

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 10 Feb 2021

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire

1 Question

Q1. Hr

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 31 Jan 2021

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire

1 Question

Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Always try to take risk in small problems . When you face the consequences, you would be able to tackle bigger problems.
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.

Software Engineer Interview Questions & Answers

TCS

Anonymous

posted on 23 Jun 2021

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire

1 Question

Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 12 Jan 2022

I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire

1 Question

Q1. Oops Concepts,JAVA 8

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Quite simple and easy. 1st round technical.2nd round HR

Software Engineer Interview Questions & Answers

HCLTech

Anonymous

posted on 20 Aug 2022

I applied via Campus Placement and was interviewed before Aug 2021. 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 Resume tips

Round 2 - Coding Test

Easy DSA questions and some questions on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join if you are a fresher and want to grow as a developer. I had resigned that time I am writing this review

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 9 Sep 2020

I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire

1 Question

Q1. How do you get the second to last element from a SQL table?

Ans.

To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

Software Engineer Interview Questions & Answers

HCLTech

Anonymous

posted on 16 Aug 2022

I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - Technical

(1 Question)

Q1. C language and Java questions

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be ready with good technical skills to face the interview

Software Engineer Interview Questions & Answers

Infosys

Anonymous

posted on 15 Apr 2021

Interview Questionnaire

1 Question

Q1. Drupal data migration

Add your answer

CMS IT Services Interview FAQs

How many rounds are there in CMS IT Services Oracle Database Administrator interview?

CMS IT Services interview process usually has 2 rounds. The most common rounds in the CMS IT Services interview process are Resume Shortlist and Technical.

How to prepare for CMS IT Services Oracle Database Administrator 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 CMS IT Services. The most common topics and skills that interviewers at CMS IT Services expect are Oracle DBA, Database Administration, RAC, RMAN and Dataguard.

What are the top questions asked in CMS IT Services Oracle Database Administrator interview?

Some of the top questions asked at the CMS IT Services Oracle Database Administrator interview -

How oracle architecture is work. How to check if user password expired If datag...read more
What is difference between TNS and LISTEN...read more
How to start RFS and MRP Servi...read more

Desktop Support Engineer 958 salaries	₹0 L/yr - ₹0 L/yr
Engineer- Customer Support 643 salaries	₹0 L/yr - ₹0 L/yr
Network Engineer 336 salaries	₹0 L/yr - ₹0 L/yr
Technical Support Engineer 300 salaries	₹0 L/yr - ₹0 L/yr
System Administrator 238 salaries	₹0 L/yr - ₹0 L/yr

CMS IT Services Oracle Database Administrator Interview Questions, Process, and Tips

CMS IT Services Oracle Database Administrator Interview Experiences

1 interview found

(5 Questions)

Skills evaluated in this interview

Interview questions from similar companies

(1 Question)

Sum of Two Numbers Represented as Arrays

Interview Preparation Tips

Skills evaluated in this interview

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Interview Preparation Tips

Interview Questionnaire

1 Question

Interview Preparation Tips

Skills evaluated in this interview

(1 Question)

Interview Preparation Tips

Interview Questionnaire

1 Question

CMS IT Services Interview FAQs

Recently Viewed

InsuranceDekho

Credit Bajaar

CMS IT Services

Bharat Petroleum

Bharat Petroleum

Bharat Petroleum

Bharat Petroleum

Bharat Petroleum

CMS IT Services

Bharat Petroleum

Tell us how to improve this page.

CMS IT Services Interviews By Designations

Interview Questions for Popular Designations

Oracle Database Administrator Interview Questions from Similar Companies

Fast track your campus placements