-
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.Advanced.How does the JVM handle native method calls?
🔗 What is a Native Method? A native method is a method declared in Java, but implemented in a language like C or C++. These methods are usually marked with the native keyword, for example: ⚙️ How the JVM Handles … Continue reading
Posted in Без рубрики
Comments Off on JVM.Advanced.How does the JVM handle native method calls?
JVM.Advanced.Specification
🔥 Love this question — it shows you’re thinking at system design level! 📜 1. What is the JVM Specification? The JVM Specification (or JVM Spec) is an official document maintained by Oracle. It defines: ✅ What the JVM must … Continue reading
Posted in Без рубрики
Comments Off on JVM.Advanced.Specification
JVM.Advanced.What is the purpose of the Metaspace in JVM?
The Metaspace in the JVM (Java Virtual Machine) is a memory space that was introduced in Java 8, replacing the older PermGen space. Its primary purpose is to store class metadata, which includes information about class structures, methods, fields, annotations, … Continue reading
Posted in Без рубрики
Comments Off on JVM.Advanced.What is the purpose of the Metaspace in JVM?
JVM.Internals.How does the JVM handle dynamic linking?
🌐 What is Dynamic Linking? In simple words: Dynamic linking means the JVM does not resolve all method calls, field accesses, and class references at compile time — instead, it resolves them at runtime, when the class is actually loaded.
Posted in Без рубрики
Comments Off on JVM.Internals.How does the JVM handle dynamic linking?
JVM.Internals.What is the role of the JVM instruction set in executing Java programs?
🔥 What is the JVM Instruction Set? The JVM instruction set is the complete set of low-level operations (called bytecode instructions) that the Java Virtual Machine understands and executes. When you write a Java program and compile it, your .java … Continue reading
Posted in Без рубрики
Comments Off on JVM.Internals.What is the role of the JVM instruction set in executing Java programs?
Java.What are literals ?
🔥 What are Literals in Java? Definition Literals in Java are fixed, constant values that you write directly in your code. These are “hardcoded” values that represent themselves.
Posted in Без рубрики
Comments Off on Java.What are literals ?
JVM.Internals.What is symbolic link in bytecode ?
What is a Symbolic Link in Bytecode? In the context of Java bytecode (which I assume you’re asking about, since you’re into Java backend development), the term symbolic link can have different meanings depending on the context, but here’s the … Continue reading
Posted in Без рубрики
Comments Off on JVM.Internals.What is symbolic link in bytecode ?
JVM.ConstantPool.How are constant pool entries stored and accessed by the JVM?
💾 What is the Constant Pool? The constant pool is a table stored inside every .class file. It contains a list of symbolic references used by the class — essentially, all the constants and symbolic metadata the class needs.
Posted in Без рубрики
Comments Off on JVM.ConstantPool.How are constant pool entries stored and accessed by the JVM?
JVM.Internals.What is the purpose of the Method Area in JVM memory?
📦 What is the Method Area? The Method Area is a part of the JVM Runtime Data Area, and its purpose is to store class-level data. This includes metadata about classes, methods, and fields. It is essentially where the JVM … Continue reading
Posted in Без рубрики
Comments Off on JVM.Internals.What is the purpose of the Method Area in JVM memory?
JVM.Internals.How does the JVM handle exceptions internally?
💥 What Happens When an Exception is Thrown? When your code executes something like: The JVM does several things:
Posted in Без рубрики
Comments Off on JVM.Internals.How does the JVM handle exceptions internally?