It is more faster and easier to pass the Oracle 1Z0-146 exam by using 100% Guarantee Oracle Oracle 11g: Advanced PL/SQL questuins and answers. Immediate access to the Up to the minute 1Z0-146 Exam and find the same core area 1Z0-146 questions with professionally verified answers, then PASS your exam with a high score now.
♥♥ 2021 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
Q51. 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
Q52. You created the SALES_ORDERS_CTX context to use the
View Exhibit1 and examine the package that is used with the context.
View Exhibit2 to examine the policy defined and the logon trigger.
A user receives the following error when he or she executes a query:
ERROR at line 2:
ORA-28112: failed to execute policy function
What could be the reason for the error?
A. The user has insufficient privileges on the DBMS_SESSION package.
B. The subprograms inside the package have not been created with the invoker's right.
C. The THE_PREDICATE function has an insufficient number of parameters in the package.
D. The policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter.
Q53. Which statement describes the purpose of the plshprof command?
A. It produces HTML output from raw profiler output.
B. It produces HTML output from profiler tables in the database.
C. It populates profiler tables in the database from raw profiler output.
D. It produces raw profiler output on the most recently run applications.
Q54. 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?
A. The query results are not stored because no memory is allocated for the result cache.
B. The query results are stored and 0.5% of the memory target is allocated to the result cache.
C. The query results are stored and 0.25% of the memory target is allocated to the result cache.
D. The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE.
Q55. Which three statements are true about hierarchical profiling? (Choose three.)
A. It provides function-level summaries.
B. It produces an aggregated report of the SQL and PL/SQL execution times.
C. It is useful for understanding the structure and control flow of complex programs.
D. It can be used to identify hotspots and tuning opportunities in PL/SQL applications.
E. It generates trace information for PL/SQL programs in the PLSQL_TRACE_EVENTS table.
Q56. View the Exhibit and examine the output.
Which statement is an inference from the output?
A. The class file is pinned into the Java pool.
B. The class file has been loaded into the shared library.
C. Java class methods in the Java class file have been published.
D. The loadjava command has been executed to load the Java source and class files.
Q57. View Exhibit1 and examine the structure of the EMPLOYEES table.
View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in department ID 60.
Which statement is true about the outcome?
A. It generates an error because RECORD type cannot be used with varrays.
B. It generates an error because BULK COLLECT cannot be used with varrays.
C. It executes successfully only if department ID 60 has five or less than five employees.
D. It executes successfully even if department ID 60 has more than five employees by dynamically extending the varray.
Q58. DATA_FILES is a directory object that contains the DETAILS.TXT text file.
You have the required permissions to access the directory object.
You create a table using the following command:
CREATE TABLE clob_tab(col2 CLOB);
View the Exhibit and examine the PL/SQL block 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?
A. The L_OUT variable must be initialized to an empty locator.
B. The L_OUT variable has to be declared as a temporary LOB. C. The A_CLOB variable has to be declared as a temporary LOB.
D. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator.
Q59. Which two statements correctly describe the features of SecureFiles? (Choose two.)
A. Compression is performed only on the server side and enables random reads and writes to LOB data.
B. Deduplication stores identical data, which occurs in a LOB column in each row, as a single copy within the LOB.
C. Compression can be performed on the client side and it enables random and sequential reads and writes to LOB data.
D. Deduplication stores identical data occurring two or more times in the same LOB column as a single copy for the table.
Q60. When do you use static SQL as a technique for avoiding SQL injection?
A. when the WHERE clause values are unknown
B. when the code contains data definition language (DDL) statements
C. when all Oracle identifiers are known at the time of code compilation
D. when the SET clause values are unknown at the time of code compilation