Oracle Oracle Certifications 1Z0-148 Questions & Answers

• Question 231:

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

  Examine the following PL/SQL block for storing the salary of all sales representatives from the

  EMPLOYEES table in an associative array:

  1 DECLARE

  2 emp_cv SYS_REFCURSOR;

  3 TYPE list IS TABLE OF emp_cv;

  4 sals list;

  5 BEGIN

  6 OPEN emp_cv FOR SELECT salary FROM employees

  7 WHERE job_id = 'SA_REP';

  8 FETCH emp_cv BULK COLLECT INTO sals;

  9 CLOSE emp_cv;

  10 END;

  What should you correct in the above code to ensure that it executes successfully?

  

  A. Replace EMP_CV in line 3 with employees.salary%TYPE.

  B. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.

  C. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.

  D. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.

  Correct Answer: A

• Question 232:

  Which two statements are true about the query results stored in the query result cache? (Choose two.)

  A. If any of the tables used to build a query is modified by an ongoing transaction in the current session, the query result is not cached.

  B. A query result based on a read-consistent snapshot of data that is older than the latest committed version of the data is not cached.

  C. Adding the RESULT_CACHE hint to inline views enables optimizations between the outer query and the inline view, and the query result is cached.

  D. A query result for a query that has a bind variable is stored in the cache and is reused if the query is equivalent even when the bind variable has a different value.

  Correct Answer: AB

• Question 233:

  Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)

  A. It can be performed only on tables with a single LOB column.

  B. It automatically creates an interim table during the migration process.

  C. It allows the table that is migrated to be accessed throughout the migration process.

  D. It requires free space that is at least equal to the space used by the table that is migrated.

  E. It requires all constraints defined on the original table to be re-created manually after the migration.

  Correct Answer: CD

• Question 234:

  Which statements are true about the SecureFile storage paradigm? (Choose two.)

  A. SecureFile storage can be used for internal and external LOBs.

  B. Automatic Segment Space Management must be enabled for a tablespace to store SecureFile LOBs.

  C. SecureFile options enabled for a LOB column can be overridden on a per-LOB basis within the column.

  D. SecureFile is the default storage paradigm for all LOBs that are stored in locally managed tablespaces if the DB_SECUREFILE parameter is set to ALWAYS.

  Correct Answer: BC

• Question 235:

  In which two situations is the body of a result-cached function executed? (Choose two.)

  A. if the memory allocated for the result cache is increased

  B. if a session on this database instance invokes the function with the same parameter values

  C. if the first time a session on this database instance invokes the function with a parameter value

  D. if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function

  Correct Answer: CD

• Question 236:

  View Exhibit1 and examine the structure of the EMPLOYEES table.

  View Exhibit2 and examine the code in the PL/SQL block.

  The PL/SQL block fails to execute.

  What could be the reason?

  

  A. Nested tables cannot be returned by a function.

  B. The NEWNAMES nested table has not been initialized.

  C. The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2.

  D. The third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they are of inconsistent data types.

  E. LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements.

  Correct Answer: E

• Question 237:

  You created the SALES_ORDERS_CTX context to use the OE.SALES_ORDERS_PKG package.

  View Exhibit1 and examine the package that is used with the context.

  View Exhibit2 to examine the policy defined and the logon trigger.

  A user receives the following error when he or she executes a query:

  ERROR at line 2:

  ORA-28112: failed to execute policy function

  What could be the reason for the error?

  

  

  A. The user has insufficient privileges on the DBMS_SESSION package.

  B. The subprograms inside the package have not been created with the invoker's right.

  C. The THE_PREDICATE function has an insufficient number of parameters in the package.

  D. The policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter.

  Correct Answer: C

• Question 238:

  Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)

  A. You can describe remote objects.

  B. You can describe anonymous PL/SQL blocks.

  C. You can describe a stored procedure, stored function, packaged procedure, or packaged function.

  D. You can obtain information about the position, name, and data type of the arguments of a procedure.

  Correct Answer: CD

• Question 239:

  When do you use static SQL as a technique for avoiding SQL injection?

  A. when the WHERE clause values are unknown

  B. when the code contains data definition language (DDL) statements

  C. when all Oracle identifiers are known at the time of code compilation

  D. when the SET clause values are unknown at the time of code compilation

  Correct Answer: C

• Question 240:

  Identify the two types of PL/SQL programs for which you consider setting the compilation method to native mode. (Choose two.)

  A. PL/SQL programs that are still in the debugging phase of development

  B. PL/SQL programs that have computation-intensive procedural operations

  C. A PL/SQL program, which is called with the same parameters by multiple sessions

  D. PL/SQL programs that spend most of their execution time in executing SQL statements

  Correct Answer: BC