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.)
-
report of invalidated objects in a schema
-
report of statistics of an object in the database
-
DDL for all object grants on a table in the database
-
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.)
-
Detect a wrong user.
-
Check input string length.
-
Verify qualified SQL names.
-
Validate TNS connect strings.
-
Verify an existing schema name.
-
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?
-
The cursor variable parameter should be passed in IN OUT mode.
-
The cursor variable should be defined as a strong REF CURSOR type.
-
The cursor variable name passed as actual and formal parameters should be identical.
-
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.)
-
All query results are stored in the result cache if possible.
-
Query results that are bigger than the available space in the result cache are not cached.
-
Query results are stored only when you explicitly use the /* result_cache */ hint in your query.
-
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.)
-
Redundant SQL statements in PL/SQL code should be avoided.
-
Implicit data type conversion in PL/SQL code can improve performance.
-
Usage of the NOT NULL constraint in PL/SQL code can degrade performance.
-
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?
-
It invokes the external C procedure.
-
It only publishes the external C procedure.
-
It fails because the external C procedure is not published.
-
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.)
-
You can describe remote objects.
-
You can describe anonymous PL/SQL blocks.
-
You can describe a stored procedure, stored function, packaged procedure, or packaged function.
-
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.)
-
queries having the GROUP BY clause
-
queries having the ORDER BY clause
-
the query on dictionary and temporary tables
-
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?
-
when the WHERE clause values are unknown
-
when the code contains data definition language (DDL) statements
-
when all Oracle identifiers are known at the time of code compilation
-
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?
-
1056 KB is allocated for the result cache and the result cache is enabled.
-
1056 KB is allocated for the result cache, but the result cache is disabled.
-
The results for only the queries that have the RESULT_CACHE hint are cached.
-
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 |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF