Simulation of 1Z0-146 exam engine materials and interactive bootcamp for Oracle certification for IT professionals, Real Success Guaranteed with Updated 1Z0-146 pdf dumps vce Materials. 100% PASS Oracle 11g: Advanced PL/SQL exam Today!


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-146 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-146 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-146-exam-dumps.html

Q1. Which two statements are true about associative arrays and varrays? (Choose two.) 

A. Only varrays must use sequential numbers as subscripts. 

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

C. Both associative arrays and varrays must use sequential numbers as subscripts. 

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

Answer: A,B 


Q2. Which guidelines should be considered when designing and using cursors in a PL/SQL block? ? (Choose all that apply.) 

A. When fetching from a cursor, fetch into a record. 

B. Use parameters with cursors so that the result set for the cursor is not tied to a specific variable in a program. 

C. Use the %NOTFOUND attribute in combination with the SELECT INTO statement to check for non existent values. 

D. Whenever possible, explicitly declare the cursor and use the OPEN, FETCH and CLOSE statements to manipulate the cursor instead of using cursor FOR loop. 

E. When using data manipulation language statements, (DML) reference a SQL cursor attribute immediately after the DML statement executes in the same block. 

Answer: A,B,E 


Q3. Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.) 

A. It can be performed only on tables with a single LOB column. 

B. It automatically creates an interim table during the migration process. 

C. It allows the table that is migrated to be accessed throughout the migration process. 

D. It requires free space that is at least equal to the space used by the table that is migrated. 

E. It requires all constraints defined on the original table to be re-created manually after the migration. 

Answer: C,D 


Q4. Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.) 

A. When fetching from a cursor, fetch into a record. 

B. When fetching from a cursor, fetch required values into individually declared variables. 

C. Whenever possible, explicitly declare the cursor and use the OPEN, FETCH, and CLOSE statements to manipulate the cursor instead of using the cursor FOR loop. 

D. Whenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and using the OPEN, FETCH, and CLOSE statements to manipulate the cursor. 

Answer: A,D 


Q5. Which two statements are true about associative arrays and varrays? (Choose two.) 

A. Only varrays must start with the subscript 1. 

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

C. Both associative arrays and varrays must start with the subscript 1. 

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

Answer: A,B 


Q6. Which two statements are true about nested tables and varrays? (Choose two.) 

A. Only varrays must have consecutive numbers as subscripts. 

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

C. Both nested tables and varrays must have consecutive numbers as subscripts. 

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

Answer: A,D 


Q7. 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.) 

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

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

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

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

Answer: A,B 


Q8. Identify the method that is used by fine-grained access (FGA). 

A. using policy functions to generate predicates dynamically 

B. creating triggers on corresponding tables to generate dynamic predicates 

C. modifying the existing application code to include a predicate for all SQL statements 

D. creating views with necessary predicates, and then creating synonyms with the same name as the tables 

Answer:


Q9. Which two statements are true about cursor variables? (Choose two.) 

A. Cursor variables can be parameterized like cursors. 

B. The query associated with a cursor variable cannot reference host variables and PL/SQL variables. 

C. The FETCH statement executes the query associated with a cursor variable and identifies the result set. 

D. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable. 

E. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set. 

Answer: D,E 


Q10. Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.) 

A. It can be performed only on tables with a single LOB column. 

B. It automatically creates an interim table during the migration process. 

C. It allows the table that is migrated to be accessed throughout the migration process. 

D. It requires free space that is at least equal to the space used by the table that is migrated. 

E. It requires all constraints defined on the original table to be re-created manually after the migration. 

Answer: C,D