What happens if the command ALTER TABLE <tablename> DEALLOCATE UNUSED is used without the KEEP clause?

Which of the following cannot be placed in the declaration part of PL/SQL?

Before any SQL statement is parsed, Oracle will check the _______ to see if that same statement already exists there.

Which of the following SQL functions can operate on any datatype?

One of these datatypes is NOT a base scalar datatype?

When executing the command: "show parameter xxxx", ORA-00942: table or view does not exist appears. Which of the following best explains this error?

What clause follows "group by" in SQL?

You need to search for text data in a column, but you only remember part of the string. Which of the following SQL operations allows the use of wildcard comparisons?

The DBA assigns permission to the user using this command:

True or False: "Select for Update" performs the function "Lock the record on result set."

Which of the following is not DML (Data Manipulation Language)?