Download Oracle Database 11g Advanced PLSQL.1z0-146.CertDumps.2017-12-19.117q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-146 |
| Exam Name: | Oracle Database 11g Advanced PLSQL |
| Date: | Dec 19, 2017 |
| File Size: | 10 MB |
How to open TQB files?
Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.
Purchase
Coupon: TAURUSSIM_20OFF
Discount: 20%
Demo Questions
Question 1
Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)
- Only local subroutines can be inlined
- Inlining always reduces the execution time of a PL/SQL program unit
- PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2
- The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining
Correct answer: AC
Question 2
Which three statements are true about hierarchical profiling? (Choose three.)
- It reduces function-level summaries
- It produces an aggregated report of the SQL and PL/SQL execution times
- It is useful for understanding the structure and control flow of complex programs
- It can be used to identify hotspots and tuning opportunities in PL/SQL applications
Correct answer: ACD
Question 3
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 quotations marks
Correct answer: CEF
Question 4
Identify the method that is used by fine-grained access(FGA).
- Using policy functions to generate predicates dynamically
- Creating triggers on corresponding tables to generate dynamic predicates
- Modifying the existing application code to include a predicate for all SQL statements
- Creating views with necessary predicates and then creating synonyms with the same name as the tables
Correct answer: A
Question 5
See the Exhibit and examine the PL/SQL code for the following table:
Which statement is true about the compilation and execution of the function?
- The function retrieves the metadata in Extensible Markup Language (XML) format for creating the TIMECARDS table in the HR schema
- The compilation produces an error because DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR') is not placed in the correct order
- The function retrieves the metadata as a data definition language (DDL) statement for creating the TIMECARDS table in the HR schema
- The execution of the function produces an error because multiple objects are fetched and DBMS_METADATA.FETCH_CLOB is not called in a LOOP
Correct answer: C
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX FILES
Use ProfExam Simulator to open VCEX files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!