Online Access Free 1z0-148 Exam Questions

Examine this statement:

Which result is expected after executing this anonymous block?

• A.ORA-06533: Subscript beyond count
• B.60
• C.30
• D.PLS-00382: expression is of wrong type
• E.PLS-00316: PL/SQL TABLEs must use a single index

The STUDENTS table with column LAST_NAME of data type VARCHAR2 exists in your database schema.
Examine this PL/SQL block:

Which two actions must you perform for this PL/SQL block to execute successfully?

• A.Replace the L_NAME_TYPE declaration with TYPE 1_name_type IS VARRAY (25) OF SYS_REFCURSOR;
• B.Add names_varray.EXTEND after the FOR ...LOOP statement.
• C.Replace the FOR loop with FOR name_rec IN names_varray.FIRST .. names_varray.LAST LOOP.
• D.Replace the NAMES_VARRAY declaration with names_varray 1_name_type := 1_name_type ();
• E.Replace the NAMES_VARRAY declaration with names_varray 1_name_type := null;
• F.Add name_rec name_cur%ROWTYPE; at the end of the DECLARE section.

Which statement is true in regard to minimizing attack surface during application design?

• A.Private functions and procedures should be declared in package specifications.
• B.All the code should run anonymously.
• C.Only one user account should be used.
• D.Reusable components should be developed and used extensively.

The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2 and DEPARTMENT_ID of data type NUMBER.
There are six employees in DEPARTMENT_ID, 20. Examine this code:

What will be the outcome on execution?

• A.The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.
• B.The number of employees will be displayed as six for both output messages.
• C.The number of employees will be displayed as six for the first output message and zero for the second output message.
• D.The execution of this code will fail with an invalid cursor error and not display either output message.

Which three statements are true about varrays in a database table column? (Choose three.)

• A.A varray used as a column in a database table must be initialized to null.
• B.The data in a single element of a varray can be changed through either PL/SQL or SQL.
• C.A varray is always stored in the same segment as the table in which it is defined.
• D.A varray used as a column in a database table must be initialized to empty.
• E.A varray may be stored outside the table segment in which it is defined but still in the same tablespace.
• F.A varray's size can be increased beyond the maximum number of elements specified in the definition.
• G.The data in a single element of a varray can only be changed through PL/SQL.
• H.A varray's size can be both increased and decreased from the maximum number of elements specified in the definition.