Softenger Oracle Database Administrator Interview Questions and Answers

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

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. 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