1Z0-144 Free Questions – Oracle Database 11g: Program with PL/SQL

For passing the Oracle 1Z0-144 exam you must have to take help from valuable 1Z0-144 Free Questions available at Passquestion. The benefits of these 1Z0-144 Free Questions are numerous because they help you in a professional way. I can recommend everyone a site where you can download and read recent study dumps in PDF and software document. Passquestion is providing original questions of Oracle 1Z0-144 exam.

1Z0-144 Free Questions – Oracle Database 11g: Program with PL/SQL

1. Examine the following command:

SQL>ALTER SESSION

SET plsql_warnings *

‘enable: severe’,

‘enable: performance’,

‘ERROR: 05003’;

What is the implication of the above command?

 
 
 
 

2. Which two tasks should be created as functions instead of as procedures? (Choose two.)

 
 
 
 

3. What is the correct definition of the persistent state of a packaged variable?

 
 
 
 

4. Which statements are true about PL/SQL procedures? (Choose all that apply.)

 
 
 
 

5. Identify two situations where the DBMS_SQL package should be used. (Choose two.)

 
 
 
 

6. Which two statements are true about the instead of triggers? (Choose two.)

 
 
 
 

7. Which two statements are correct about the usage of parameters in functions? (Choose two.)

 
 
 
 

8. User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.

SCOTT creates the following trigger:

CREATE OR REPLACE TRIGGER drop_trigger

BEFORE DROP ON hr.SCHEMA

BEGIN

RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object’);

END:

SCOTT does not grant the execute privilege on this trigger to any other users.

For which user(s) would this trigger fire by default when they drop an object in the hr schema?

 
 
 
 

9. Which two statements are true about the continue statement? (Choose two.)

 
 
 
 
 

10. Which two statements are true about statement-level and row-level triggers? (Choose two.)

 
 
 
 

1Z0-1000 Free Questions - Oracle Workforce Compensation Cloud 2018 Implementation Essentials

Leave a Reply

Your email address will not be published. Required fields are marked *