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 is as follows:
ALTER <specification> [Specification name]
Answer C is incorrect. The CREATE statement is used to 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 is used 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 used to 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.