Online Access Free 1Z0-149 Practice Test

Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

• A.The RETURNING INTO clause and bulk binds may not be used together.
• B.The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
• C.When using the RETURNING INTO clause, the data returned can be only single column or expression.
• D.The RETURNING INTO clause returns column values for rows affected by DML statements.
• E.The RETURNING clause can be used for remote or parallel deletes.

Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

• A.In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
• B.In line 1, add the default parameter DEFAULT 2000.
• C.In line 2, change IN OUT mode to IN mode.
• D.In line 2, add the default parameter DEFAULT 2000.
• E.In line 1, change IN OUT mode to IN mode.
• F.In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.

Which two are true about collections and RECORD types? (Choose two.)

• A.All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
• B.VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
• C.All collections and RECORD types can be stored in table columns.
• D.Only associative arrays and nested tables can have elements of RECORD type.
• E.A variable of RECORD type can contain fields of another RECORD type or any collection type.
• F.Collections and RECORD types are always dense.

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

• A.It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
• B.It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
• C.It will fail at lines 6 and 7.
• D.It will fail only at line 7.

Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

• A.It executes successfully.
• B.It results in an error because Authid Definer is missing from MYPROC.
• C.It results in an error because USERB doesn't have select privilege on USERA.EMP.
• D.It results in an error because Authid Current_User is missing from MYPROC.