NO.40 Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

NO.41 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.)

NO.42 Which two are true about lexical units? (Choose two.)

NO.43 In which type of trigger can :OLD and :NEW identifiers be used?

NO.44 User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)

NO.45 For which three SYSTEM EVENTS can triggers be created? (Choose three.)

NO.46 Examine this code:

What will be the outcome?

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

NO.48 Which three are true about the procedure overloading feature? (Choose three.)

NO.49 Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

NO.50 Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

NO.51 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?

NO.52 Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

NO.53 Which three statements are true about passing parameters to subprograms? (Choose three.)

NO.54 Which is true about the PLSCOPE_SETTINGS parameter?

NO.55 Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

NO.56 Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

NO.57 Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

NO.58 Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

NO.59 Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)