1Z0-149Preview

Which three are true about PL/SQL subprograms? (Choose three.)

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?

Which three are true regarding code based access control (CBAC)? (Choose three.)

Which two blocks of code display a numerical zero? (Choose two.)

Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

Examine these statements which execute successfully:

Which anonymous block executes successfully?

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

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

Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

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

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

Examine these statements from a block of code:

Which two are true? (Choose two.)

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

Which three are true about functions and procedures? (Choose three.)

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

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

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

Which statement is true about user-defined records?

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?

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

SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

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