Online Access Free 1Z0-149 Practice Test

Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

• A.This will not compile successfully because the min_bal constant must be initialized.
• B.Initialization of loan_amount can be done while using this packaged variable in another program.
• C.This program unit will compile successfully.
• D.This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
• E.Initialization of min_bal can be done while using this packaged constant in another program.
• F.This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
• G.This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.

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.DEP_VU must be manually recompiled to successfully run this code.
• B.It will result in an error because table depts has been altered.
• C.It will run successfully producing a result of 5.
• D.It will run successfully producing a result of 4.

Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

• A.In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
• B.In line 2, add the default parameter DEFAULT 2000.
• C.In line 1, change IN OUT mode to IN mode.
• D.In line 1, add the default parameter DEFAULT 2000.
• E.In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
• F.In line 2, change IN OUT mode to IN mode.

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

• A.Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
• B.Internally defined exceptions can be handled only by the OTHERS exception handler.
• C.Predefined exceptions are globally declared in the standard package.
• D.All declared exceptions are raised implicitly by the runtime system.
• E.User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

Which is true about counter variables in a FOR loop?

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