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

Discussion

SQL can be used to:

  • A.create database structures only.
  • B.query database data only.
  • C.modify database data only.
  • D.All of the above can be done by SQL.

Answer: D

Correct answer: All of the above can be done by SQL.

SQL is a complete database language and covers all three. Creating structures is its data definition half, through CREATE, ALTER and DROP; querying and modifying data is its manipulation half, through SELECT, INSERT, UPDATE and DELETE.

A third part, data control, grants and revokes permissions. That breadth is precisely what made SQL displace the earlier database models, which needed separate languages for schema definition and for data access.

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

Post your comment

Please log in or register to post a comment.