Infosys Oracle Apps DBA Interview Questions and Answers

Q1. Tell me the high level overview of dataguard installation?
Add your answer
Q2. What are your daily tasks adn what things you handel in your team?
Add your answer

Q1. What is pull request
Ans. 
A pull request is a method of submitting contributions to a project on GitHub for review and merging.
• Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

• They allow developers to collaborate and discuss changes before merging them into the main branch.

• Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

• Rev...read more
Answered by AI
Add your answer

Q1. What is sateful set
Ans. 
Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.
• Stateful set ensures that each pod in the set has a unique identity and stable network identity.

• Stateful set pods are created in order and are not replaced until they are deleted.

• Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

• Example:...read more
Answered by AI
Add your answer

Q1. Start up parameters of sql server
Ans. 
Start up parameters are used to configure the behavior of SQL Server when it starts up.
• Start up parameters are specified in the SQL Server Configuration Manager.

• Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

• Start up parameters can be modified to customize the behavior of SQL Server during startup.

• Example: -dC:\Program Files\Microso...read more
Answered by AI
Add your answer
Q2. Differential backup query
Add your answer
Q3. Sql server statics
Add your answer
Q4. Log file architecture
Add your answer

Sql queries on top clause

Q1. Why u want to join
Ans. 
I am passionate about database management and eager to contribute my skills to your team.
• I have a strong background in database administration

• I am excited about the opportunity to work with a reputable company like yours

• I am eager to learn and grow in my career as a SQL DBA
Answered by AI
Add your answer
Q2. What is the salary expectation
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
• Research the average salary range for MS SQL DBAs in your location and industry

• Consider your years of experience and any specialized skills or certifications you have

• Be prepared to negotiate based on the specific responsibilities and requirements of the role
Answered by AI
Add your answer

Q1. Why this company
Ans. 
I am impressed by the company's innovative technology solutions and strong reputation in the industry.
• The company has a track record of developing cutting-edge technology solutions.

• I admire the company's commitment to excellence and continuous improvement.

• The company's reputation for providing top-notch training and development opportunities is appealing to me.
Answered by AI
Add your answer
Q2. What salary do you expect
Ans. 
I expect a competitive salary based on my experience, skills, and the market rate for Oracle Database Administrators.
• Research the average salary range for Oracle Database Administrators in your area

• Consider your level of experience and skills when determining your salary expectations

• Be prepared to negotiate based on the specific responsibilities and benefits offered by the employer
Answered by AI
Add your answer

Q1. Tell about yourself
Ans. 
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
• 5+ years of experience as an Oracle DBA

• Proficient in database management, performance optimization, and data security

• Skilled in troubleshooting and resolving database issues

• Strong knowledge of Oracle database architecture and SQL

• Certified Oracle Database Administrator (OCA/OCP)
Answered by AI
Add your answer