Category Archives: Technology

Advanced .Net Interview Questions


 What is something substantive that you’ve done to improve as a developer in your career? You’ve just been assigned to a project in a new technology how would you get started? Why singleton pattern is considered an Anti-pattern ?  What is the use of volatile keyword? The volatile keyword indicates that a field might […]
Read More »

Using the fingerprint reader to unlock Arch Linux


login to i3 window manager using i3lock using the fingerprint reader (X1-Carbon)

12 Oracle Design Consideration


Oracle Design Consideration, Index organized tables, partitioned tables, range partition, list partition, hash partition, composite partition

11 House Keeping in Oracle


House keeping in Oracle: invalid optimizer statistics, buffer gets, Disk Reads

10 Oracle Hints to the Database


Oracle SQL performance tuning. using Hints in the database query

08 Considerations while using PLSQL in programming (Oracle)


Considerations while using PLSQL in programming (Oracle)

07 Performance Improvement Consideration


Oracle Performance Improvement Consideration, union vs OR, Union all vs Union, exist vs IN

06 Index Suppression


Index Suppression in Oracle, operators, sub-strings, Arithmetic operators, Truncate , function based index

05 Simple Tuning Rules


Simple Tuning Rules for Oracle. Where vs having, table aliases

04 Explain Plan


Oracle Explain Plan, Execution Plan,