-
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.What are the advantages of using generics in Java?
Generics in Java are one of the most powerful language features, especially for writing type-safe, reusable, and flexible code. Here’s a clear breakdown of the key advantages of using generics:
Posted in Без рубрики
Comments Off on Java.Core.What are the advantages of using generics in Java?
Java.Core.ParallelStreams
🔗 What are Parallel Streams? Parallel Streams are a feature of the Java Stream API (introduced in Java 8) that allows you to process a collection of data in parallel — meaning the work is split into multiple threads that … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.ParallelStreams
Java.Core.What is the difference between shallow copy and deep copy in Java?
Let’s break down the difference between shallow copy and deep copy in Java — this is a classic interview topic, especially for cloning objects.
Posted in Без рубрики
Comments Off on Java.Core.What is the difference between shallow copy and deep copy in Java?
Java.Core.How does the Fork/Join framework work in Java?
🌐 What is the Fork/Join Framework? The Fork/Join Framework is a high-performance parallel computing framework designed to split large tasks into smaller subtasks, which can be processed in parallel on multiple CPU cores. After processing, results are combined (joined) to … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.How does the Fork/Join framework work in Java?
Java.Core.Why lambda work only with functional interfaces ?
🌐 First, What is a Functional Interface? A functional interface is an interface with exactly one abstract method.Examples:✅ Runnable (1 method: run())✅ Comparator (1 method: compare())✅ Callable (1 method: call())✅ Predicate (1 method: test())
Posted in Без рубрики
Comments Off on Java.Core.Why lambda work only with functional interfaces ?
Java.Core.What are lambda expressions, and why are they used?
🌐 What are Lambda Expressions? A lambda expression is a short, concise way to write anonymous functions (inline functions).It allows you to pass behavior (code) as a method argument — instead of writing long-winded anonymous classes.
Posted in Без рубрики
Comments Off on Java.Core.What are lambda expressions, and why are they used?
Java.Core.Provide example where we need class retention
For codegeneration tools, like Lombok 🌐 What is RetentionPolicy.CLASS? Definition @Retention(RetentionPolicy.CLASS) means the annotation is: ✅ Present in the compiled .class file❌ Not available at runtime (no reflection access)
Posted in Без рубрики
Comments Off on Java.Core.Provide example where we need class retention
Java.Core.If i don’t add @Override annotation will method be overrided ?
✅ Short Answer Yes, the method can still be overridden even if you don’t add @Override — but you lose the compiler’s help in checking correctness.
Posted in Без рубрики
Comments Off on Java.Core.If i don’t add @Override annotation will method be overrided ?
Java.Core.Provide example where we need source retention
Source retention needed for static analysis tool, for ex. Let’s walk through a practical example where @Retention(RetentionPolicy.SOURCE) is the best choice. This is typically used for compile-time annotations — annotations that are only useful to the compiler, linters, documentation tools, … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Provide example where we need source retention
Java.Core.AnnotationRetention
@Retention is a meta-annotation, meaning it’s an annotation used to annotate other annotations.It tells the compiler and JVM how long your annotation should be retained (kept).
Posted in Без рубрики
Comments Off on Java.Core.AnnotationRetention