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

Database Administrator (dba) PeopleSoft

Ques:- SMTP sendMail failed error during testing of HRMS upgrade to 8.9 (8.46.09 tools). On all of our triggerbusinessevents trying to send an email, we receive the above error. Any help would be appreciated.

Asked In :- ARMIA SYSTEMS, australian energy market operator (aemo), akshaya, goodix technology inc.,

Database Administrator (dba) Unix

Ques:- How can a parent and child process communicate?

Asked In :- itron,

Database Administrator (dba) PeopleSoft

Ques:- What are all stored in System Catalog

Asked In :-

Database Administrator (dba) PeopleSoft

Ques:- What are the Outputs of SQR?

Asked In :- eos it solutions,

Database Administrator (dba) Unix

Ques:- What is difference between lilo and stub?

Asked In :- MAK Controls & Systems,

Database Administrator (dba) PeopleSoft

Ques:- What are rename, reporting and layout commands, break point etc in sqr?

Asked In :- Physical Research Laboratory (PRL),

Aptitude Database Administrator (dba)

Ques:- Number of zeros in the product of the first 100 numbers?

Asked In :- Astoria Solutions, tracelink, alian software,

Right Answer:
24

Comments

Admin Sep 28, 2022

1×2×...100=100!
Number of zeros in product of n numbers =[5n]+[52n]+[53n]+...
Number of zeros in product of 100 numbers =[5100]+[52100]+[53100]
where [.] is greatest integer function
=[20]+[4]+[0.8]=20+4=24

Database Administrator (dba) PeopleSoft

Ques:- If u change the long name of translate field what object to be altered

Asked In :- bullhorn, brennan it, labcorp diagnostic laboratories, crest infotech,

Database Administrator (dba) PeopleSoft

Ques:- Simple Select Statement and Find the Results

Asked In :- MAPIT,

Database Administrator (dba) PeopleSoft

Ques:- Where are workflow work items found ?

Asked In :- Astoria Technologies, wikipedia, oracle retail, pangasinan state university,

Database Administrator (dba) Solaris

Ques:- Partition sizes can be set manually or from what configuration?

Asked In :- CloudKaptan, mso, pixel softek, yes energy management,

Right Answer:
Partition sizes can be set manually or from a configuration file.

Database Administrator (dba) Linux

Ques:- What is meant by sticky bit?Choose one:a. When set on a directory, then only the owner of a file can delete it.b. When set on an executable, then any user can run the executable.c. When set on a file, only the owner can see the file in a directory listing

Asked In :- Kloudrac, stratus technologies, techsol corporation, Ignitarium Technology Solutions,

Database Administrator (dba) PeopleSoft

Ques:- What is app messaging, where did you use?

Asked In :- JustDial, OCR Services, arup laboratories, cogent infotech,

Database Administrator (dba) Linux

Ques:- Each command has two types of output. There are standard output and standard __________.

Asked In :- Slk Software Pvt Ltd, Molson Coors Beverage Company, smud, iks, brainium information technologies pvt. ltd., zemoso technologies,

Database Administrator (dba) Shell Scripting

Ques:- How do you remove a file?

Asked In :-

Right Answer:
You can remove a file using the `rm` command in the shell. For example, to remove a file named `file.txt`, you would use:

```bash
rm file.txt
```

Database Administrator (dba) Shell Scripting

Ques:- How do you do number comparison in shell scripts?

Asked In :- Orion Innovation, auth0,

Right Answer:
In shell scripts, you can do number comparison using the following syntax:

For integers:
- Use `-eq` for equal
- Use `-ne` for not equal
- Use `-lt` for less than
- Use `-le` for less than or equal to
- Use `-gt` for greater than
- Use `-ge` for greater than or equal to

Example:
```bash
if [ "$num1" -lt "$num2" ]; then
echo "$num1 is less than $num2"
fi
```

For floating-point numbers, you can use `bc`:
```bash
if (( $(echo "$num1 < $num2" | bc -l) )); then
echo "$num1 is less than $num2"
fi
```

Database Administrator (dba) Shell Scripting

Ques:- How do you read arguments in a shell program – $1, $2 …

Asked In :- VMC TECHNOLOGIES, KPIT Technologies,

Right Answer:
In a shell program, you can read arguments using `$1`, `$2`, etc., where `$1` refers to the first argument, `$2` to the second argument, and so on. For example, to access the first argument, you would use `echo $1`.

Database Administrator (dba) PeopleSoft

Ques:- What is the difference between SaveEdit and FieldEdit?

Asked In :- Veritas Technologies, A3 Logics, syncfusion,

Database Administrator (dba) Shell Scripting

Ques:- What is the difference between writing code in shell and editor

Asked In :- Samsung Research America, Inspirisys Solutions,

Right Answer:
Writing code in a shell involves executing commands directly in a command-line interface, while writing code in an editor involves using a text editor to create and save scripts or programs that can be executed later.

Database Administrator (dba) Personal Questions round

Ques:- How do you keep your self professionally updated?

Asked In :- metricstream,

Right Answer:
I keep myself professionally updated by reading industry blogs, attending webinars and conferences, participating in online forums, taking relevant courses, and following thought leaders on social media.

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?