KGISL DBA Administrator Interview Questions and Answers

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

Q1. How to recover control file if it is deleted in 8pm and how u recover that file after 8pm What is rac how u reate in rac ? About primary and standby And what command to used ? What is smon Library cacher.
Ans. 
To recover a deleted control file in Oracle Database, you can use a backup control file or create a new control file.
• If a backup control file is available, you can restore it using the RMAN utility.

• If a backup control file is not available, you can create a new control file using the CREATE CONTROLFILE statement.

• To create a new control file, you need to provide the necessary information about the database, such as data...read more
Answered by AI
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. Explain locks and latches
Ans. 
Locks and latches are mechanisms used in database management systems to control access to data and ensure data integrity.
• Locks are used to control access to data by preventing multiple users from modifying the same data simultaneously.

• Latches are lightweight synchronization mechanisms used to protect data structures in memory.

• Locks can be of different types such as shared locks, exclusive locks, and update locks.

• Latche...read more
Answered by AI
Add your answer
Q2. Isolation level in DB
Ans. 
Isolation level determines how transactions interact with each other in a database.
• Isolation levels include Read Uncommitted, Read Committed, Repeatable Read, Serializable.

• Higher isolation levels provide more data consistency but may lead to more locking and potential performance issues.

• Example: Using Read Uncommitted isolation level allows reading uncommitted data, while Serializable ensures data integrity but may lea...read more
Answered by AI
Add your answer

1st Aptitude test
2nd one to one Round
3rd HR

Q1. Senior person taking 2nd round
Add your answer
Q2. Depand on profile likeOracle sql
Add your answer

Q1. SQL server architecture
Add your answer
Q2. Backup Types and PITR
Add your answer
Q3. High availability and Disaster Recovery
Add your answer

Q1. Asked for everything that I mentioned in my resume
Add your answer
Q2. Azure services and features
Add your answer

Q1. Management Process
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