Oracle 1Z0-148 Online Practice Questions and Exam Preparation

Oracle 1Z0-148 Online Questions & Answers

• Question 101:

  With SERVEROUTPUT enabled, you successfully create the package YEARLY_LIST:

  

  Examine this code:

  

  You want to display the contents of CREATE_LIST.

  Which two lines need to be corrected in the PL/SQL block? (Choose two.)

  A. Line 6
  B. Line 5
  C. Line 7
  D. Line 2
  E. Line 3
  C. Line 7
  E. Line 3

• Question 102:

  Examine the structure of the DEPARTMENTS table. Name Null? Type

  DEPARTMENT_ID NOT NULL NUMBER(4)

  DEPARTMENT_NAME NOT NULL VARCHAR2(30)

  LOCATION_ID NUMBER(4)

  View the Exhibit and examine the code that you plan to use for creating a package to obtain the details of an employee using a host variable on the client side.

  In SQL*Plus, you plan to use the following commands:

  SQL> VARIABLE x REFCURSOR

  SQL> EXECUTE emp_data.get_emp(195,:x)

  SQL> PRINT x

  Which statement is true about the above scenario?

  

  A. The package executes successfully and passes the required data to the host variable.
  B. The package specification gives an error on compilation because cursor variable types cannot be defined in the specification.
  C. The package specification gives an error on compilation because the cursor variable parameter was specified before you defined it.
  D. The package executes successfully, but does not pass the required data to the host variable because the cursor is closed before the PRINT statement runs.
  D. The package executes successfully, but does not pass the required data to the host variable because the cursor is closed before the PRINT statement runs.

• Question 103:

  Which two statements are correct for collecting data about identifiers in PL/SQL source code?

  A. CREATE < function/Procedure> PLSCOPE_SETTINGS = `IDENTIFIERS: ALL' AS ...
  B. ALTER SYSTEM SET PLSCOPE_SETTINGS = `IDENTIFIERS: NONE'
  C. ALTER SESSION SET PLSCOPE_SETTINGS = `IDENTIFIERS: NONE'
  D. ALTER SESSION SET PLSCOPE_SETTINGS = `IDENTIFIERS: ALL'
  E. ALTER COMPILE PLSCOPE_SETTINGS = `IDENTIFIERS: ALL'
  D. ALTER SESSION SET PLSCOPE_SETTINGS = `IDENTIFIERS: ALL'
  E. ALTER COMPILE PLSCOPE_SETTINGS = `IDENTIFIERS: ALL'

• Question 104:

  The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter.

  Examine the following initialization parameter settings for your database:

  MEMORY_TARGET = 500M

  RESULT_CACHE_MODE = MANUAL

  You execute a query by using the result_cache hint. Which statement is true in this scenario?

  A. The query results are not stored because no memory is allocated for the result cache.
  B. The query results are stored and 0.5% of the memory target is allocated to the result cache.
  C. The query results are stored and 0.25% of the memory target is allocated to the result cache.
  D. The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE.
  C. The query results are stored and 0.25% of the memory target is allocated to the result cache.

• Question 105:

  Examine this declaration section: Which two executable sections will display the message `Summary is null'?

  

  A. BEGIN 1_rec := NULL; 1_emp := emp_typ (1_rec); IF 1_emp (1).expr_summary IS EMPTY THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
  B. BEGIN 1_rec.emp_id :=1; 1_rec.expr_summary := NULL; 1_emp :=emp_typ (1_rec); IF 1_emp(1).expr_summary IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
  C. BEGIN 1_rec.emp_id :=1; 1_rec.expr_summary := EMPTY_CLOB (); 1_emp := emp_typ (1_rec); IF 1_emp(1).expr_summary IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
  D. BEGIN 1_emp := emp_typ (); IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
  E. BEGIN 1_emp. EXTEND; IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
  D. BEGIN 1_emp := emp_typ (); IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;
  E. BEGIN 1_emp. EXTEND; IF NOT 1_emp. EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE (‘Summary is null’); END IF; END;

• Question 106:

  Which two statements are true about the extproc process? (Choose two.)

  A. It loads the dynamic library.
  B. It is started by the server process.
  C. It converts the C output back to PL/SQL.
  D. A single extproc process serves all user sessions.
  A. It loads the dynamic library.
  C. It converts the C output back to PL/SQL.

• Question 107:

  

  Examine this code:

  

  You want to display the contents of CREATE_LIST.

  Which two lines need to be corrected in the PL/SQL block?

  A. Line 2
  B. Line 3
  C. Line 5
  D. Line 6
  E. Line 7
  A. Line 2
  E. Line 7

• Question 108:

  The result cache is enabled for the database instance.

  Examine the following code for a PL/SQL function:

  CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN

  VARCHAR

  RESULT_CACHE RELIES_ON (HR.EMPLOYEES)

  IS

  date_hired DATE;

  BEGIN

  SELECT hire_date INTO date_hired

  FROM HR.EMPLOYEES

  WHERE EMPLOYEE_ID = emp_id;

  RETURN TO_CHAR(date_hired);

  END;

  Which statement is true in this scenario?

  A. If sessions have different NLS_DATE_FORMAT settings, cached results have different formats.
  B. The function results are not cached because the query used in the function returns the DATE data type.
  C. If sessions have different NLS_DATE_FORMAT settings, cached results have same formats because the function's return type is VARCHAR.
  D. If a function is executed with same argument value but different NLS_DATE_FORMAT for the session, the cached result is overwritten with the new function result.
  A. If sessions have different NLS_DATE_FORMAT settings, cached results have different formats.

• Question 109:

  Which two statements are true about nested tables and varrays? (Choose two.)

  A. Only varrays must have consecutive numbers as subscripts.
  B. Only nested tables can be used as column types in database tables.
  C. Both nested tables and varrays must have consecutive numbers as subscripts.
  D. Both nested tables and varrays can be used as column types in database tables.
  A. Only varrays must have consecutive numbers as subscripts.
  D. Both nested tables and varrays can be used as column types in database tables.

• Question 110:

  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.