ITC Infotech Senior Database Administrator Interview Questions and Answers

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
Add your answer
Q2. Performance tuning?
Add your answer

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
Add your answer
Q2. Expected salary.
Add your answer

Q1. Static and dynamic polymorphism
Add your answer
Q2. Code snipts related to prefix and postfix
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

It was good interview everyone was friendly

Q1. Why are you switching your current job
Ans. 
Seeking new challenges and growth opportunities in a more dynamic environment.
• Looking for new challenges and opportunities for growth

• Interested in working in a more dynamic environment

• Seeking to expand my skills and knowledge in a different setting
Answered by AI
Add your answer
Q2. What is your expected CTC
Ans. 
My expected CTC is negotiable based on the job responsibilities and market standards.
• My expected CTC is based on my experience, skills, and the job requirements.

• I am open to discussing the salary range during the interview process.

• I am looking for a competitive salary package that aligns with industry standards.

• I am flexible and willing to consider other benefits in addition to the salary.
Answered by AI
Add your answer

Q1. Sql dmvs used in performance tuning
Ans. 
SQL DMVs are dynamic management views that provide information about the current state of a SQL Server instance for performance tuning.
• DMVs can be used to identify performance bottlenecks, monitor resource usage, and troubleshoot issues.

• Examples of commonly used DMVs include sys.dm_exec_query_stats, sys.dm_os_wait_stats, and sys.dm_io_virtual_file_stats.
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. Tell me about your roles and responsibilities
Add your answer
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
Add your answer
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
Add your answer