Related Questions

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
A are case insensitive.
B are case sensitive.
C must always be in lower case.
D must always be in upper case.
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
Which of the following is an SQL trigger supported by Oracle?
A BEFORE
B INSTEAD OF
C AFTER
D None of the above
In SQL, which of the following is not a data Manipulation Language Commands?
A Delete
B Truncate
C Update
D Create
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
Which command is used to remove an index from the database in SQL?
A DELETE INDEX
B DROP INDEX
C REMOVE INDEX
D ROLL BACK INDEX
E None of the above
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 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 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

Next steps