1Z0-144 무료 덤프문제 온라인 액세스

Examine the following snippet of PL/SQL code:

View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has
200 rows.

Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as 'ST_CLERK' and salary greater than 3000.

• A.OPEN c1 (3000, emp_salary);
• B.OPEN c1 (emp_job, 3000);
• C.OPEN c1 ('ST_CLERK', 3000)
• D.OPEN c1 (NULL, 3000);
• E.OPEN c1 (EMP_job, emp_salary);

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

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

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

• A.A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
• B.A function can return multiple values using a single return clause,
• C.A function can contain zero or more parameters that are transferred from the calling environment.
• D.A procedure can contain a return statement without a value.

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

• A.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.
• B.Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
• C.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.
• D.Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.

Identify two features of obfuscation. (Choose two.)

• A.Only the wrap utility can obfuscate multiple programs at a time.
• B.The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
• C.Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
• D.SQL' Plus cannot process the obfuscated source files.
• E.The Import and Export utilities accept wrapped files.