Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-146
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/1z0-146.html

Oracle 11g: Advanced PL/SQL

Question No: 1 – (Topic 0)

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

  1. report of invalidated objects in a schema

  2. report of statistics of an object in the database

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

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

Answer: C,D

Question No: 2 – (Topic 0)

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

  1. Detect a wrong user.

  2. Check input string length.

  3. Verify qualified SQL names.

  4. Validate TNS connect strings.

  5. Verify an existing schema name.

  6. Enclose string literals within double quotation marks.

Answer: C,E,F

Question No: 3 – (Topic 0)

View Exhibit1 and examine the structure of the EMPLOYEES and DEPARTMENTS tables existing in your schema.

View Exhibit2 and examine the PL/SQL block that you execute to display the department- wise incremented salary for all the departments in your company.

The code generates an error on execution.

What correction should be done to ensure the code executes successfully?

Dumps4Cert 2018 PDF and VCE

Dumps4Cert 2018 PDF and VCE

  1. The cursor variable parameter should be passed in IN OUT mode.

  2. The cursor variable should be defined as a strong REF CURSOR type.

  3. The cursor variable name passed as actual and formal parameters should be identical.

  4. The %NOTFOUND cursor attribute cannot be used with the cursor variables and should be replaced with a user defined exception.

Answer: A

Question No: 4 – (Topic 0)

Examine the settings for a user session given below: RESULT_CACHE_MODE= FORCE

What would be the implications of this setting on query execution? (Choose all that apply.)

  1. All query results are stored in the result cache if possible.

  2. Query results that are bigger than the available space in the result cache are not cached.

  3. Query results are stored only when you explicitly use the /* result_cache */ hint in your query.

  4. Query results are stored even when you explicitly use the /* no_result_cache */ hint in your query.

Answer: A,B

Question No: 5 – (Topic 0)

Which two statements are true about the tuning of PL/SQL code? (Choose two.)

  1. Redundant SQL statements in PL/SQL code should be avoided.

  2. Implicit data type conversion in PL/SQL code can improve performance.

  3. Usage of the NOT NULL constraint in PL/SQL code can degrade performance.

  4. If you have one PL/SQL program unit instead of multiple smaller executable sections, performance can be improved.

Answer: A,C

Question No: 6 – (Topic 0)

You have an external C procedure stored in a dynamic-link library (DLL). The C procedure takes an integer as argument and returns an integer. You want to invoke the C procedure through a PL/SQL program.

View the Exhibit.

Which statement is true about the C_OUTPUT PL/SQL program?

Dumps4Cert 2018 PDF and VCE

  1. It invokes the external C procedure.

  2. It only publishes the external C procedure.

  3. It fails because the external C procedure is not published.

  4. It fails because the input data type is BINARY_INTEGER and the external C procedure expects an integer.

Answer: C

Question No: 7 – (Topic 0)

Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)

  1. You can describe remote objects.

  2. You can describe anonymous PL/SQL blocks.

  3. You can describe a stored procedure, stored function, packaged procedure, or packaged function.

  4. You can obtain information about the position, name, and data type of the arguments of a procedure.

Answer: C,D

Question No: 8 – (Topic 0)

Which two queries#39; results cannot be cached? (Choose two.)

  1. queries having the GROUP BY clause

  2. queries having the ORDER BY clause

  3. the query on dictionary and temporary tables

  4. queries having SYSDATE and SYS_TIMESTAMP SQL functions

Answer: C,D

Question No: 9 – (Topic 0)

When do you use static SQL as a technique for avoiding SQL injection?

  1. when the WHERE clause values are unknown

  2. when the code contains data definition language (DDL) statements

  3. when all Oracle identifiers are known at the time of code compilation

  4. when the SET clause values are unknown at the time of code compilation

Answer: C

Question No: 10 – (Topic 0)

The database instance was recently started up. Examine the following parameter settings for the database instance:

NAME TYPE VALUE

—————— —— ————–

………

result_cache_max_result integer 5 result_cache_max_size big integer 0

result_cache_mode string MANUAL

result_cache_remote_expiration integer 0

………

You reset the value for the result_cache_max_size parameter by issuing the following command:

SQLgt; ALTER SYSTEM SET result_cache_max_size = 1056k SCOPE = BOTH; System altered.

Which statement is true in this scenario?

  1. 1056 KB is allocated for the result cache and the result cache is enabled.

  2. 1056 KB is allocated for the result cache, but the result cache is disabled.

  3. The results for only the queries that have the RESULT_CACHE hint are cached.

  4. The results for all the queries except those having the NO_RESULT_CACHE hint are cached.

Answer: B

100% Dumps4cert Free Download!
Download Free Demo:1z0-146 Demo PDF
100% Dumps4cert Free Guaranteed!
1z0-146 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Comments are closed.