Which one of the following capabilities do you expect to see in a majority of RDBMS extensions to ANSI SQL-92?
-
Encryption key management
-
Graphical User Interface Widgets
-
Thread creation, execution, & coordination
-
Network socket creation/operation
-
If/Then, for, do/while statements
RDBMS procedural SQL extensions (PL/SQL, T-SQL) add programming constructs like conditionals and loops for procedural logic. Encryption, GUI widgets, threading, and network sockets are systems-level features outside SQL scope.
Vendor extensions to ANSI SQL-92 most commonly add procedural programming constructs — if/then branching and loops (for, do/while) — because standard SQL-92 is a purely declarative, set-based language with no control-flow statements of its own. This is exactly what PL/SQL, T-SQL, PL/pgSQL and similar dialects add on top of standard SQL. The other options (encryption key management, GUI widgets, thread creation/coordination, network socket operations) are specialized capabilities found in only a minority of RDBMS extensions, or belong to entirely separate subsystems rather than the core SQL language.