Free Oracle 1Z0-146 Exam Dumps Questions & Answers

To examine the dependencies between all PL/SQL objects and the tables and views they
reference, you executed the following query as the user OE:
SQL> SELECT owner || '.' || NAME refs_table
, referenced_owner || '.' || referenced_name AS table_referenced
FROM all_dependencies
WHERE owner = USER
AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION')
AND referenced_type IN ('TABLE', 'VIEW')
AND referenced_owner NOT IN ('SYS', 'SYSTEM')
ORDER BY owner, NAME, referenced_owner, referenced_name;
Which statement is true about the output of the query?

• A.It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..
• B.It displays no rows because this query needs to be executed as the user SYS for required results.
• C.It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.
• D.It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.

You have an external C procedure stored in a dynamic-link library (DLL).
The C procedure takes an integer as argument and returns an integer. You want to invoke the C
procedure through a PL/SQL program.
View the Exhibit.

Which statement is true about the C_OUTPUT PL/SQL program?

• A.It fails because the input data type is BINARY_INTEGER and the external C procedure expects an integer.
• B.It invokes the external C procedure.
• C.It fails because the external C procedure is not published.
• D.It only publishes the external C procedure.

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 an error.

What correction must be done to ensure the PL/SQL block executes successfully?

• A.The A_CLOB variable has to be declared as a temporary LOB.
• B.The L_OUT variable has to be declared as a temporary LOB.
• C.The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator.
• D.The L_OUT variable must be initialized to an empty locator.

Which two statements correctly describe the features of SecureFiles? (Choose two.)

• A.Compression does not entail table or index compression and vice-versa.
• B.Encryption stores the encryption keys for the LOB columns outside the database.
• C.Compression stores identical data occurring two or more times in the same LOB column as a single copy for the table.
• D.Encryption stores the encryption keys for the LOB columns inside the database.

View the Exhibit and examine the PL/SQL code.

Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply.)

• A.Define and compile procedures independently, and not as part of a package.
• B.Avoid the NOT NULL constraint when declaring the variable.
• C.Remove redundant SQL statements in the procedures.
• D.Use cursors to fetch values.