-
MY PROJECTS
-
Recent Posts
- SQL.How can you compare two nullable values safely, and how does IS DISTINCT FROM differ from <>?
- SQL.How are NULL values ordered by ORDER BY, how do defaults differ between databases, and how can you control their placement?
- SQL.How does NULL propagate through arithmetic expressions, and how can COALESCE and NULLIF help handle missing values and division by zero?
- SQL.How does NULL affect join conditions, and why can filtering the right-hand table in WHERE remove unmatched rows from a LEFT JOIN?
- SQL.How do GROUP BY and DISTINCT treat NULL values, even though NULL = NULL evaluates to UNKNOWN?
- SQL.How do aggregate functions handle NULL, and what is the difference between COUNT(*), COUNT(column), and COUNT(DISTINCT column)?
- SQL.How does NULL affect IN and NOT IN, and why can NOT EXISTS be a safer choice when a subquery returns nullable values?
- SQL.How do WHERE, HAVING, and CHECK constraints treat conditions that evaluate to UNKNOWN?
- SQL.Why do column = NULL and column <> NULL not work as expected, and when should you use IS NULL and IS NOT NULL?
- SQL.What is SQL’s three-valued logic (TRUE, FALSE, UNKNOWN), and how do AND, OR, and NOT behave with UNKNOWN?
- ChromeDevTools.Watch all failed requests
- SQL.What are domain types (or constraints on data types), and how do they help enforce data correctness?
- SQL.How does SQL handle comparisons between different data types (for example, string vs number), and why is this dangerous?
- SQL.What is the difference between DATE, TIME, TIMESTAMP, and TIMESTAMPTZ, and which one should be used for business events?
- SQL.How do numeric types like INTEGER, BIGINT, DECIMAL, and FLOAT differ in terms of precision and use cases?
- SQL.What problems can arise from implicit type casting in SQL, and how can it affect indexes?
- SQL.How does NULL differ from 0, an empty string, or FALSE in SQL?
- SQL.What is the difference between CHAR, VARCHAR, and TEXT, and when would you choose each?
- SQL.What is MVCC ?
- SQL.What is AutoVacuum Postgres ?
Categories
- Aptana
- Azure
- C#
- DataSnap
- DBExpress
- Delphi
- Delphi и сети
- Delphi. Язык программирования
- ExtJS
- FastReport
- FireDAC
- FireMonkey
- GIT
- ICS
- IDE
- IIS
- Indy
- InnoSetup
- javascript
- jQuery
- JSON
- LiveBindings
- MSHTML
- MySQL
- PHP
- REST
- Ribbons
- SMS
- SQL инструкции
- SVN
- TRichView
- UniGui
- WebBroker
- WinAPI
- Windows
- Алгоритмы
- Без рубрики
- Деревья
- Ищу ответ
- Компонентостроение
- Мои компоненты
- Начальный уровень
- Обработка исключений
- Парсинг
- Потоки(Threads)
- Регулярные выражения
- Тестирование приложений
Author Archives: Stanislav_Panteleev
JVM.GC.Why do we need weak references ?
Why Do We Need Weak References in Java? Weak references in Java allow objects to be garbage collected while still being referenced, which is useful for caching, memory-sensitive applications, and preventing memory leaks.
Posted in Без рубрики
Comments Off on JVM.GC.Why do we need weak references ?
JVM.GC.What are soft, weak, and phantom references in Java, and how do they affect garbage collection?
Soft, Weak, and Phantom References in Java In Java, objects are normally referenced strongly, meaning they are not eligible for garbage collection as long as a strong reference exists. However, Java provides Soft, Weak, and Phantom references in the java.lang.ref … Continue reading
Posted in Без рубрики
Comments Off on JVM.GC.What are soft, weak, and phantom references in Java, and how do they affect garbage collection?
JVM.GC.How do you trigger garbage collection manually, and why is it discouraged?
Although Garbage Collection (GC) in Java is automatic, you can suggest it manually using the following methods:
Posted in Без рубрики
Comments Off on JVM.GC.How do you trigger garbage collection manually, and why is it discouraged?
JVM.What is major, minor, full gc ?
Major GC vs. Minor GC in Java Garbage Collection Garbage collection (GC) in Java is categorized into Minor GC and Major GC, based on which part of the heap is being cleaned.
Posted in Без рубрики
Comments Off on JVM.What is major, minor, full gc ?
JVM.GC.Why regions still need split memory for young and all generation?
Even though Garbage First (G1GC), ZGC, and Shenandoah divide the heap into regions instead of fixed generations, they still logically separate memory into Young and Old generations. This is because generational garbage collection is still the most efficient way to … Continue reading
Posted in Без рубрики
Comments Off on JVM.GC.Why regions still need split memory for young and all generation?
JVM.GarbageCollection.What means GC only selects regions with the most garbage instead of scanning the entire Young Generation?
This phrase refers to how region-based garbage collectors (like G1GC, ZGC, and Shenandoah) optimize memory cleanup by prioritizing the collection of regions that contain the most garbage, instead of scanning and collecting the entire Young Generation at once (as done … Continue reading
Posted in Без рубрики
Comments Off on JVM.GarbageCollection.What means GC only selects regions with the most garbage instead of scanning the entire Young Generation?
JVM.GC.Explain the different garbage collection algorithms used by the JVM (e.g., Serial, Parallel, CMS, G1).
Garbage Collection Algorithms in the JVM The JVM provides multiple Garbage Collection (GC) algorithms to efficiently manage heap memory by reclaiming space from objects that are no longer needed.
Posted in Без рубрики
Comments Off on JVM.GC.Explain the different garbage collection algorithms used by the JVM (e.g., Serial, Parallel, CMS, G1).
JVM.GC.What is garbage collection in Java, and how does it work?
Garbage Collection in Java Garbage Collection (GC) in Java is the automatic process of reclaiming memory occupied by objects that are no longer reachable. The Java Virtual Machine (JVM) manages memory dynamically, ensuring that unreferenced objects are removed to prevent … Continue reading
Posted in Без рубрики
Comments Off on JVM.GC.What is garbage collection in Java, and how does it work?
JVM.MemoryManagement.How does the JVM manage memory for primitives and objects ?
JVM Memory Management for Primitives and Objects The Java Virtual Machine (JVM) manages memory using a structured approach, allocating primitives and objects differently within the heap and stack memory.
Posted in Без рубрики
Comments Off on JVM.MemoryManagement.How does the JVM manage memory for primitives and objects ?
JVM.MemoryManagement.What are memory leaks in Java, and how can you prevent them?
Memory Leaks in Java A memory leak in Java occurs when an application unintentionally holds references to objects that are no longer needed, preventing the Garbage Collector (GC) from reclaiming memory. Over time, this can lead to OutOfMemoryError and degrade … Continue reading
Posted in Без рубрики
Comments Off on JVM.MemoryManagement.What are memory leaks in Java, and how can you prevent them?