2023 1Z0-149 Dumps PDF – 1Z0-149 Real Exam Questions Answers [Q28-Q44]

QUESTION 28
Which two are true about INDEX-BY tables? (Choose two.)

QUESTION 29
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

QUESTION 30
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.)

QUESTION 31
Examine this code:
ALTER SESSION SET plsql_warnings=’ENABLE:ALL’;
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to ‘ENABLE: ALL’?

QUESTION 32
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

QUESTION 33
Examine this code:

What will be the outcome?

QUESTION 34
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

QUESTION 35
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

QUESTION 36
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.)

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

QUESTION 38
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?

QUESTION 39
Which two are true about lexical units? (Choose two.)

QUESTION 40
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?

QUESTION 41
Examine these statements from a block of code:

Which two are true? (Choose two.)

QUESTION 42
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

QUESTION 43
Which three are true about anonymous blocks and subprograms? (Choose three.)

QUESTION 44
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?