Mark works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database.
Mark has to change the properties of an object inside the database. Which of the following statements will he
use to accomplish the task?
A.
DROP
B.
UPDATE
C.
CREATE
D.
ALTER
Explanation:
The ALTER statement in SQL changes the properties of an object inside DBMS. The types of objects that can
be altered depend on which DBMS
is being used. The syntax of the ALTER statement isas follows:
ALTER <specification> [Specification name]
Answer C is incorrect. The CREATE statement is usedto make a new database, table, index, or stored query.
The CREATE statement in
SQL creates an object inside DBMS. The types of objects that can be created depend on which DBMS is being
used, but most support the
creation of tables, indexes, users, and databases.
Answer A is incorrect. The DROP statement in SQL isused to remove an object from an RDBMS. The types of
objects that can be
dropped depend on which RDBMS is being used, but most support the dropping of tables, users, and
databases. The syntax of the DROP
TABLE statement is as follows:
DROP TABLE “table_name”
Answer B is incorrect. The UPDATE statement is usedto directly change or modify the values stored in one or
more fields in a specified
record in a single table. Using the UPDATE statement, either all the rows can be updated, or a subset may be
chosen using a given condition.