PrepAway - Latest Free Exam Questions & Answers

Which of the following correctly describe SQL (Choose all that apply.?

Which of the following correctly describe SQL (Choose all that apply.?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply