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

Discussion

Which of the following is a way to create and modify tables using SQL Server?

  • A.Write SQL code using either CREATE or ALTER SQL statements only.
  • B.Use the graphical facilities of SQL Server Enterprise Manager only.
  • C.Both of the two methods above will work.
  • D.Neither of the two methods above will work.

Answer: C

Correct answer: Both of the two methods above will work.

Tables may be created and altered by writing CREATE TABLE and ALTER TABLE statements, or through the graphical designer in Enterprise Manager, which generates the same statements underneath. The graphical route is quicker for a single change; the SQL is what can be scripted, version controlled and applied identically to another server.

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

Post your comment

Please log in or register to post a comment.