[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-146 Dumps with VCE and PDF 61-70
Oracle 11g: Advanced PL/SQL
Question No: 61 – (Topic 0)
In which two situations is the body of a result-cached function executed? (Choose two.)
if the memory allocated for the result cache is increased
if a session on this database instance invokes the function with the same parameter values
if the first time a session on this database instance invokes the function with a parameter value
if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function
Question No: 62 – (Topic 0)
Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables.
the trace file component
the analyzer component
the shared library component
the data collection component
Question No: 63 – (Topic 0)
Examine the code snippet from the declarative section of a PL/SQL block:
TYPE va1 IS VARRAY(10) OF VARCHAR2(20); SUBTYPE scale IS NUMBER(1,0);
TYPE tb1 IS TABLE OF departments.department_name%TYPE INDEX BY departments.department_id%TYPE;
TYPE tb2 IS TABLE OF va1 INDEX BY PLS_INTEGER; TYPE tb3 IS TABLE OF scale INDEX BY VARCHAR2(10); TYPE tb4 IS TABLE OF DATE INDEX BY DATE;
TYPE tb5 IS TABLE OF NUMBER INDEX BY CHAR(2);
Which of the above are valid definitions for associative arrays? (Choose all that apply.)
Question No: 64 – (Topic 0)
Examine the structure of the TEST_DETAILS table: Name Null? Type
———- —- ——- TEST_ID NUMBER
DESCRIPTION data was entered earlier and saved for TEST_ID 12.
You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION column for TEST_ID 12:
clob_loc CLOB; buf CHAR(12); BEGIN
SELECT description INTO clob_loc FROM test_details WHERE test_id = 12 ; buf := #39;0123456789#39;; DBMS_LOB.WRITEAPPEND(clob_loc,DBMS_LOB.GETLENGTH(buf), buf); COMMIT;
It generates an error on execution.
What correction should you do to achieve the required result?
WRITEAPPEND must be replaced with APPEND.
The BUF variable data type must be changed to CLOB.
FOR UPDATE must be added to the SELECT statement.
The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND.
Question No: 65 – (Topic 0)
Which two statements correctly describe the features of SecureFiles? (Choose two.)
Compression is performed only on the server side and enables random reads and writes to LOB data.
Deduplication stores identical data, which occurs in a LOB column in each row, as a single copy within the LOB.
Compression can be performed on the client side and it enables random and sequential reads and writes to LOB data.
Deduplication stores identical data occurring two or more times in the same LOB column as a single copy for the table.
Question No: 66 – (Topic 0)
You issue the following command to create the PRINT_MEDIA table.
CREATE TABLE print_media (product_id NUMBER(3), ad_sourcetext CLOB, ad_photo BLOB);
Evaluate the following INSERT statements:
INSERT INTO print_media VALUES (1, empty_clob(),empty_blob()); INSERT INTO print_media VALUES (2,#39;This is a One Line Story#39;,null);
INSERT INTO print_media VALUES (3,#39;This is another One Line Story#39;,empty_blob()); INSERT INTO print_media VALUES (4,empty_clob(),to_blob(#39;This is new Story#39;));
Which of the above INSERT statements are valid?
Only the first statement is valid.
All the statements are valid.
Only the first and fourth statements are valid.
Only the first and second statements are valid.
Only the first, second and third statements are valid.
Question No: 67 – (Topic 0)
Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)
Only local subroutines can be inlined.
Inlining always reduces the execution time for a PL/SQL program unit.
PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.
The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining.
Question No: 68 – (Topic 0)
View Exhibit1 and examine the structure of the EMPLOYEES table. View Exhibit2 and examine the code in the PL/SQL block.
The PL/SQL block fails to execute. What could be the reason?
Nested tables cannot be returned by a function.
The NEWNAMES nested table has not been initialized.
The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2.
The third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they are of inconsistent data types.
LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements.
Topic 1, B
Question No: 69 – (Topic 1)
Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
You can describe remote objects.
You can describe anonymous PL/SQL blocks.
You can describe a stored procedure, stored function, packaged procedure, or packaged function.
You can obtain information about the position, name, and data type of the arguments of a procedure.
Question No: 70 – (Topic 1)
You executed the following command to alter the session parameter:
SQLgt; ALTER SESSION SET PLSCOPE_SETTINGS = #39;IDENTIFIERS:ALL#39;;
Which two statements are true in this scenario? (Choose two.)
If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.
All the identifiers declared in compiled program units before altering the parameter settings appear in the *_IDENTIFIER static data dictionary views.
All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.
If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects data for the compiled object and stores it in the SYSTEM tablespace.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|