-
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 difference between checked and unchecked exceptions?
Difference Between Checked and Unchecked Exceptions in Java Exceptions in Java are categorized into checked and unchecked exceptions based on whether the compiler enforces handling.
Posted in Без рубрики
Comments Off on Java.Core.What is the difference between checked and unchecked exceptions?
Java.Core.What is a checked and unchecked exception?
In Java, exceptions are classified into checked and unchecked exceptions based on whether the compiler forces handling at compile time.
Posted in Без рубрики
Comments Off on Java.Core.What is a checked and unchecked exception?
Java.Core.What types of exceptions in Java do you know, how do they differ?
Types of Exceptions in Java & Their Differences In Java, exceptions are categorized based on their recoverability and handling requirements. The main types are: Checked Exceptions (Compile-time exceptions) Unchecked Exceptions (Runtime exceptions) Errors (Serious system-level issues)
Posted in Без рубрики
Comments Off on Java.Core.What types of exceptions in Java do you know, how do they differ?
Java.Core.Philosophy behind checked and unchecked exceptions
1. Philosophy Behind Checked vs. Unchecked Exceptions Checked Exceptions (IOException, SQLException, etc.) Represent recoverable conditions that are beyond the developer’s control. The compiler forces handling to prevent errors at runtime. Example: File not found, network failure, database connection issues. Unchecked … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Philosophy behind checked and unchecked exceptions
Java.Core.Describe the hierarchy of exceptions
Java provides a structured exception handling mechanism based on an inheritance hierarchy. At the top, all exceptions and errors are subclasses of Throwable, which is further divided into Exception and Error. Top-Level Hierarchy
Posted in Без рубрики
Comments Off on Java.Core.Describe the hierarchy of exceptions
Java.Core.Why Try-with-resources (try with AutoCloseable) is a better alternative to finally for resource
In Java, try-with-resources (introduced in Java 7) is a more elegant and reliable way to manage resources like file streams, sockets, and database connections compared to using finally. It ensures that resources are closed automatically, reducing boilerplate code and eliminating … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Why Try-with-resources (try with AutoCloseable) is a better alternative to finally for resource
Java.Core.How does Java handle exceptions with try-catch-finally?
In Java, exceptions are handled using the try-catch-finally construct, which allows developers to manage errors gracefully and prevent abrupt program termination. Here’s how it works:
Posted in Без рубрики
Comments Off on Java.Core.How does Java handle exceptions with try-catch-finally?
Java.Collections.Why Do Keys with Different Hash Codes End Up in the Same Bucket in a HashMap?
Yes, I know! In HashMap (and other hash-based data structures), keys with different hash codes can end up in the same bucket due to the mechanics of hashing and bucket indexing. Why Does This Happen? The Bucket Array Has a … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.Why Do Keys with Different Hash Codes End Up in the Same Bucket in a HashMap?
Java.Core.There is a class Point{int x, y;}. Why is a hash code of the form 31 * x + y preferable to x + y?
🚀 Why Is 31 * x + y Preferable to x + y for hashCode() in a Point Class? When implementing hashCode(), 31 * x + y is preferred over x + y because it produces better hash distribution, reducing … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.There is a class Point{int x, y;}. Why is a hash code of the form 31 * x + y preferable to x + y?
Java.Core.Is it possible to implement the equals() method of the MyClass class like this: class MyClass {public boolean equals(MyClass that) {return this == that;}}?
1️⃣ Why Is This Implementation Wrong? ❌ Incorrect equals() Implementation 📌 Problems: Does Not Override Object.equals(Object) Java does not recognize this as an override because the method signature must be equals(Object that). It is a separate method, not an actual … Continue reading
Posted in Без рубрики
Comments Off on Java.Core.Is it possible to implement the equals() method of the MyClass class like this: class MyClass {public boolean equals(MyClass that) {return this == that;}}?