You work as a Database Administrator for DataOneWorld Inc. Management instructs you to remove an object
from the relational database management system. Which of the following statements will you use to
accomplish the task?
A.
DROP
B.
SELECT
C.
CREATE
D.
ALTER
Explanation:
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 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 D is incorrect. 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 B is incorrect. The SELECT statement is usedto select data from a database. The result is stored in a
result table called the result-set. The SELECT statement retrieves zero or more rows from one or more base
tables, temporary tables, or views in a database.