Oracle Oracle Certifications 1Z0-148 Questions & Answers

• Question 111:

  Which two statements are true about BFILES? (Choose two.)

  A. BFILES support only sequential reads.

  B. BFILES can be used as attributes in an object type.

  C. When LOB is deleted, the corresponding physical file is automatically deleted.

  D. The RMAN backup automatically backs up the BFILE locators and the corresponding physical files.

  E. The physical file corresponding to a BFILE locator must reside on the file system that is accessible from the server where the database exists.

  Correct Answer: BE

• Question 112:

  Identify two strategies against SQL injection. (Choose two.)

  A. Using parameterized queries with bind arguments.

  B. Use subprograms that are run with the definer's right.

  C. Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.

  D. Validate user inputs to functions that use dynamic SQLs built with concatenated values.

  Correct Answer: AD

• Question 113:

  Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)

  A. Detect a wrong user.

  B. Check input string length.

  C. Verify qualified SQL names.

  D. Validate TNS connect strings.

  E. Verify an existing schema name.

  F. Enclose string literals within double quotation marks.

  Correct Answer: CEF

• Question 114:

  You executed the following command to alter the session parameter:

  SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL';

  Which two statements are true in this scenario? (Choose two.)

  A. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.

  B. All the identifiers declared in compiled program units before altering the parameter settings appear in the *_IDENTIFIER static data dictionary views.

  C. All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.

  D. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects data for the compiled object and stores it in the SYSTEM tablespace.

  Correct Answer: AC

• Question 115:

  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 116:

  Which two statements are true about SecureFile LOB options? (Choose two.)

  A. The COMPRESSION HIGH option can be enabled only for CLOBs.

  B. The COMPRESSION HIGH option can be enabled for all internal LOBs.

  C. The DECRYPT option can be used to remove encryption only if the LOB column is empty.

  D. The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data.

  Correct Answer: BD

• Question 117:

  Which guidelines should be considered when designing and using cursors in a PL/SQL block? ? (Choose all that apply.)

  A. When fetching from a cursor, fetch into a record.

  B. Use parameters with cursors so that the result set for the cursor is not tied to a specific variable in a program.

  C. Use the %NOTFOUND attribute in combination with the SELECT INTO statement to check for non existent values.

  D. Whenever possible, explicitly declare the cursor and use the OPEN, FETCH and CLOSE statements to manipulate the cursor instead of using cursor FOR loop.

  E. When using data manipulation language statements, (DML) reference a SQL cursor attribute immediately after the DML statement executes in the same block.

  Correct Answer: ABE

• Question 118:

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

  Examine the following PL/SQL block:

  DECLARE

  TYPE EmpList

  IS VARRAY(2) OF employees.employee_id%TYPE NOT NULL;

  v_employees EmpList := EmpList();

  BEGIN

  DBMS_OUTPUT.PUT_LINE(v_employees.COUNT);

  v_employees.EXTEND;

  v_employees(1) := 30;

  END;

  /

  Which statement is true about the outcome on executing the above PL/SQL block?

  

  A. It executes successfully and displays the value 2.

  B. It executes successfully and displays the value 0.

  C. It generates an error because EXTEND cannot be used for varrays.

  D. It generates an error because the declaration of the varray is not valid.

  Correct Answer: B

• Question 119:

  Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)

  A. DDL report for all objects dependent on a table

  B. DDL report for all the objects stored in a tablespace

  C. DDL report for all the invalidated objects in a schema

  D. data definition language (DDL) report for all the tables in a schema

  Correct Answer: AD

• Question 120:

  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