IBM Senior Cognos Developer Interview Questions and Answers

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. Data stage scenario
Add your answer
Q2. Difference between Data Stage and informatica
Ans. 
Data Stage is an ETL tool by IBM, while Informatica is a popular ETL tool by Informatica Corporation.
• Data Stage is developed by IBM, while Informatica is developed by Informatica Corporation.

• Data Stage is known for its parallel processing capabilities, while Informatica is known for its ease of use and flexibility.

• Data Stage has a graphical interface for designing jobs, while Informatica uses a more traditional workflo...read more
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. Basic questions about datastage Like difference between lookup,merge,join Questions with dataset and sequential stage. Then few questions asked on transformer stage.
Add your answer
Q2. Remove duplicate using datastage
Ans. 
Use Datastage to remove duplicates from a dataset
• Use a Remove Duplicates stage in Datastage to eliminate duplicate records

• Configure the Remove Duplicates stage to identify and remove duplicates based on specific key columns

• Ensure that the dataset is sorted properly before applying the Remove Duplicates stage
Answered by AI
Add your answer

Q1. In second round most they focused on scenario based questions in both datastage and SQL.
Add your answer

Q1. Salary and location discussion
Add your answer

Online screening test before technical round

Q1. Oracle DBA architecture
Add your answer
Q2. Basic questions of Oracle
Add your answer

Q1. Basic questions
Add your answer

Q1. Asking over past experience
Add your answer
Q2. RAC and GG related questions. Data guard gap resolve. RMAN scenario based question. Oracle architecture.
Add your answer

Q1. About project worked on
Add your answer
Q2. Skill set questions based on what you are worked on
Add your answer

Q1. Compansation Discussion
Add your answer