Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
A. You can describe remote objects.
B. You can describe anonymous PL/SQL blocks.
C. You can describe a stored procedure, stored function, packaged procedure, or packaged function.
D. You can obtain information about the position, name, and data type of the arguments of a procedure.
Which two statements correctly describe the features of SecureFiles? (Choose two.)
A. Compression is performed only on the server side and enables random reads and writes to LOB data.
B. Deduplication stores identical data, which occurs in a LOB column in each row, as a single copy within the LOB.
C. Compression can be performed on the client side and it enables random and sequential reads and writes to LOB data.
D. Deduplication stores identical data occurring two or more times in the same LOB column as a single copy for the table.
Which two statements are true about cursor variables? (Choose two.)
A. Cursor variables can be parameterized like cursors.
B. The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
C. The FETCH statement executes the query associated with a cursor variable and identifies the result set.
D. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.
E. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
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 L_OUT variable must be initialized to an empty locator.
B. The L_OUT variable has to be declared as a temporary LOB.
C. The A_CLOB variable has to be declared as a temporary LOB.
D. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator.
You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schema. The user sessions are able to access only the desired rows. The database administrator (DBA) uses the following command:
SQL> EXECUTE DBMS_RLS.ENABLE_POLICY('OE','ORDERS','OE_ORDERS_ACCESS_POLICY',FALSE );
Which statement is true about user sessions that are connected currently?
A. The security policy remains in effect till the end of the current session.
B. The subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error.
C. The subsequent queries on the ORDERS table within the current session are not controlled by the security policy.
D. The subsequent queries on the ORDERS table produce an ORA-28112: failed to execute policy function error.
Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 3
Which statement would be true in this scenario?
A. The compiler would automatically inline subprograms.
B. The compiler would inline the code for external subroutines.
C. The compiler would inline the code even if the INLINE pragma is set to NO.
D. The compiler would not inline the code unless the INLINE pragma is set to YES.
Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?
A. ALL_SOURCE
B. ALL_DEPENDENCIES
C. ALL_OBJECTS
D. ALL_PROCEDURES
E. ALL_PLSQL_OBJECT_SETTINGS
Your company decided to update its employees' contact information as a one-time event.
With thousands of employees' records to be updated, the project manager hoped to achieve substantial
performance gains using the DBMS_PARALLEL_EXECUTE package and identified these four actions to
be executed.
1) dbms_parallel_execute.create_task
2) GRANT system privilege CREATE JOB to the user executing this task
3) dbms_parallel_execute.run_task 4) dbms_parallel_execute.create_chunks_by_rowid Select the correct order of actions to implement the parallel execution of PL/SQL blocks.
A. 2, 1, 3 and 4
B. 1, 2, 4 and 3
C. 2, 1, 4 and 3
D. 1, 2, 3 and 4
E. 2, 4, 1 and 3
Examine this code:
You want to display the contents of CREATE_LIST.
Which two lines need to be corrected in the PL/SQL block?
A. Line 2
B. Line 3
C. Line 5
D. Line 6
E. Line 7
Examine this code: What will be the outcome with SERVEROUTPUT enabled?
A. The PL/SQL block will fail with a runtime exception.
B. LENGTH : 100.13 EXTRA_LEN : 15.25 TOTAL LENGTH : 115.38
C. LENGTH : 100.1254 EXTRA_LEN : 15.247 TOTAL LENGTH : 115.37
D. LENGTH : 100.1254 EXTRA_LEN : 15.25 TOTAL LENGTH : 115.38
E. LENGTH : 100.1254 EXTRA_LEN : 15.25 TOTAL LENGTH : 115.3754
