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 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 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 used to 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.