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:
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