-
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 bitwise operations do you know?
Bitwise Operators in Java Bitwise operators in Java operate on individual bits of integer values. These operators are useful for low-level programming, optimizations, and working with binary numbers.
Posted in Без рубрики
Comments Off on Java.Core.What bitwise operations do you know?
Java.Core.What logical operations and operators do you know?
1. Logical AND (&&) The AND (&&) operator returns true only if both operands are true. Otherwise, it returns false.
Posted in Без рубрики
Comments Off on Java.Core.What logical operations and operators do you know?
Java.Core.What do you know about the main() function?
main() Method in Java The main() method is the entry point for Java applications. It is where execution begins when you run a Java program.
Posted in Без рубрики
Comments Off on Java.Core.What do you know about the main() function?
Java.Core.Provide example where we in some object but syncing another one
Example: Synchronizing on a Different Object Sometimes, instead of synchronizing on this, we lock a different object to control access to a shared resource.
Posted in Без рубрики
Comments Off on Java.Core.Provide example where we in some object but syncing another one
Java.Core.Why do we need write smth in parenthesies in synchronized ? why we can’t just type synchronized ?
Why Do We Need Parentheses in synchronized()? In Java, the synchronized keyword requires an object reference inside parentheses (synchronized(obj)) because it tells Java which object’s monitor (lock) to use for synchronization.
Posted in Без рубрики
Comments Off on Java.Core.Why do we need write smth in parenthesies in synchronized ? why we can’t just type synchronized ?
Java.Core.Why do we need instance blocks if we have constructor ?
Why Do We Need Instance Initialization Blocks (IIB) If We Have Constructors? Instance Initialization Blocks (IIB) are not strictly necessary, but they provide some benefits over constructors in certain cases. Here’s why:
Posted in Без рубрики
Comments Off on Java.Core.Why do we need instance blocks if we have constructor ?
Java.Core.Tell me about blocks in Java what are they ?
Blocks in Java A block in Java is a group of statements enclosed within curly braces {}. Blocks define the scope of variables and control execution flow.
Posted in Без рубрики
Comments Off on Java.Core.Tell me about blocks in Java what are they ?
Java.Core.What values are variables initialized to by default ?
🔹 Default Values of Variables in Java In Java, the default value of a variable depends on its data type and where it’s declared (instance variable, static variable, or local variable).
Posted in Без рубрики
Comments Off on Java.Core.What values are variables initialized to by default ?
Java.Core.How does ThreadLocal work in Java?
ThreadLocal in Java ThreadLocal in Java provides thread-local variables, meaning each thread accessing a ThreadLocal variable will have its own isolated copy of that variable. This is useful when you want to store per-thread data without worrying about synchronization.
Posted in Без рубрики
Comments Off on Java.Core.How does ThreadLocal work in Java?
Java.Core.Why do i know class information in compile time ?
You know class information at compile time because Java’s compiler enforces strict static typing. This means that class definitions and type information are determined before your program runs. Here’s why and when you know class information at compile time:
Posted in Без рубрики
Comments Off on Java.Core.Why do i know class information in compile time ?