Download Oracle Database 11g Advanced PLSQL.1z0-146.PrepAway.2018-12-10.60q.vcex

Vendor: Oracle
Exam Code: 1z0-146
Exam Name: Oracle Database 11g Advanced PLSQL
Date: Dec 10, 2018
File Size: 4 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?
  1. The corresponding shared library is also removed from the system
  2. PL/SQL subprograms can be used to invoke the external C procedure
  3. The existing extproc process is terminated and a new extproc is started
  4. The PL/SQL subprogram that depends on the external C program becomes invalid
Correct answer: D
Question 2
See the exhibit:
  
  
Which of the above INSERT statements are valid? 
  1. Only the first statement is valid
  2. All the statement are valid
  3. Only the first and fourth statements are valid
  4. Only the first and second statements are valid
  5. Only the first, second and third statements are valid
Correct answer: E
Question 3
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?
  1. The query results are not stored because no memory is allocated for the result cache
  2. The query results are stored and 0.5% of the memory target is allocated to the result cache
  3. The query results are stored and 0.25% of the memory target is allocated to the result cache
  4. The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE
Correct answer: C
Question 4
Which three actions can be performed by using the DMBS_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 exisitng schema name
  6. Enclose string literals within double quotation marks
Correct answer: CEF
Question 5
Examine the following settings for a session:
  
  
Which statement would be true in this scenario?
  1. The compiler would automatically inline subprograms
  2. The compiler would inline the code for external subroutines
  3. The compiler would inline the code even if the INLINE pragma is set to NO
  4. The compiler would not inline the code unless the INLINE pragma is set to YES
Correct answer: A
Question 6
Which two statements are true about SecureFile LOB options? (Choose two.)
  1. The COMPRESSION HIGH option can be enabled only for CLOBs
  2. The COMPRESSION HIGH option can be enabled for all internal LOBs
  3. The DECRYPT option can be used to remove encryption only if the LOB column is empty
  4. The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data 
Correct answer: BD
Question 7
Identify three guidelines for the DBMS_ASSERT package.(Choose three.)
  1. Prefix all calls to DBMS_ASSERT with the SYS schema name
  2. Embed DBMS_ASSERT verification routines inside the injectable string
  3. Escape single quotes when you use the ENQUOTE_LITERAL procedur e
  4. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions
  5. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package
Correct answer: ACD
Question 8
Identify the two type of PL/SQL programs for which you consider setting the compilation method to native mode. (choose two.)
  1. PL/SQL programs that are still in the debugging phase of development
  2. PL/SQL programs that have computation-intesive procedural operations
  3. A PL/SQL program, which is called with the same parameters by multiple sessions
  4. PL/SQL programs that spend most of their execution time in executing SQL statements
Correct answer: BC
Question 9
See the Exhibit:
  
The PL/SQL block fails to execute; 
What could be the reason?
  1. Nested tables cannot be returned by a function
  2. The NEWNAMES nested table has not been initialized
  3. The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2
  4. The third element of OLDNAMES cannot be assigned to the thrid element of GROUP1 because they are of incosistent data types
  5. LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements
Correct answer: E
Question 10
See the Exhibit:
  
  
DATA_FILES is a directory object that contains the DETAILS.txt text file. You have the required permissions to access the directory object. You have a table using the following command:
CREATE TABLE clob_tab(col2,CLOB); 
Examine the PL/SQL statement in exhibit that you execute for loading the external text file into the table that currently has no rows. The PL/SQL block results in an error. What correction must be done to ensure the PL/SQL block executes successfully? 
  1. The L_OUT variable must be initialized to an empty locator
  2. The L_OUT variable has to be declared as a temporary LOB 
  3. The A_CLOB variable has to be declared as a temporary LOB
  4. The clause RETURINING col2 INTO a a_clob should be added to the INSERT statement to correctly initialize the locator
Correct answer: D
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!