Filter interviews by
To upgrade db2 version in HADR, you need to follow a specific process to ensure minimal downtime and data loss.
Ensure all prerequisites are met before starting the upgrade process
Perform a full backup of the primary and standby databases
Stop the HADR on the standby server
Upgrade the primary server to the new version of db2
Upgrade the standby server to the new version of db2
Restart HADR on the standby server
Verify ...
SN diagram is a graphical representation of stress versus number of cycles to failure for a material.
SN diagram helps in understanding the fatigue behavior of a material under cyclic loading.
It shows the relationship between stress amplitude and the number of cycles to failure.
Materials with higher endurance limits have steeper slopes on the SN diagram.
SN diagrams are commonly used in engineering to design compone...
Brittle materials break without significant deformation, while ductile materials can undergo significant deformation before breaking.
Brittle materials break with little or no plastic deformation
Ductile materials can undergo significant plastic deformation before breaking
Examples of brittle materials: glass, ceramics
Examples of ductile materials: metals like copper, aluminum
Technical knowledge developers are essential for creating and maintaining complex software systems.
Technical knowledge developers possess the skills and expertise necessary to design, develop, and implement software solutions.
They are responsible for ensuring that software systems are efficient, reliable, and secure.
They stay up-to-date with the latest technologies and programming languages to ensure that their sk...
Identify records in one table that do not match records in another using SQL queries.
Use LEFT JOIN to find unmatched records: SELECT a.* FROM TableA a LEFT JOIN TableB b ON a.id = b.id WHERE b.id IS NULL.
Use NOT EXISTS to filter unmatched records: SELECT * FROM TableA a WHERE NOT EXISTS (SELECT 1 FROM TableB b WHERE a.id = b.id).
Use EXCEPT to find records in one table not in another: SELECT id FROM TableA EXCEPT S...
Delegates are reference types that hold a reference to a method. They are used to achieve loose coupling and extensibility.
Delegates allow methods to be passed as parameters to other methods.
They can be used to implement callbacks and event handlers.
Delegates can be multicast, meaning they can hold references to multiple methods.
There are two types of delegates: singlecast and multicast.
IEnumerable is in-memory collection while IQueryable is a queryable data source.
IEnumerable is used for querying data from in-memory collections like List, Array, etc.
IQueryable is used for querying data from a database or remote data source.
IQueryable supports deferred execution while IEnumerable does not.
IQueryable allows for filtering, sorting, and paging to be done on the server side.
IQueryable is more efficie...
Generations of Garbage collection are used to manage memory in Java applications.
Garbage collection is the process of automatically freeing up memory that is no longer in use by the application.
Generational garbage collection divides objects into different generations based on their age and usage patterns.
Young generation is where new objects are created and old objects that survive multiple garbage collections ar...
Prevent SQL Injection by using parameterized queries and input validation.
Use parameterized queries instead of concatenating user input with SQL statements.
Sanitize user input by validating and escaping special characters.
Limit database user privileges to only necessary actions.
Implement web application firewalls to detect and block SQL injection attempts.
Regularly update and patch software to fix known vulnerabil...
Component interaction is the process of communication and data exchange between different software components.
Components can interact through APIs, events, or shared memory.
APIs allow components to expose their functionality to other components.
Events enable components to notify each other of changes or trigger actions.
Shared memory allows components to access and modify the same data.
Component interaction is cruc...
I applied via LinkedIn and was interviewed in Jul 2024. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Oct 2023. There were 2 interview rounds.
I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.
It is the round of aptitude consist of 20 questions
Brittle materials break without significant deformation, while ductile materials can undergo significant deformation before breaking.
Brittle materials break with little or no plastic deformation
Ductile materials can undergo significant plastic deformation before breaking
Examples of brittle materials: glass, ceramics
Examples of ductile materials: metals like copper, aluminum
SN diagram is a graphical representation of stress versus number of cycles to failure for a material.
SN diagram helps in understanding the fatigue behavior of a material under cyclic loading.
It shows the relationship between stress amplitude and the number of cycles to failure.
Materials with higher endurance limits have steeper slopes on the SN diagram.
SN diagrams are commonly used in engineering to design components t...
I applied via Newspaper Ad and was interviewed in Dec 2023. There was 1 interview round.
I applied via Referral and was interviewed before Jul 2023. There were 2 interview rounds.
To upgrade db2 version in HADR, you need to follow a specific process to ensure minimal downtime and data loss.
Ensure all prerequisites are met before starting the upgrade process
Perform a full backup of the primary and standby databases
Stop the HADR on the standby server
Upgrade the primary server to the new version of db2
Upgrade the standby server to the new version of db2
Restart HADR on the standby server
Verify the s...
Daily activities as a DBA involve managing databases, ensuring data security, optimizing performance, and troubleshooting issues.
Monitoring database performance and ensuring availability
Implementing and maintaining backup and recovery plans
Optimizing database queries and indexes
Troubleshooting and resolving database issues
Implementing security measures to protect data
Collaborating with developers and system administrat...
I applied via Naukri.com and was interviewed in Mar 2022. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Nov 2021. There were 3 interview rounds.
Identify records in one table that do not match records in another using SQL queries.
Use LEFT JOIN to find unmatched records: SELECT a.* FROM TableA a LEFT JOIN TableB b ON a.id = b.id WHERE b.id IS NULL.
Use NOT EXISTS to filter unmatched records: SELECT * FROM TableA a WHERE NOT EXISTS (SELECT 1 FROM TableB b WHERE a.id = b.id).
Use EXCEPT to find records in one table not in another: SELECT id FROM TableA EXCEPT SELECT...
Technical knowledge developers are essential for creating and maintaining complex software systems.
Technical knowledge developers possess the skills and expertise necessary to design, develop, and implement software solutions.
They are responsible for ensuring that software systems are efficient, reliable, and secure.
They stay up-to-date with the latest technologies and programming languages to ensure that their skills ...
Top trending discussions
based on 12 interview experiences
Difficulty level
Duration
based on 119 reviews
Rating in categories
Senior Software Engineer
39
salaries
| ₹8.7 L/yr - ₹30 L/yr |
Software Engineer
33
salaries
| ₹4.1 L/yr - ₹14.9 L/yr |
Senior Associate
21
salaries
| ₹3.4 L/yr - ₹8.1 L/yr |
Principal Software Engineer
14
salaries
| ₹11.5 L/yr - ₹30.5 L/yr |
Associate
13
salaries
| ₹3.4 L/yr - ₹5.3 L/yr |
Bajaj Motors
Knorr-Bremse
Delta Electronics
Gestamp