Online Access Free 1Z0-149 Practice Test

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

• A.
• B.
• C.
• D.

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?

• A.It will run successfully producing a result of 5.
• B.DEP_VU must be manually recompiled to successfully run this code.
• C.It will run successfully producing a result of 4.
• D.It will result in an error because table depts has been altered.

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

• A.Object privileges to execute a replaced function must be regranted to those users who had the privilege.
• B.This clause can be used only for procedures and functions.
• C.Object privileges to execute a replaced function are retained by those users who had the privileges.
• D.A function definition can be modified without dropping and re-creating it.
• E.Function based indexes remain usable when replacing the function on which the index depends.

Which is true about EXIT and CONTINUE statements?

• A.They must use labels.
• B.They can be used in any type of loop.
• C.They must have a WHEN condition.
• D.They have the same effect on the execution of a loop.

Which is true about counter variables in a FOR loop?

• A.It must explicitly be declared.
• B.It cannot be NULL.
• C.It is accessible outside the body of the loop.
• D.It can be modified in the body of the loop.