1. TCO 3 - In the DBMS_PIPE package, the ____ must be used to start a private pi
ID: 640898 • Letter: 1
Question
1. TCO 3 - In the DBMS_PIPE package, the ____ must be used to start a private pipe. (Points : 1) CREATE_PIPESEND_MESSAGE
PURGE
PACK_MESSAGE Question 2.2. TCO 3 - In UTL_FILE, the FILE_TYPE is a _______________. (Points : 1) Oracle defined data type
identifier for the type of process to be used
a system variable
pointer to a file Question 3.3. TCO 3 - Which of the following is not a new procedure in ULT_FILE. (Points : 1) FREMOVE
FCOPY
FCLOSE
FRENAME Question 4.4. TCO 3 - An exception of INVALID_PATH returned when trying to read a file that is external to the database would indicate which one of the following? (Points : 1) The system is down
The name of the file is incorrect in the FOPEN statement
The Oracle instance is not running
The Oracle database is not open Question 5.5. TCO 3 - The FOPEN function must be passed which three parameters when it is called (be careful of order). (Points : 1) open mode, file location, file name
file location, file type, open mode
file location, file name, open mode
file type, file location, open mode Question 6.6. TCO 3 - Which of the following processes only needs one parameter passed to it? (Points : 1) UTL_FILE.F0PEN
UTL_FILE.GET_LINE
UTL_FILE.FCLOSE
UTL_FILE.PUT_LINE Question 7.7. TCO 3 - If an application needs to write data to an external file, which package would be the most helpful? (Points : 1) UTL_FILE
DBMS_FILE
UTL_OUT
DBMS_WRITE 1. TCO 3 - In the DBMS_PIPE package, the ____ must be used to start a private pipe. (Points : 1) CREATE_PIPE
SEND_MESSAGE
PURGE
PACK_MESSAGE
Explanation / Answer
Hope it may helps you ..
1.CREATE_PIPE
2. a System variable
3.FCOPY
4.The Oracle data base is not open.
5.file location,file name,open mode
6.UTL_FILE.FCLOSE
7.DBMS_WRITE
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.