Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following is the original purpose of SQL?

  • A.To specify the syntax and semantics of SQL data definition language
  • B.To specify the syntax and semantics of SQL manipulation language
  • C.To define the data structures
  • D.All of the above.

Answer: D

Correct answer: All of the above.

SQL was designed as a complete language for relational databases, so it covers all three.

The data definition half defines structures - CREATE, ALTER, DROP. The manipulation half queries and changes data - SELECT, INSERT, UPDATE, DELETE. Defining the data structures is what the first half achieves. That combination is what made SQL displace the separate languages the earlier database models required, and it is why one standard covers both syntax and semantics.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.