1Z0-144 試験問題を無料オンラインアクセス

In which of the following scenarios would you recommend using PL/SQL records?

• A.when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked
• B.when you know the number of elements in advance and the elements are usually accessed sequentially
• C.when you want to retrieve an entire row from a table and perform calculations
• D.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

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

View the Exhibit and examine the structure of the EMP table.

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)

• A.The formal parameters of each subprogram should differ in data type but can use the same names.
• B.The procedures can be either stand-alone or packaged.
• C.Each subprogram's formal parameters should differ in both name and data type.
• D.The procedures should be created only as stand-alone subprograms
• E.The procedures should be created only as packaged subprograms

View the Exhibit to examine the PIVSQL block.

Which statement is true about the output of the PL/SQL block?

• A.It executes and the Output is emprec.deptname: Sales.
• B.It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.
• C.It produces an error because NULL is assigned to the emprec.empid field in the record.
• D.It executes and the Output is emprec.deptname: .

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

• A.When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.
• B.When you know the number of elements in advance and the elements are usually accessed sequentially
• C.When you want to retrieve an entire row from a table and perform calculations
• D.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