The exception INVALID_FILEHANDLE can occur when the following procedures are called?

Which of the following exceptions are valid regarding util_file package

The package util_file can be used to read the files from Windows environment true or false

Which of the following procedure inserts terminating character when writing to a text file?

What is the name of the variable that is used to set the directories in the database initialization file

What is the default value of the variable max_linesize in the function FOPEN?

Logging for any SQL on a RAC env what information must pass to log module for proper identification of the source of the log ?

Pick which all comments should all code adequately document ?

Which are appropriate scheduling tools for use in EIP database?

What can be used to optimize the performance of simple SQL?

COMPLETE REFRESH by default will _________________all rows in an mview before inserting new rows

On a partitioned table which index is used mostly

Indexes and statistics are built ________________ the exchange of the exchange table ?

If the value in a column is not unique then which index is used ?

Which object in PL/SQL provides encapsulation features ?

When we should truncate the working table ?

If you need remove code from a script, including PL/SQL, what you will do?

while making query in a partitioned table which one we should use .

I/O operations on the data warehouse is expensive ?

SYS_CONTEXT can be used to know details about a session running the code?