Oracle 1Z0-148 Online Practice Questions and Exam Preparation

Oracle 1Z0-148 Online Questions & Answers

• Question 81:

  You create this package and procedure:

  

  Which two blocks will execute without errors? (Choose two.)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  B. Option B
  E. Option E

• Question 82:

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

• Question 83:

  You execute this PL/SQL block:

  

  What will be the outcome?

  A. It will fail compile because of errors at lines 11 and 12.
  B. It will fail compile because of errors at lines 6 and 12.
  C. It will fail compile because of error at line 7.
  D. It will fail compile and execute successfully.
  E. It will fail compile because of errors at lines 5 and 6.
  B. It will fail compile because of errors at lines 6 and 12.

• Question 84:

  Which two are major approaches that can be used to reduce the SQL injection by limiting user input? (Choose two.)

  A. Restrict users accessing specified web page.
  B. Use NUMBER data type if only positive integers are needed.
  C. Use dynamic SQL and construct it through concatenation of input values.
  D. In PL/SQL API, expose only those routines that are intended for customer use.
  A. Restrict users accessing specified web page.
  D. In PL/SQL API, expose only those routines that are intended for customer use.

• Question 85:

  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.
  A. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.
  C. All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.

• Question 86:

  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.
  C. Verify qualified SQL names.
  E. Verify an existing schema name.
  F. Enclose string literals within double quotation marks.

• Question 87:

  In a user session, tracing is enabled as follows:

  SQL> EXECUTE

  DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES);

  PL/SQL procedure successfully completed.

  You executed the procedure as follows:

  SQL> EXECUTE PROC10

  PL/SQL procedure successfully completed.

  When you examine the PLSQL_TRACE_EVENTS table, you find that no trace information was written into it.

  View the Exhibit.

  What is the reason for this?

  

  A. The PROC10 procedure is created with the invoker's right.
  B. The PROC10 procedure is not compiled with the DEBUG option.
  C. Tracing is not enabled with the TRACE_ENABLED_CALLS option.
  D. The TRACE_ENABLED parameter is set to FALSE for the session.
  B. The PROC10 procedure is not compiled with the DEBUG option.

• Question 88:

  You issue this command to create a table called LOB_STORE:

  CREATE TABLE lob_store

  (lob_id NUMBER(3),

  photo BLOB DEFAULT EMPTY_BLOB(),

  cv CLOB DEFAULT NULL,

  ext_file BFILE DEFAULT NULL)

  /

  What is the outcome?

  A. The table is created successfully.
  B. It generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table creation.
  C. It generates an error because DEFAULT cannot be set to null for a CLOB column during table creation.
  D. It generates an error because DEFAULT cannot be set to null for a BFILE column during table creation.
  A. The table is created successfully.

• Question 89:

  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.
  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.

• Question 90:

  Examine the section of code taken from a PL/SQL program:

  PROCEDURE p1 (x PLS_INTEGER) IS

  ... ...

  PRAGMA INLINE (p1, 'NO');

  x:= p1(1) + p1(2) + 17; -- Call 1

  ...

  x:= p1(3) + p1(4) + 17; -- Call 2

  Call 1 and Call 2 are the comments for distinguishing the code. The PLSQL_OPTIMIZE_LEVEL parameter is set to 3. Which two statements are true in this scenario? (Choose two.)

  A. The calls to the P1 procedure are not inlined in the section commented as Call 1.
  B. The calls to the P1 procedure might be inlined in the section commented as Call 2.
  C. The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.
  D. The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2.
  A. The calls to the P1 procedure are not inlined in the section commented as Call 1.
  B. The calls to the P1 procedure might be inlined in the section commented as Call 2.