Online Access Free 1Z0-144 Exam Questions

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)

• A.When privileges need to be granted to a new user to access an existing schema at run time
• B.When a query returns multiple rows
• C.When a table needs to be created based on an existing table structure at run time
• D.When a column name in a where clause is unknown at compile time.
• E.When the number of columns selected in a query is not known until run time

Examine the following block of code:

Which line in the above code would result in errors upon execution?

• A.line 5
• B.line 8
• C.line 2
• D.line 7

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

• A.Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
• B.Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
• C.Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
• D.A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.

View the Exhibit to examine the PL/SQL block.

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

• A.It executes successfully and gives the desired output.
• B.It does not execute because the value that is once assigned to the element of the associative array cannot be changed.
• C.It does not execute because the definition of type population is indexed by VARCHAR2.
• D.It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

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 is prefixed with a colon.
• B.It gives an error on compilation because the new qualifier can be used only in row-level triggers.
• 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.