正解:C,D
SQL (Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system.
A). False. SQL does not have graphical capabilities; it is a textual language for database interaction.
B). False. SQL supports variable definition, but it is not a core feature of the language. Variables are more commonly defined in procedural extensions to SQL, such as PL/SQL in Oracle.
C). True. SQL provides database transaction control through statements like COMMIT, ROLLBACK, and SAVEPOINT.
D). True. SQL is designed for processing sets of data, allowing for operations such as selection, projection, and joins on sets of rows.
E). False. SQL does not provide capabilities to update data in external files. It operates on data within the database.