exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam

Exam 98-364 topic 1 question 38 discussion

Actual exam question from Microsoft's 98-364
Question #: 38
Topic #: 1
[All 98-364 Questions]

Which category of SQL statements is used to add, remove, and modify database structures?

  • A. Data access language (DAL)
  • B. Data manipulation language (DML)
  • C. Data control language (DCL)
  • D. Data definition language (DDL)
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
jrn1992
Highly Voted 5 years ago
DDL(Data Definition Language) : DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database. Examples of DDL commands: CREATE – is used to create the database or its objects (like table, index, function, views, store procedure and triggers). DROP – is used to delete objects from the database. ALTER-is used to alter the structure of the database. TRUNCATE–is used to remove all records from a table, including all spaces allocated for the records are removed. COMMENT –is used to add comments to the data dictionary. RENAME –is used to rename an object existing in the database.
upvoted 22 times
...
dzoni68
Most Recent 3 years ago
DDL statements are used to build and modify the structure of tables and other objects in the database.
upvoted 1 times
...
Gr8Cate
3 years, 7 months ago
Correct answer is DML - B.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...