Oracle 1Z0-148 Online Practice Questions and Exam Preparation

Oracle 1Z0-148 Online Questions & Answers

• Question 141:

  View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure. Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)

  

  A. Explicitly validate the identifier length limit.
  B. Add AUTHID DEFINER to the definition of the procedure.
  C. Use PRAGMA RESTRICT_REFERENCES in the procedure.
  D. Filter out control characters in user-supplied identifier names.
  E. Use the object ID of the table from the data dictionary to build the trigger name.
  A. Explicitly validate the identifier length limit.
  D. Filter out control characters in user-supplied identifier names.
  E. Use the object ID of the table from the data dictionary to build the trigger name.

• Question 142:

  Examine this code:

  CREATE TYPE list_typ IS TABLE OF NUMBER;

  /

  DECLARE

  l_list list_typ := list_typ ();

  Which two executable sections will display the message TRUE?

  A. BEGIN IF l_list.LIMIT IS NOT NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
  B. BEGIN l_list.EXTEND; IF l_list.PRIOR (1_list.FIRST) IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
  C. BEGIN l_list.EXTEND; IF l_list IS EMPTY THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
  D. BEGIN IF l_list.FIRST IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
  E. BEGIN IF l_list.FIRST =1 THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
  B. BEGIN l_list.EXTEND; IF l_list.PRIOR (1_list.FIRST) IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
  D. BEGIN IF l_list.FIRST IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;

• Question 143:

  Examine this Java method in class Employee, loaded into the Oracle database:

  Public static int updateSalary (String name, float salary) {...}

  Which PL/SQL specification can be used to publish this method?

  A. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA LIBRARY “Employee” NAME “updateSalary” PARAMETERS (p_nm java.lang. String, p_sal float, RETURN int);
  B. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME “Employee.updateSalary” PARAMETERS (p_nm java.lang.String, p_sal float, RETURN int);
  C. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME “Employee.updateSalary” PARAMETERS (“name” java.lang.String, “salary” float, RETURN int);
  D. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME ‘Employee.updateSalary (java.lang.String, float) return int’;
  E. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME ‘int Employee.updateSalary (java.lang.String, float)’;
  D. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME ‘Employee.updateSalary (java.lang.String, float) return int’;

• Question 144:

  Which data dictionary view includes information about the parameters of procedures and functions that you can call?

  A. ALL_PROCEDURES
  B. ALL_PACKAGES
  C. ALL_ARGUMENTS
  D. ALL_OBJECTS
  D. ALL_OBJECTS

  ---

  Reference: https://blogs.oracle.com/oraclemagazine/the-data-dictionary-make-views-work-for-you

• Question 145:

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

  A. The DECRYPT option can be used to remove the encryption only if the LOB column is empty.
  B. The KEEP_DUPLICATES option removes the deduplication effect only on new data in a LOB column.
  C. The KEEP_DUPLICATES option removes the deduplication effect on existing and new data in a LOB column.
  D. The DECRYPT option can be used to remove the encryption from LOB columns that are empty or contain data.
  C. The KEEP_DUPLICATES option removes the deduplication effect on existing and new data in a LOB column.
  D. The DECRYPT option can be used to remove the encryption from LOB columns that are empty or contain data.

• Question 146:

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

• Question 147:

  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.
  B. BFILES can be used as attributes in an object type.
  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.

• Question 148:

  Identify the two correct scenarios where a function can be optimized using the function result cache feature.

  A. A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
  B. A function which accesses multiple tables and calculates the commission to be given to a sales representative based on the number of products sold by that representative.
  C. A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.
  D. A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
  E. A function which calculates the factorial of a given number without accessing any table.
  D. A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
  E. A function which calculates the factorial of a given number without accessing any table.

• Question 149:

  Which two blocks of code execute successfully?

  A. DECLARESUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;my_val new_one;BEGINmy_val :=0;END;
  B. DECLARESUBTYPE new_string IS VARCHAR2 (5) NOT NULL;my_str_new_string;BEGINmy_str := `abc';END;
  C. DECLARESUBTYPE new_one IS NUMBER (2, 1);my_val new_one;BEGINmy_val :=12.5;END;
  D. DECLARESUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;my_val new_one;BEGINmy_val :=2;END;
  E. DECLARESUBTYPE new_one IS NUMBER (1, 0);my_val new_one;BEGINmy_val := -1;END;
  A. DECLARESUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;my_val new_one;BEGINmy_val :=0;END;
  D. DECLARESUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;my_val new_one;BEGINmy_val :=2;END;

• Question 150:

  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;.
  A. Replace EMP_CV in line 3 with employees.salary%TYPE.