Celebal Technologies SQL Database Administrator Interview Questions and Answers

Resolve gap on a Physical Standby in Dataguard by identifying the missing archived redo log files and manually copying them over.

• Check the alert log for errors related to missing archived redo log files

• Identify the sequence number of the missing redo log files

• Manually copy the missing archived redo log files from the primary database to the standby database location

• Register the missing redo log files using the ALTER DA

Investigate the issue, analyze performance metrics, identify bottlenecks, optimize queries, and implement performance tuning.

• Investigate the issue by analyzing logs, monitoring tools, and gathering information from the client.

• Analyze performance metrics such as CPU usage, memory usage, disk I/O, and query execution times.

• Identify bottlenecks in the database system such as slow queries, inefficient indexing, or hardware...read more

Yes, I have knowledge on cloud computing.

• I have experience working with cloud databases like Oracle Cloud Database

• I am familiar with cloud storage solutions like Amazon S3 and Google Cloud Storage

• I have implemented cloud backup and disaster recovery strategies in previous roles

Yes, I have knowledge on other RDBMS such as MySQL, SQL Server, and PostgreSQL.

• I have experience working with MySQL, including database design and optimization.

• I am familiar with SQL Server and have performed tasks such as backup and recovery.

• I have worked with PostgreSQL and have knowledge of advanced features like partitioning and replication.