-
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
Java.Core.Why if-else is slower ?
Why is if-else Slower than switch in Java (When Using Strings)? The performance difference between if-else and switch comes down to how Java processes conditions: if-else checks each condition sequentially (one by one). switch uses a lookup mechanism (hashing and … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Why if-else is slower ?
Java.Core.Can strings be used in a switch statement?
Yes! Strings can be used in a switch statement starting from Java 7. This allows developers to write cleaner and more readable code when comparing multiple string values.
Posted in Без рубрики
Comments Off on Java.Core.Can strings be used in a switch statement?
Java.Core.What does the intern() method do in the String class?
What Does the intern() Method Do in the String Class? The intern() method in the Java String class is used to store a string in the String Pool and return a reference to the pooled instance. This ensures that identical … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.What does the intern() method do in the String class?
Java.Core.Why is String a popular key in HashMap in Java?
String is one of the most commonly used key types in HashMap because of the following reasons: 1. String is Immutable (Ensures Key Stability) String objects cannot be modified after creation. This makes String safe to use as a key … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Why is String a popular key in HashMap in Java?
Java.Core.Why is char[] preferred over String for storing passwords?
In security-sensitive applications, char[] is preferred over String for storing passwords due to the following reasons: 1. Strings Are Immutable (Cannot Be Cleared from Memory) String objects cannot be modified because they are immutable. If you store a password in … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Why is char[] preferred over String for storing passwords?
Java.Core.What means Hash code is cached, making hash-based collections faster. Where is that cached ?
In Java, the hash code of a String is computed only once and then cached, making lookups in hash-based collections (HashMap, HashSet, Hashtable) faster.
Posted in Без рубрики
Comments Off on Java.Core.What means Hash code is cached, making hash-based collections faster. Where is that cached ?
Java.Core.Why is String an immutable and finalizable class?
Why is String Immutable and Final in Java? The String class in Java is immutable (cannot be modified) and final (cannot be subclassed). This design choice was made for security, performance, and thread safety reasons.
Posted in Без рубрики
Comments Off on Java.Core.Why is String an immutable and finalizable class?
Java.Core.What are limitations of string pool ?
While the String Pool provides memory efficiency and performance benefits, it also has some limitations: 1. Increased Memory Usage for Too Many Unique Strings The String Pool is stored in the heap, but if too many unique strings are created, … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.What are limitations of string pool ?
Java.Core.What is a “string pool”?
What is a String Pool in Java? The String Pool (also known as the String Intern Pool) is a special memory area in the heap where Java stores string literals to optimize memory usage and improve performance. When you create … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.What is a “string pool”?
Java.Core.What are the features of the String class?
Features of the String Class in Java The String class in Java is one of the most commonly used classes and provides several important features. 1. Strings are Immutable Once a String object is created, its value cannot be changed. … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.What are the features of the String class?