Online Access Free 1z0-148 Exam Questions

Which two statements are correct about the collections before v3. DELETE is executed?

• A.The value of v3 (31) (1) and v3 (33) (3) are identical,
• B.The value of v3 (31) (1) is "hello".
• C.The values of v3(31) (2) and v3 (33) (2) are identical.
• D.The values of v3 (32) (2) and v1 (2) are identical.
• E.The value of v3 (31) (3) is 6.

Which two statements are true about conversion from DBMS_SQL to native dynamic SQL? (Choose two.)

• A.The DBMS_SQL.IS_OPEN function is used to verify that a SQL cursor number is open after it has been converted to a REF CURSOR.
• B.The DBMS_SQL.TO_REFCURSOR function allows a query result to be returned implicitly from a non PL/SQL environment to a stored PL/SQL program.
• C.DBMS_SQL operations can access the cursor only as the SQL cursor number, not as a REF CURSOR variable.
• D.The DBMS_SQL.TO_REFCURSOR function should be used when the number of bind variables is known at compile time, but not the number of items to be selected.
• E.The DBMS_SQL.TO_REFCURSOR function converts a SQL cursor number to a weakly typed cursor variable only after it has been opened, parsed, and executed via DBMS_SQL.

Which is the correct method for releasing unused money after deleting elements of a collection?

• A.Use the TRUNCATE method on the collection.
• B.Execute DBMS_SHARED_POOL.UNKEEP.
• C.Flush the shared pool using the ALTER SYSTEM command.
• D.Execute DBMS_SESSION.FREE_UNUSED_USER_MEMORY.

Select a valid reason for using VARRAYS.

• A.As a column in a table when you want to store no more than 10 elements in each row's collection.
• B.As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.
• C.When the amount of data to be held in the collection is widely variable.
• D.When you want to delete elements from the middle of the collection.

Examine this code:
CREATE TYPE list_typ IS TABLE OF NUMBER;
/
DECLARE
l_list list_typ := list_typ ();
Which two executable sections will display the message TRUE?

• A.BEGINl_list.EXTEND;IF l_list.PRIOR (1_list.FIRST) IS NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• B.BEGINIF l_list.FIRST IS NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• C.BEGINl_list.EXTEND;IF l_list IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• D.BEGINIF l_list.LIMIT IS NOT NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;
• E.BEGINIF l_list.FIRST =1 THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;