Oracle Oracle Certifications 1Z0-148 Questions & Answers

• Question 171:

  There is a Java class file in your system and you publish it using the following command:

  CREATE OR REPLACE PROCEDURE ccformat

  (x IN OUT VARCHAR2)

  AS LANGUAGE JAVA

  NAME 'FormatCreditCardNo.formatCard(java.lang.String[])';

  However, you receive the following error when executing the CCFORMAT procedure:

  ERROR at line 1:

  ORA-29540: class FormatCreditCardNo does not exist

  ORA-06512: at "SH.CCFORMAT", line 1

  ORA-06512: at line 1

  What would you do to execute the procedure successfully?

  A. Change the listener configuration.

  B. Create a directory object and link it to the Java class file.

  C. Rebuild the Java class file when the database instance is running.

  D. Use the loadjava utility to load the Java class file into the database.

  Correct Answer: D

• Question 172:

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

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

  A. Only associative arrays can hold an arbitrary number of elements.

  B. Only nested tables can be used as column types in database tables.

  C. Both associative arrays and nested tables can hold an arbitrary number of elements.

  D. Both associative arrays and nested tables can be used as column types in database tables.

  Correct Answer: BC

• Question 174:

  To examine the dependencies between all PL/SQL objects and the tables and views they reference, you executed the following query as the user OE: SQL> SELECT owner || '.' || NAME refs_table , referenced_owner || '.' || referenced_name AS table_referenced FROM all_dependencies WHERE owner = USER AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION') AND referenced_type IN ('TABLE', 'VIEW') AND referenced_owner NOT IN ('SYS', 'SYSTEM')

  ORDER BY owner, NAME, referenced_owner, referenced_name; Which statement is true about the output of the query?

  A. It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..

  B. It displays no rows because this query needs to be executed as the user SYS for required results.

  C. It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.

  D. It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.

  Correct Answer: A

• Question 175:

  The database instance was started up with the following initialization parameter values:

  MEMORY_TARGET = 500M

  RESULT_CACHE_MODE = FORCE

  RESULT_CACHE_MAX_SIZE = 0

  After the database startup, to enable the result cache, you issued the following command:

  SQL> ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = MEMORY;

  Which is the effect of this command?

  A. The query result cache is enabled and 2 MB of the memory target is allocated to the result cache.

  B. The query result cache is enabled and 0.25% of the memory target is allocated to the result cache.

  C. The command produces an error because the database instance is started up with the RESULT_CACHE_MAX_SIZE parameter set to 0.

  D. The query result cache is not enabled because the database instance is started up with the RESULT_CACHE_MAX_SIZE parameter set to 0.

  Correct Answer: D

• Question 176:

  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.

  Correct Answer: CD

• Question 177:

  Which two statements are true about the initialization of internal LOBs? (Choose two.)

  A. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs.

  B. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non- NULL internal LOBs.

  C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs.

  D. The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB () functions, respectively.

  E. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size.

  Correct Answer: CE

• Question 178:

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

  A. report of invalidated objects in a schema

  B. report of statistics of an object in the database

  C. DDL for all object grants on a table in the database

  D. data definition language (DDL) for all objects in a schema

  Correct Answer: CD

• Question 179:

  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;

  You notice that results for the functions are not used effectively. What do you recommend for better utilization of the result cache? (Choose all that apply.)

  A. Set the RESULT_CACHE_MODE parameter to FORCE.

  B. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.

  C. Add a format mask parameter, such as RETURN TO_CHAR(date_hired, fmt) to GET_HIRE_DATE.

  D. Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.

  Correct Answer: CD

• Question 180:

  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