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:
Quoted directly from Sun’s Java document site at
http//developer.java.sun.com/ 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.