Free Cram & Latest Exams Dumps

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

QUESTION 15
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

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

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

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

QUESTION 19
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 20
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

QUESTION 21
Which three are true about user-defined functions? (Choose three.)

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

What is true about the result?

QUESTION 23
For which three SYSTEM EVENTS can triggers be created? (Choose three.)

QUESTION 24
Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

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

QUESTION 26
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 27
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?

QUESTION 28
Which two are true about exception handling? (Choose two.)

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

QUESTION 30
Examine these statements:

Which two are true? (Choose two.)

QUESTION 31
Which is true about counter variables in a FOR loop?

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