Database Administrator (dba) Interview Questions and Answers in 2025 (100+ Q&A)

Ques:- Physical standby database

Asked In :- HUBCO, lothian buses,

Right Answer:
A physical standby database is a replica of the primary database that maintains an exact copy of the primary's data files, using redo data received from the primary database to stay synchronized. It is used for disaster recovery and can be opened in read-only mode for reporting purposes.

Database Administrator (dba) Oracle

Ques:- Backup and Recovery techniques including cold and hot backup

Asked In :- Damco Solutions, Data Patterns, Smarter BIZ Technologies, KJ System, arbisoft, wetransfer,

Right Answer:
Cold backup involves shutting down the database and copying the data files, control files, and redo logs, ensuring data consistency. Hot backup, on the other hand, allows the database to remain online while backing up data files, typically using Oracle's "ALTER DATABASE BEGIN BACKUP" command to ensure data integrity during the process. Both techniques are essential for recovery, with cold backups being simpler and hot backups providing higher availability.

Database Administrator (dba) Oracle

Ques:- Oracle Architecture – Shared Pool and SGA

Asked In :- itron, scan-it,

Right Answer:
The System Global Area (SGA) is a shared memory area that contains data and control information for an Oracle database instance. The Shared Pool is a component of the SGA that stores shared SQL areas, PL/SQL code, and data dictionary information to optimize performance by reducing the need for disk I/O.

Business Intelligence Database Administrator (dba)

Ques:- Name some of the standard Business Intelligence tools in the

Asked In :- Gleacher Shacklock, Trigyn Technologies Ltd, kotak mahindra bank, florida blue, data domain, frisco independent school district,

Right Answer:
Some standard Business Intelligence tools include Tableau, Power BI, QlikView, Looker, and SAP BusinessObjects.

Business Intelligence Database Administrator (dba)

Ques:- Use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007i need to restrect this query to current date and current year[gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosale

Asked In :- SAP Concur, Human Cloud Business Solutions, ClearBank, carl zeiss vision, william blair, metricstream, oil spill response ltd,

Right Answer:
```sql
SELECT *
FROM [gosales_goretailers].[Orders]
WHERE [Order month] BETWEEN 1 AND EXTRACT(MONTH FROM CURRENT_DATE)
AND EXTRACT(YEAR FROM CURRENT_DATE) = 2023; -- Replace 2023 with the current year if needed
```

Business Intelligence Database Administrator (dba)

Ques:- What are the limitations of cognos reportnet?What are the enhancements in reportnet ?

Asked In :- Solix Technologies, Inc, Valuefy Solutions, Nihilent Analytics, SFH Nigeria, qBotica, global payments, metricstream, vardhman textiles, kyriba, ccil,

Right Answer:
Limitations of Cognos ReportNet include:

1. Limited support for complex data transformations.
2. Lack of real-time data access.
3. Performance issues with large datasets.
4. Limited visualization options compared to newer tools.
5. Difficulty in managing security and user access.

Enhancements in ReportNet include:

1. Improved user interface for report creation.
2. Enhanced scheduling and distribution features.
3. Better integration with other IBM products.
4. Support for more data sources.
5. Advanced analytics capabilities.

Database Administrator (dba) DB Architecture

Ques:- How much would be the size of the database in DataStage ?What is the difference between Inprocess and Interprocess ?

Asked In :-

Right Answer:
The size of the database in DataStage depends on the amount of data being processed and stored, as well as the design of the database schema.

The difference between Inprocess and Interprocess is that Inprocess refers to operations that occur within the same process or memory space, while Interprocess involves communication and data exchange between different processes or memory spaces.

Database Administrator (dba) Shell Scripting

Ques:- How do you write a while loop in shell?

Asked In :-

Right Answer:
You can write a while loop in shell like this:

```bash
while [ condition ]; do
# commands to execute
done
```

For example:

```bash
count=1
while [ $count -le 5 ]; do
echo "Count is $count"
count=$((count + 1))
done
```

Database Administrator (dba) Shell Scripting

Ques:- How do you search for a string in a directory with the subdirectories recursed?

Asked In :- QUALYS SECURITY TECHSERVICES, IndiaNIC Infotech, william hill, offshore,

Right Answer:
You can use the `grep` command with the `-r` option. For example:

```bash
grep -r "search_string" /path/to/directory
```

Aptitude Database Administrator (dba)

Ques:- Raj has a jewel chest containing Rings, Pins and Ear-rings. The chest contains 26 pieces. Raj has 2 and 1/2 times as many rings as pins, and the number of pairs of earrings is 4 less than the number of rings. How many earrings does Raj have?…

Asked In :-

Right Answer:
Raj has 6 earrings.

Comments

King11 Mar 18, 2022

6 pairs of earrings. So 12 earrings.

The total has to be 26, so let’s say there’s 6 pairs of earrings and the number of pairs has to be 4 less than the number of rings. So that would make 10 rings. The 10 rings has to be 2 1/2 greater than the number of pins. So you would divide 10/2.5 = 4 Pins. That would equate to a total of 12 earrings, 10 rings, and 4 pins. A total of 26 pieces.

Database Administrator (dba) Shell Scripting

Ques:- Different types of shells

Asked In :- gmc,

Right Answer:
The different types of shells include:

1. Bourne Shell (sh)
2. Bourne Again Shell (bash)
3. C Shell (csh)
4. Korn Shell (ksh)
5. Z Shell (zsh)
6. Fish Shell (fish)

Database Administrator (dba) PeopleSoft

Ques:- What commands are valid in BS mode?

Asked In :- fareportal, enphase energy, b4b,

Right Answer:
In BS mode (Batch Scheduler mode) in PeopleSoft, valid commands include:

1. **RUN** - to execute a process.
2. **SCHEDULE** - to schedule a process for future execution.
3. **CANCEL** - to cancel a scheduled process.
4. **STATUS** - to check the status of a process.
5. **LIST** - to list scheduled processes.

These commands help manage batch processes effectively.

Database Administrator (dba) PeopleSoft

Ques:- Update and Fixes: R-* files refers to

Asked In :- western digital, cheq systems, inc., goodix technology inc., sandfield,

Right Answer:
R-* files in PeopleSoft refer to "Report" files that contain updates and fixes for PeopleSoft applications.

Database Administrator (dba) PeopleSoft

Ques:- Name some app engines u worked on?

Asked In :- MBR Informatics, jumpcloud,

Right Answer:
Some App Engines I have worked on include:

1. Application Engine for Payroll Processing
2. Application Engine for Benefits Enrollment
3. Application Engine for Time and Labor Reporting
4. Application Engine for Student Records Processing
5. Application Engine for Financial Aid Processing

Database Administrator (dba) Shell Scripting

Ques:- What does $# stand for?

Asked In :- ActiveLobby, fcp, statistics center abu dhabi,

Right Answer:
In shell scripting, `$#` represents the number of positional parameters (arguments) passed to a script or function.

Aptitude Database Administrator (dba)

Ques:- You are given weights of order 1kg 3kg 9kg 27kg 81kg and so on…(powers of 3)A weight of N kg is placed on any one of the empty pans of the balance.You are supposed to add weights to both pans of the balance and make them equal.You can use one weight only once..i.e., you can't use 2 number of 3kg weights.

Asked In :- Kalki Communication Technologies, Data Patterns, Enthuons, northwestern mutual, ivr technology group,

Right Answer:
You can represent any weight N using the weights of powers of 3 (1kg, 3kg, 9kg, 27kg, 81kg, etc.) by expressing N in balanced ternary form, where each digit can be -1, 0, or 1. This means you can place weights on either side of the balance or not use them at all.

Database Administrator (dba) Telecommunication

Ques:- What is the nominal voltage required in subscriber loop connected to local exchange?a) +48 voltsb) -48 voltsc) 230 voltsd) 110 volts

