Ques:- When is a functional dependency F said to be minimal?
Asked In :-
Leo Technologies, valuemomentum,
Ques:- How to parametarise a field in a sequential file?I am using Datastage as ETL Tool,Sequential file as source.
Ques:- In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?
Asked In :-
Accucia,
Ques:- What is Data warehosuing Hierarchy?
Ques:- Explain about the mainframe connect tools from Sybase?
Asked In :-
aptean, intellect bizware services pvt .ltd,
Ques:- Where we use link partitioner in data stage job?explain with example?
Asked In :-
Ladbrokes Coral, DATAZOIC MACHINES,
Ques:- What is the difference between ETL tool and OLAP tool? What are various ETL in the market? What are various OLAP tools? what is the future for both for next five years?
Asked In :-
smartek21,
Ques:- Consider a sales invoice and the programmer has to save multiple items in one sales invoice. On entering the rate and qty, the amount and total amount should be automatically calculated. The invoice number will be the same for all items in that invoice. Item, Rate, Qty Amount will be in grid and total amount will be voucher wise. Please let me know the coding for that.
Asked In :-
Tmeic International Corporation,
Ques:- Explain about the advantages of Progress Actional?
Asked In :-
Ques:- What is junk dimension?what is the difference between junk dimension and degenerated dimension?
Ques:- Explain about the features of Sybase IQ?
Asked In :-
Ques:- Is it advisable to force an index when you want to select mostof the entries in the table?
Asked In :-
Ques:- What do you mean by slection sort and buble sort?please explain with example.
Asked In :-
Apttus Software, fincons group,
Ques:- Name some built-in functions that can be used in SQL queries?
Asked In :-
mercury drug corporation,
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.
