Which of the following correctly describe SQL (Choose all that apply)?
A.
It is application-specific
B.
It is very expressive
C.
It can initiate high-level actions
D.
It can work without connecting to a database via caching
E.
It can work without connecting to a database via offline access mode
F.
It can work without connecting to a database via auto commit mode
Explanation:
Because SQL is an application-specific language, a single statement can be very
expressive and can initiate high-level actions, such as sorting and merging, on an entire
set of data. SQL was standardized in 1992 so that a program could communicate with
most database systems without having to change the SQL commands. However, you
must connect to a database before sending SQL commands, and each database vendor has
a different interface to do so, as well as different extensions of SQL. Enter ODBC.