Online Access Free 1Z0-144 Practice Test

Which two statements are correct about PL/SQL package components? (Choose two)

• A.A package specification can exist without the package body.
• B.A package must have both specification and body.
• C.When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.
• D.A package body can exist without the package specification.

View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What is the outcome when the code is executed?

• A.Both blocks compile and execute successfully when called.
• B.The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.
• C.Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.
• D.The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.

View the Exhibit and examine the structure of the customer table.
You need to create a trigger to ensure that customers in category "A" and "B" have a credit
limit of more than 8000.
Examine the following trigger.

Which statement is correct about the outcome of this trigger?

• A.It compiles successfully but does not fire even when the condition is met
• B.It compiles successfully and fires whenever the specified condition is met.
• C.It gives an error on compilation because the new qualifier is prefixed with a colon.
• D.It gives an error on compilation because the new qualifier can be used only in row-level triggers.

In which of the following scenarios would you recommend using associative arrays?

• A.When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
• B.When you want to retrieve an entire row from a table and perform calculations
• C.When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.
• D.When you know the number of elements in advance and the elements are usually accessed sequentially

Which statements are true about database triggers? (Choose all that apply.)

• A.They can invoke only PL/SQL procedures
• B.They are implicitly fired when a triggering event occurs, depending on which user is connected
• C.They are implicitly fired by an event that must occur within an application
• D.They can include SQL and PL/SQL or calls to Java procedures.