Online Access Free 1z1-149 Practice Test

Which two are true about implicit data type conversion? (Choose two.)

• A.Implicit data type conversion can negatively impact performance.
• B.Collections can be implicitly converted to records.
• C.Comparison between character value and a number value always implicitly converts the character value to the number data type.
• D.ROWIDS are always implicitly converted to a number when used in a query.
• E.RAW data types are always implicitly converted to a CLOB when used in a query.

In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)

• A.Call HR.API.P1 from the SH schema.
• B.Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
• C.Call HR.HELPER.H1 from the HR schema.
• D.Call HR.API.P1 from the HR schema.
• E.Call HR.HELPER.H1 from the SH schema.

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 Authid Current_User is missing from MYPROC.
• D.It results in an error because USERB doesn't have select privilege on USERA.EMP.

Which is the correct method to implement a local subprogram in an anonymous block?

• A.
• B.
• C.
• D.

Which three statements can process a dynamic multi-row query? (Choose three.)

• A.DECLARE
• B.WHEN
• C.OPEN-FOR
• D.CLOSE
• E.OPEN
• F.FETCH
• G.INTO