Tata Group DB2 Database Administrator Interview Questions and Answers

It was moderate for selection

Q1. Don't remember as more than year had passed
Add your answer
Q2. Scenarios based question
Add your answer

Q1. Brief intro about self,studies and all
Add your answer
Q2. Regarding relocation and all
Add your answer

Q1. Intro and asked about strength and weakness
Add your answer
Q2. Don't remember
Add your answer

Q1. Sql related queries
Add your answer
Q2. Database maintenance
Add your answer
Q3. Monitoring and performance tuning
Add your answer

Q1. In deep related to queries
Add your answer
Q2. Backup and recovery
Add your answer

Q1. Dataguard architecture
Add your answer
Q2. Rman backup and restoration
Add your answer

Q1. Why you join inm
Ans. 
I joined inm because of the company's reputation for innovation and growth in the tech industry.
• Attracted to company's reputation for innovation

• Excited about opportunities for growth in tech industry

• Impressed by company culture and values
Answered by AI
Add your answer

Q1. What is database architecture?
Ans. 
Database architecture refers to the design and structure of a database system.
• Database architecture includes the organization of data, storage, retrieval, and security mechanisms.

• It involves defining the relationships between data elements and how they are stored and accessed.

• Examples of database architectures include hierarchical, network, relational, and object-oriented.

• Database architecture also includes the choice ...read more
Answered by AI
Add your answer
Q2. Difference between delete and truncate
Ans. 
Delete removes rows one by one, while truncate removes all rows at once.
• Delete is a DML command, while truncate is a DDL command.

• Delete can be rolled back, while truncate cannot be rolled back.

• Delete fires triggers, while truncate does not fire triggers.

• Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.

• Example: DELETE FROM table_name WHERE condi
Answered by AI
Add your answer

Q1. Architecture of sql
Ans. 
SQL architecture refers to the structure and components of a SQL database system.
• SQL architecture includes components like storage engine, query processor, and buffer manager.

• The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

• The buffer manager handles caching and memory management to optimize performance.

• Examples of SQL architectures include MySQL, Oracle, and SQL Se
Answered by AI
Add your answer
Q2. Recovery models
Add your answer

Q1. How would you monitor a db performance with OEM AWR report?
Ans. 
Monitoring db performance using OEM AWR report
• Access OEM console and navigate to Performance tab

• Select AWR report option to generate a report

• Analyze the report for key performance metrics like CPU usage, memory utilization, I/O stats

• Identify any performance bottlenecks and take necessary actions to optimize db performance
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

Q1. About oracle database functionality
Add your answer

Q1. Salary discussion
Add your answer