Asked In :- Lekha Wireless Solutions, Thinkcore Technologies, mentormate, onedirect,

Right Answer:
b) -48 volts

Database Administrator (dba) Telecommunication

Ques:- What is a Broadband modem?

Asked In :- prolifics,

Right Answer:
A broadband modem is a device that connects your home or office network to the internet via a high-speed broadband connection, such as DSL, cable, or fiber. It modulates and demodulates signals for data transmission over these networks.

Database Administrator (dba) Telecommunication

Ques:- How many T1 facilities the company needs between its office and the PSTN if it has 47 digital telephones, each operating at 64kbps: a. 3 low-speed video machines, each operating at 384kbps b. 1 interactive video system, requiring 1.536 mbps.

Asked In :- BillDesk, Solix Technologies, Inc, Cynet Systems,

Right Answer:
The company needs 4 T1 facilities.

Database Administrator (dba) Telecommunication

Ques:- Max number of satellite hops allowed in voice communication is:a) only oneb) more han onec) two hopsd) four hops

Asked In :- TVISHA TECHNOLOGIES PVT, HIL, Mitel Networks, Azercell Telecom,

Right Answer:
a) only one

The Database Administrator (DBA) section on takluu.com is designed for professionals aiming to manage, maintain, and optimize enterprise database systems. A DBA ensures data integrity, availability, and security, playing a vital role in the smooth operation of business-critical applications.

This category covers core DBA responsibilities including database installation and configuration, backup and recovery strategies, performance tuning, security management, replication, and troubleshooting. You’ll find comprehensive content on popular database platforms such as Oracle, SQL Server, MySQL, and PostgreSQL, along with cloud database management.

Our interview preparation material includes real-world scenario-based questions that test your problem-solving skills, understanding of database internals, and ability to handle emergencies like data loss or performance bottlenecks. We also focus on automation of DBA tasks using scripts and tools, which is increasingly important in modern DevOps environments.

Whether you are preparing for roles like Junior DBA, Senior DBA, or Database Manager, this section equips you with the knowledge to confidently answer both technical and behavioral interview questions.

At Takluu, we emphasize practical learning with mock interviews, step-by-step guides, and tips on best practices. This ensures that you are not only interview-ready but also prepared to manage real-world database challenges effectively.

Start your journey with us to become a skilled Database Administrator who safeguards and optimizes valuable organizational data.

Questions in: Database Administrator (dba)

What makes Takluu valuable for interview preparation?

Get Our Mobile App

Programming

Reasoning

Network & Telecom

Management

What makes Takluu valuable for interview preparation?