Find Interview Questions for Top Companies
Ques:- What are the different modes of mounting a Database with the Parallel Server ?
Right Answer:
The different modes of mounting a database with the Parallel Server are:

1. **Exclusive Mode**: Only one instance can access the database at a time.
2. **Shared Mode**: Multiple instances can access the database simultaneously, allowing for parallel processing.
3. **Read-Only Mode**: Instances can access the database for read operations only, preventing any write operations.
Ques:- What are the steps involved in Database Startup ?
Asked In :- Xobin,
Right Answer:
The steps involved in Database Startup are:

1. **Instance Startup**: Initialize the database instance, allocating memory and starting background processes.
2. **Mounting the Database**: Open the database control files and prepare to access data files.
3. **Opening the Database**: Make the database available for user access by opening the data files.
Ques:- What is the steps for recovery of missing data file? and the steps for physical stand by database creation?
Right Answer:
**Steps for Recovery of Missing Data File:**
1. Identify the missing data file using the alert log or data dictionary views.
2. If the database is in ARCHIVELOG mode, restore the missing data file from a backup.
3. Use the `ALTER DATABASE CREATE DATAFILE` command to create a new data file with the same name and location.
4. If necessary, recover the data file using `RECOVER DATAFILE` command.
5. Open the database with `ALTER DATABASE OPEN`.

**Steps for Physical Standby Database Creation:**
1. Prepare the primary database for standby by enabling ARCHIVELOG mode and setting up a flash recovery area.
2. Take a backup of the primary database using RMAN or a cold backup.
3. Transfer the backup to the standby server.
4. Create a parameter file for the standby database.
5. Start the standby database in NOMOUNT mode and create the control file using the `CREATE CONTROLFILE` command.
6. Mount the standby
Ques:- What is a mirrored online redo log?
Right Answer:

A mirrored online redo log is a duplicate copy of the redo log files maintained on a separate disk. It ensures data is not lost if one log file becomes corrupt or the disk fails — enhancing database reliability.

Comments
DK BOSS Jul 21, 2021

If an online redo log file of a group is lost, the database remains in operation. ... Oracle then uses the remaining member (or members) of this group to log the database changes.

Ques:- What is On-line Redo Log?
Asked In :- globallogic,
Right Answer:
On-line Redo Log is a set of files in a database that records all changes made to the database, allowing for recovery of data in case of a failure.
Ques:- What is the steps for recovery with missing online redo logs?
Asked In :-
Right Answer:
1. Identify the missing online redo log files.
2. Check the database status using the command `ARCHIVE LOG LIST`.
3. If the database is in ARCHIVELOG mode, ensure that you have a recent backup.
4. If possible, restore the missing redo logs from a backup.
5. If restoration is not possible, use the command `ALTER DATABASE CLEAR LOGFILE` to clear the missing logs (this may lead to data loss).
6. Open the database with `ALTER DATABASE OPEN`.
7. Monitor the database for any issues and ensure data integrity.
Ques:- What is a partial backup?
Asked In :- Gentrack, awe,
Right Answer:

A partial backup saves only selected files, folders, or database parts instead of the entire system — useful for saving time and storage when full backup isn’t needed.

Ques:- What are the steps involved in Database Shutdown ?
Right Answer:
1. Notify users about the impending shutdown.
2. Stop new connections to the database.
3. Wait for active transactions to complete.
4. Disconnect all users from the database.
5. Perform a checkpoint to ensure data integrity.
6. Shut down the database instance gracefully.
Ques:- What is the difference between hot backup n rman backup?
Right Answer:
A hot backup is taken while the database is running and users can access it, allowing for continuous operations. RMAN (Recovery Manager) backup is a specific tool in Oracle that can perform both hot and cold backups, providing features like incremental backups and automated recovery processes.
Ques:- I applied prompt on country when i run report it shows listof all countries but want it to show only four countries name
Right Answer:
You can modify the prompt to filter the countries by using a query or a parameter that limits the selection to only the four specific countries you want to display. For example, you can use a SQL query like `SELECT country FROM countries WHERE country IN ('Country1', 'Country2', 'Country3', 'Country4')` to restrict the list.
Ques:- What is the diff between abinitiorc and .abinitiorc files ?
Asked In :- IRIS Software Group,
Right Answer:
The `abinitiorc` file is a system-wide configuration file for Ab Initio, while the `.abinitiorc` file is a user-specific configuration file that overrides settings in the `abinitiorc` for individual users.
Ques:- Diff.between Output index and Output indexes?
Asked In :-
Right Answer:
Output index refers to a single index that is created for a specific output operation, while output indexes (plural) refer to multiple indexes that may be created for various output operations or for different columns in a database.
Ques:- What is OLAP?
Asked In :- Bounteous,
Right Answer:
OLAP stands for Online Analytical Processing. It is a category of software technology that enables analysts, managers, and executives to gain insight into data through fast, consistent, interactive access in various ways, typically for complex queries and data analysis.
Ques:- How can you run a graph continuously without usingcontinuous components ?
Asked In :- studiosity,
Right Answer:
You can run a graph continuously without using continuous components by scheduling the graph to run at regular intervals using a job scheduler or by implementing a loop in a script that triggers the graph execution repeatedly.
Ques:- What are the sections that we have in Crystal reports?
Asked In :- lenovo,
Right Answer:
The sections in Crystal Reports are:

1. Report Header
2. Page Header
3. Group Header
4. Details
5. Group Footer
6. Page Footer
7. Report Footer
Ques:- Is there any feature like summing total in crystal report?
Asked In :- thoughtspot,
Right Answer:
Yes, Crystal Reports has a feature called "Summary Fields" that allows you to sum totals and perform other aggregate calculations on your data.
Ques:- Does Crystal Report support all the functions that we havein Oracle?
Asked In :-
Right Answer:
No, Crystal Reports does not support all the functions available in Oracle.


The Database Administration (DBA) category on takluu.com is designed for professionals who manage the backbone of an organization’s data infrastructure. DBAs are responsible for the installation, configuration, monitoring, and maintenance of database systems like Oracle, MySQL, SQL Server, PostgreSQL, and more. Their role ensures that databases operate smoothly, securely, and efficiently.

This section covers a broad range of essential DBA topics including backup and recovery strategies, database security, performance tuning, replication, clustering, and disaster recovery planning. You will also learn about SQL query optimization, indexing techniques, user management, and capacity planning. These skills help prevent data loss, minimize downtime, and maintain system integrity under high workloads.

Interviewers often test candidates on real-world scenarios such as troubleshooting slow queries, handling deadlocks, setting up replication, and configuring failover systems. In addition to technical skills, DBAs need to understand compliance requirements and ensure that data privacy standards are met.

Our curated interview questions focus on practical knowledge, enabling you to confidently answer questions related to database architecture, scripting, automation, and monitoring tools. Whether you’re preparing for roles like Junior DBA, Senior DBA, Database Engineer, or Data Architect, this category equips you with the necessary insights and hands-on expertise.

By mastering the concepts and best practices shared in this section, you will be able to ensure reliable database performance, safeguard critical business data, and contribute effectively to your organization’s IT success.

Start your journey with Takluu and become a skilled Database Administrator ready to tackle complex data challenges.

AmbitionBox Logo

What makes Takluu valuable for interview preparation?

1 Lakh+
Companies
6 Lakh+
Interview Questions
50K+
Job Profiles
20K+
Users