Clover Infotech SQL 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

Q1. What is database?
Ans. 
A database is a structured collection of data that is organized in a way that allows for easy access, management, and retrieval.
• A database is used to store and organize data in a structured format.

• It allows for efficient retrieval and manipulation of data.

• Examples of databases include MySQL, Oracle, SQL Server, and MongoDB.
Answered by AI
Add your answer
Q2. What is MySQL? why it is popular?
Ans. 
MySQL is an open-source relational database management system that is popular for its ease of use, flexibility, and scalability.
• MySQL is an open-source RDBMS, allowing users to freely use, modify, and distribute the software.

• It is known for its ease of use, making it accessible for beginners and experts alike.

• MySQL is highly flexible, supporting various data types and storage engines.

• It is popular for its scalability, ...read more
Answered by AI
Add your answer
Q3. How to retrieve set of data in a database?
Ans. 
To retrieve a set of data in a database, you can use SQL queries to specify the data you want to retrieve.
• Use SELECT statement to specify the columns you want to retrieve

• Use FROM clause to specify the table where the data is stored

• Use WHERE clause to specify any conditions for filtering the data

• Use ORDER BY clause to specify the order in which the data should be returned

• Use LIMIT clause to specify the maximum number of
Answered by AI
Add your answer
Q4. How to know the disk utilization in linux?
Ans. 
To know disk utilization in Linux, use commands like df, du, and iostat.
• Use 'df' command to display disk space usage on Linux filesystems.

• Use 'du' command to estimate file space usage.

• Use 'iostat' command to monitor system input/output device loading.

• Check disk utilization with tools like 'iotop' and 'atop'.
Answered by AI
Add your answer

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

Q1. General questions
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