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?

Which one of these statements is true about a concatenated index?

The Oracle server provides a number of standard data dictionary views to obtain information on database and instance. These views are:

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)?

Which of the following is(are) physical storage file(s) of Oracle?

Which of the following operators can be used to substitute the 'IN' operator in a SELECT statement?