SQL Approaches - Quiz Explanation

The correct answers are indicated below, along with text that explains the correct answers.
 
1. What is a dialect?
Please select the best answer.
  A. A dialect refers to the origin of SQL and is generally geographically oriented.
  B. A dialect results when a particular database engine chooses to ignore the standards and create its own version of the SQL-92 standard.
  C. A dialect refers to statements that make up exceptions and/or additions to the SQL-92 standard and are relative to a particular database engine.
  D. All of the above.
  The correct answer is C.
When database engineers make special addtions or exception to SQL-92 that work only with their database, they are making a syntax.

2. What type of language is SQL?
Please select the best answer.
  A. Instructional
  B. English-like
  C. ANSI-standard
  D. Declarative
  The correct answer is D.
Although the other statements may be true, only declarative actually states what type of language SQL is.

3. Which explanation most closely matches a definition of client/server approaches to applications?
Please select the best answer.
  A. Client/server refers to how the application is developed, with the client providing the software specification for use on the server.
  B. Client/server refers to the fact that the application uses a central file and print server.
  C. Client/server lets you split functionality between the workstation and the server, allowing each do what it does best for the application.
  D. Client/server is a term for an Internet-enabled application.
  The correct answer is C.
The client-server model allows the client to request information that can be gathered by the server. The server then delivers the data in a way the client can use, so each computer is doing what it does best.


Data-Driven Science and Engineering