Iris Software Senior Technology Engineer Interview Questions, Process, and Tips

ACID properties are a set of properties that ensure database transactions are processed reliably.

• ACID stands for Atomicity, Consistency, Isolation, and Durability.

• Atomicity ensures that a transaction is treated as a single, indivisible unit of work.

• Consistency ensures that a transaction brings the database from one valid state to another.

• Isolation ensures that concurrent transactions do not interfere with each other.

• Du...read more

Index is a database structure that improves the speed of data retrieval. Types include clustered, non-clustered, and full-text.

• Index is a data structure that improves query performance by allowing faster data retrieval.

• Clustered index determines the physical order of data in a table.

• Non-clustered index is a separate structure that stores a copy of the indexed columns and a pointer to the actual data.

• Full-text index is ...read more

Temp tables are used to store temporary data during a session. There are two types: local and global.

• Local temp tables are only accessible within the session that created them.

• Global temp tables are accessible to all sessions and are prefixed with ##.

• Temp tables are automatically dropped when the session that created them ends.

• Temp tables can improve performance by reducing the need for expensive queries or joins.

Query optimization involves identifying and improving the performance of database queries.

• Identify slow queries using profiling tools

• Analyze query execution plans to identify bottlenecks

• Optimize queries by rewriting them or adding indexes

• Use caching to reduce the number of queries

• Regularly monitor and tune the database for optimal performance