Top 250 Database Management Interview Questions and Answers

Use triggers to update related table on row modification.

• Create a trigger on the main table to update the related table

• Use the UPDATE statement in the trigger to modify the related table

• Ensure that the trigger is efficient and does not cause performa...read more

SYSTEM user is important in SAP HANA for performing administrative tasks and managing the system.

• SYSTEM user has unrestricted access to all system objects and can perform any operation on them.

• It is used for performing administrative tasks such as cr...read more

The task is to merge accounts belonging to the same person based on common emails and return the merged accounts.

• Iterate through each account and create a mapping of emails to account holders

• Iterate through the mapping and merge accounts with common ...read more

To populate manager using server-side code, you can query the user table and retrieve the manager's details based on the user's ID.

• Use GlideRecord to query the user table

• Retrieve the manager's details using the user's ID

• Set the manager field with the...read more

In SSIS, a provider is a software component that allows SSIS to connect to different types of data sources.

• Providers are used to establish connections to databases, files, and other data sources in SSIS.

• Examples of providers include OLE DB provider, ...read more

Create a website with a MySQL database.

• Choose a web development framework (e.g., Django, Ruby on Rails)

• Design the database schema and create the necessary tables

• Write server-side code to handle HTTP requests and interact with the database

• Implement us...read more

Ensured data integrity in migration through thorough validation processes and data mapping

• Implemented data validation checks before and after migration

• Utilized data mapping techniques to ensure accurate transfer of data

• Collaborated with stakeholders ...read more

SAP HANA is an in-memory database platform for real-time analytics and applications, while ECC (Enterprise Central Component) is a traditional ERP system.

• SAP HANA is an in-memory database platform, providing real-time data processing and analytics.

• EC...read more

I would analyze the performance issue and take appropriate actions to resolve it.

• Identify the specific performance issue and gather relevant data

• Analyze the database configuration and settings

• Review the migration process and identify any potential is...read more

Design data modelling and flow for IRCTC.

• Identify entities like trains, stations, passengers, bookings, payments, etc.

• Create a database schema with tables for each entity and their attributes.

• Establish relationships between tables using foreign keys....read more

The SUM can be reset until the start of the execution phase.

• SUM (Software Update Manager) can be reset until the execution phase starts.

• Once the execution phase starts, the SUM cannot be reset.

• Resetting the SUM deletes all the logs and data collected...read more

To create an immutable class in Hibernate, use final keyword for class, make fields private and provide only getters.

• Use the final keyword for the class to prevent subclassing

• Make fields private to restrict direct access

• Provide only getters for the f...read more

I have extensive experience with API integration in Thoughtspot.

• Developed custom API integrations to pull data from external sources into Thoughtspot

• Utilized Thoughtspot's REST API to automate data loading and report generation

• Worked closely with IT ...read more

Code first approach involves creating the database schema based on the code, while database first approach involves creating the code based on an existing database schema.

• Code first approach focuses on defining the entities and their relationships in...read more

Physical files store data on storage devices, while logical files represent data structures used by applications.

• Physical files are actual files stored on disk (e.g., .txt, .csv).

• Logical files are abstract representations used by programs (e.g., data...read more

To handle DB and extended sales force team, communication, training, and motivation are key.

• Regular communication with the team to understand their challenges and provide support

• Provide training to improve their skills and knowledge

• Motivate the team ...read more

Managing client, orders, and events involves effective communication, organization, and coordination.

• Establish clear communication channels with clients to understand their needs and expectations.

• Develop a streamlined process for receiving and proces...read more

Column overlap can be calculated using formula or table provided by codes.

• Column overlap is the length of overlap between two reinforcing bars in a column.

• Formula for calculating overlap length is provided by codes such as ACI or BS.

• Overlap length de...read more

Oracle Fusion is a cloud-based enterprise resource planning (ERP) software suite.

• It integrates various business functions such as financial management, human resources, supply chain management, and customer relationship management.

• It offers a modular...read more

EF Core supports transactions using the DbContext class.

• Create a new instance of DbContextTransaction using BeginTransaction method of DbContext.

• Perform database operations within the transaction using SaveChanges method of DbContext.

• Commit the trans...read more

Different types of execution process in Ado.net include connected and disconnected modes.

• Connected mode involves opening a connection to the database, executing a command, and closing the connection.

• Disconnected mode involves using DataAdapters to fi...read more

SAP ECC is the traditional ERP system while SAP HANA is an in-memory database platform.

• SAP ECC is a traditional ERP system that relies on disk-based databases for data storage.

• SAP HANA is an in-memory database platform that stores data in RAM for fas...read more

Audit trial is a record of all activities performed on a system. It helps in tracking changes and identifying errors.

• Audit trial is important for maintaining data integrity and security.

• It helps in identifying who made changes to the system and when....read more

Recovering deleted datafiles without backup

• Check if the datafiles are still in the operating system's recycle bin or trash folder

• Use data recovery software to scan the hard drive for deleted files

• If the above methods fail, try to recreate the datafil...read more

Homogenous system copy can be done using SAPinst tool and Heterogenous system copy can be done using SWPM tool.

• Homogenous system copy involves copying the SAP system from one host to another with the same operating system and database.

• SAPinst tool is...read more

To create a custom job step in Salesforce Commerce Cloud, you can define a custom job step class and configure it in the job XML file.

• Create a custom job step class by extending the AbstractJobStep class.

• Implement the execute method in the custom job...read more

Use SAP Data Services or LSMW to upload large volume of data in SAP

• Use SAP Data Services to extract, transform, and load data into SAP systems

• Utilize LSMW (Legacy System Migration Workbench) for mass data uploads

• Split large data files into smaller ch...read more