-
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 is the role of the Class class in Java?
Role of the Class Class in Java In Java, the Class class is a part of the Reflection API and represents metadata about a class at runtime. It is located in the java.lang package and provides methods to: Obtain information … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.What is the role of the Class class in Java?
Java.Core.What is the enum type in Java? Provide examples of its use.
In Java, an enum (short for “enumeration”) is a special data type used to define a collection of constants. Each constant in an enum is implicitly public, static, and final. Enums are commonly used when a variable can take only … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.What is the enum type in Java? Provide examples of its use.
Java.Core.What is reflection in Java, and how is it used?
🔍 What is Reflection in Java? Reflection is the ability of a Java program to inspect, analyze, and even modify itself at runtime — meaning you can inspect classes, methods, fields, and constructors even if you don’t know them at … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.What is reflection in Java, and how is it used?
Java.Core.Explain the difference between Serializable and Externalizable.
Awesome question! Let’s break down the difference between Serializable and Externalizable, because they both deal with serialization — but they work very differently.
Posted in Без рубрики
Comments Off on Java.Core.Explain the difference between Serializable and Externalizable.
Java.Core.SerializationFormats
By default, Java’s built-in serialization (Serializable) works with binary streams — meaning the object is serialized into a byte stream (essentially a compact, unreadable format for humans). However, you can absolutely serialize objects into other formats like text (JSON, XML, … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.SerializationFormats
Java.Core.Serialization
How does Serialization work? Step 1: Implement Serializable For a class to support serialization, it must implement the java.io.Serializable interface.
Posted in Без рубрики
Comments Off on Java.Core.Serialization
Java.Core.Explain the purpose of the transient keyword in Java
The transient keyword in Java is used to indicate that a field should not be serialized when an object is converted into a byte stream (for example, when saving to a file, sending over a network, or caching).
Posted in Без рубрики
Comments Off on Java.Core.Explain the purpose of the transient keyword in Java
Java.Core.Generics.TypeErasure
🔹 What is Type Erasure? Type erasure is a process performed by the Java compiler when working with generics. In short: The compiler removes (erases) all generic type information during compilation, replacing it with raw types or bounds (like Object … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Generics.TypeErasure
Java.Core.WildcartReadWriteLimitations
This is one of the most confusing (but important) parts of generics and wildcards in Java. Let me explain this step by step — and once you understand the logic, it will make perfect sense. 🔥
Posted in Без рубрики
Comments Off on Java.Core.WildcartReadWriteLimitations
Java.Core.GenericWildcard
🏆 What Are Wildcards (?) in Java? Wildcards allow you to use unknown types in generics. They are useful when working with collections of different but related types. Types of Wildcards in Java Wildcard Meaning Example ? (Unbounded) Accepts any … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.GenericWildcard