databases Online Quiz - 71
|Description: databases Online Quiz - 71|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
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?