Clover Infotech Senior Oracle Database Administrator Interview Questions and Answers

Q1. DBA related questions
Add your answer
Q2. Golden Gate architecture, RAC, Data guard
Add your answer

Q1. Partition tables
Add your answer
Q2. RAC-startup, export/import
Add your answer

Q1. Describe your daily activity
Add your answer
Q2. Errors you have faced
Add your answer

Basic Apptitude. SQL & logic in

Very easy topic. You just need to have fluent English.

They took two GD as many people were selected

Q1. They asked basic and advanced SQL queries
Add your answer

Q1. The Architecture of SQL Server
Ans. 
The architecture of SQL Server involves components like storage engine, query processor, and buffer manager.
• SQL Server architecture consists of multiple components such as storage engine, query processor, and buffer manager.

• The storage engine manages data storage, retrieval, and modification.

• The query processor processes SQL queries and generates execution plans.

• The buffer manager is responsible for managing data cache...read more
Answered by AI
Add your answer
Q2. How to troubleshoot high CPU and Memory
Ans. 
To troubleshoot high CPU and Memory, monitor performance metrics, identify resource-intensive queries, optimize queries and indexes, check for memory leaks.
• Monitor performance metrics using tools like SQL Server Profiler, Performance Monitor, or DMVs.

• Identify resource-intensive queries using tools like SQL Server Management Studio or query execution plans.

• Optimize queries and indexes by rewriting queries, adding missin...read more
Answered by AI
Add your answer
Q3. Recent issues and resolution
Ans. 
Resolved recent issues related to database performance by optimizing queries and increasing server resources.
• Identified slow performing queries and optimized them by adding indexes or rewriting them

• Increased server resources such as CPU, memory, or storage to improve performance

• Implemented query caching or stored procedures to reduce load on the database server
Answered by AI
Add your answer
Q4. What is DAG, DNN and VNN
Ans. 
DAG stands for Directed Acyclic Graph, DNN stands for Deep Neural Network, and VNN stands for Virtual Neural Network.
• DAG is a graph with directed edges and no cycles, commonly used in data processing.

• DNN is a type of artificial neural network with multiple hidden layers, used in deep learning.

• VNN is a virtual neural network, a concept that may refer to a neural network implemented in a virtual environment.
Answered by AI
Add your answer

Q1. Salary discussion and shift acceptance
Add your answer

Q1. Basic questions like CTE, Recursive cte, stored procedure, index fragmentation
Add your answer

Q1. General questions
Add your answer

Q1. Basic technical questions Database Architecture Tablespace management User management Db links/networking Rman backup strategy
Add your answer

Q1. Performance tuning Dataguard Rac basic ASM
Add your answer