Get real exam questions for 1Z0-146 Oracle 11g: Advanced PL/SQL. 100% Free.
Q1. DATA_FILES is a directory object that contains the DETAILS.TXT text file. You have the required permissions to access the directory object. You create a table using the following command: CREATE TABLE clob_tab(col2 CLOB); View the Exhibit and examine the PL/SQL block that you execute for loading the external text file into the table that currently has no rows. The PL/SQL block results in
Q1. Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB? (Choose two.) A. It can be used for transforming data in permanent internal LOBs. B. It is used only for the migration of BasicFile to the SecureFile format. C. It is used only for the migration of the LONG column to the LOB column. D. It creates a LOB variable that is not as
Q1. Examine the structure of the PRODUCTS table. Name Null? Type PRODUCT_ID NOT NULL NUMBER(6) PRODUCT_NAME VARCHAR2(50) CATEGORY_ID NUMBER(2) SUPPLIER_ID NUMBER(6) LIST_PRICE NUMBER(8,2) View the Exhibit and examine the PL/SQL block. On execution, the PL/SQL block generates the following error: ORA-01001: invalid cursor What could be the reason? A. Both the cursor variable arguments sh