-
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)
- Регулярные выражения
- Тестирование приложений
Category Archives: Без рубрики
Java.Hibernate.Beginner.How do you open a Hibernate session?
You open a Hibernate session by calling openSession() on a SessionFactory instance. The session represents a single unit of work and serves as the main interface for CRUD operations, queries, and transaction management. 🔹 What happens when you open a … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.How do you open a Hibernate session?
Java.Hibernate.Beginner.What is a Hibernate Dialect?
A Hibernate Dialect is a class in Hibernate that encapsulates the SQL variations, syntax rules, and database-specific behaviors for a particular relational database (RDBMS). 🔹 What it does: Translates Hibernate’s abstract SQL into database-specific SQL. Knows the SQL features and … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What is a Hibernate Dialect?
Java.Hibernate.How do you specify the database dialect in Hibernate?
You specify the database dialect in Hibernate using the hibernate.dialect property. This tells Hibernate which SQL dialect to use so it can generate database-specific SQL statements compatible with your database system (e.g., MySQL, PostgreSQL, Oracle). 🔹 Why is dialect important? … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.How do you specify the database dialect in Hibernate?
Java.Hibernate.Beginner.What is the purpose of hibernate.properties?
hibernate.properties is an alternative configuration file for Hibernate where you can specify key-value pairs of Hibernate settings, like database connection details and other properties — similar to what you’d define in hibernate.cfg.xml, but in a simpler .properties format. 🔹 What … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What is the purpose of hibernate.properties?
Java.Hibernate.Beginner.Can you configure Hibernate using annotations instead of XML?
Yes — Hibernate (and JPA) support annotations as a modern alternative to XML mapping files. You can map your entities, primary keys, relationships, and other metadata directly in your Java classes using standard JPA or Hibernate-specific annotations. 🔹 Key annotations … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.Can you configure Hibernate using annotations instead of XML?
Java.Hibernate.Beginner.What is hibernate.cfg.xml?
hibernate.cfg.xml is Hibernate’s central configuration file, traditionally used to define settings required for Hibernate to connect to the database and set up its behavior. It’s an XML file placed in your project’s classpath (usually in src/main/resources), and it’s used when … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What is hibernate.cfg.xml?
Java.Hibernate.Beginner.How do you enable second-level caching?
✅ How do you enable second-level caching in Hibernate? Answer:Second-level cache is optional in Hibernate — to enable it, you need to: 🔹 1️⃣ Enable second-level cache globallyAdd this property in your Hibernate configuration (e.g., hibernate.cfg.xml, application.properties, or application.yml): 🔹 … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.How do you enable second-level caching?
Java.Hibernate.Beginner.How does first-level cache work by default?
✅ How does the first-level cache work by default in Hibernate? Answer:The first-level cache is Hibernate’s mandatory, built-in mechanism for tracking entities within a single Session. Here’s exactly how it works by default: 🔹 Always enabled First-level cache is always … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.How does first-level cache work by default?
Java.Hibernate.Beginner.Query cache is example of 2 level cache ?
✅ Is the query cache an example of second-level cache? Answer:🔹 The query cache itself is not the same thing as the second-level cache, but it depends on the second-level cache to work effectively. The query cache caches query result … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.Query cache is example of 2 level cache ?
Java.Hibernate.Beginner.What difference to first level cache ?
✅ What’s the difference between query cache and first-level cache in Hibernate? 🔹 First-Level Cache✅ Scope: Limited to a single Hibernate Session.✅ Enabled: Always on — cannot be disabled.✅ Purpose: Caches individual entity instances you load, save, or update in … Continue reading
Posted in Без рубрики
Comments Off on Java.Hibernate.Beginner.What difference to first level cache ?