Related Questions

Which command is used to remove a table from the database in SQL?
A DELETE TABLE
B DROP TABLE
C ERASE TABLE
D UNATTACH TABLE
E None of the above
In SQL, which command is used to remove a stored function from the database?
A REMOVE FUNCTION
B DELETE FUNCTION
C DROP FUNCTION
D ERASE FUNCTION
E None of the above
In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.
A True
B False
In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.
A True
B False
In SQL, which command(s) is(are) used to enable/disable a database trigger?
A MODIFY USER
B CHANGE USER
C ALTER TRIGGER
D All of the above
E None of the above
In SQL, which command is used to create a database user?
A ADD USER TO DATABASE
B MK USER
C CREATE USER
D All of the above
E None of the above
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
A ALTER INDEX
B REDEFINE INDEX
C MODIFY INDEX
D DO INDEX
E None of the above
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
A Open
B Show
C Alter
D Edit
To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included.
A ONLY
B DISTINCT
C UNIQUE
D SINGLE
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
A True
B False

Next steps