-
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.Servlet.What is a JavaBean?
A JavaBean is just a regular Java class that: Has a public no-argument constructor (so the server can create it easily). Has private fields (data) with public getter and setter methods. Implements Serializable interface (optional, but often recommended for distributed … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is a JavaBean?
Java.Servlet.What variable scopes exist in JSP?
In JSP, variable scopes define where and how long a variable (object) is available during the lifecycle of a web application. There are four variable scopes in JSP: Scope Object Availability Lifetime page Available only in the current page Until … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What variable scopes exist in JSP?
Java.Servlet.What do you know about JSP actions (Action tag and JSP Action Elements).JSP – servlet – JSP interaction.
JSP Actions (also called JSP Action Tags or JSP Action Elements) are special XML-like tags that perform predefined tasks when a JSP page is processed. They are part of the JSP specification itself (not user-defined or third-party) and are executed … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What do you know about JSP actions (Action tag and JSP Action Elements).JSP – servlet – JSP interaction.
Java.Servlet.What are the main types of JSP tags?
📜 1. Directive Tags Used to give instructions to the JSP engine at translation time (before the page is turned into a servlet). They control things like page settings, imports, and file inclusion. Syntax: Examples: <%@ page language=”java” contentType=”text/html” %> … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What are the main types of JSP tags?
Java.Servlet.How to comment out code in JSP?
In JSP, there are three types of comments, depending on what exactly you want: 📝 1. HTML Comments It will appear in the browser’s page source (users can see it if they view source). Used to explain client-side code (HTML, … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.How to comment out code in JSP?
Java.Servlet.What is the difference between dynamic and static JSP content?
📜 Static vs Dynamic Content in JSP Aspect Static Content Dynamic Content Definition Content that does not change for each user or request. Content that can change depending on request parameters, user input, or backend logic. Written as Plain HTML, … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is the difference between dynamic and static JSP content?
Java.Servlet.How can we prevent direct access to a JSP page from a browser?
Excellent and very practical question!There are several ways to prevent users from directly accessing a JSP page from a browser. Here’s a structured explanation: 🔥 1. Place JSPs under WEB-INF/ Folder Files inside WEB-INF cannot be accessed directly via a … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.How can we prevent direct access to a JSP page from a browser?
Java.Servlet.Which JSP life cycle methods can be overridden?
✨ JSP life cycle methods that you can override: Method Can Override? Purpose jspInit() ✅ Yes For initialization tasks (e.g., setting up resources) jspDestroy() ✅ Yes For cleanup tasks (e.g., closing connections) ✅ You can override jspInit() and jspDestroy() by … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Which JSP life cycle methods can be overridden?
Java.Servlet.Explain the methods of the JSP life cycle.
Of course!In the JSP life cycle, several key methods are automatically called by the server at different stages.These methods come either from the servlet API (because JSPs become servlets) or from special JSP interfaces. Here are the main methods involved: … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Explain the methods of the JSP life cycle.
Java.Servlet.Explain the stages (phases) of the JSP life cycle.
Sure!The JSP life cycle describes the stages a JSP page goes through inside the server, from its creation to serving requests and eventually being destroyed. There are 5 main phases: 🚀 1. Translation Phase The server translates the JSP file … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Explain the stages (phases) of the JSP life cycle.