[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-146 Dumps with VCE and PDF 51-60

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-146
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-146.html

Oracle 11g: Advanced PL/SQL

Question No: 51 – (Topic 0)

Examine the structure of the EMPLOYEES table that exists in your schema.

Name Null? Type

————- ——– ———– EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8,2)

COMMISSION_PCT NUMBER(2,2)

DEPARTMENT_ID NUMBER(4)

You successfully create a GET_MAX procedure to find the maximum salary in the department of a specified employee.

You then code a PL/SQL block to display the maximum salary in the departments of the first five employees in the EMPLOYEES table.

View the Exhibit. Examine the procedure and the block of PL/SQL code. What is the outcome of executing the block of PL/SQL code?

Ensurepass 2018 PDF and VCE

  1. It executes successfully and gives the required output.

  2. It gives an error because ROWNUM cannot be used in cursor definitions.

  3. It gives an error because usage of the %ROWCOUNT attribute is not valid.

  4. It executes successfully, but does not give the required output because the procedure call resets the %ROWCOUNT value.

Answer: A

Question No: 52 – (Topic 0)

Identify the two types 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-intensive 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

Answer: B,C

Question No: 53 – (Topic 0)

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

  1. using policy functions to generate predicates dynamically

  2. creating triggers on corresponding tables to generate dynamic predicates

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

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

Answer: A

Question No: 54 – (Topic 0)

Which statements are true about the SecureFile storage paradigm? (Choose two.)

  1. SecureFile storage can be used for internal and external LOBs.

  2. Automatic Segment Space Management must be enabled for a tablespace to store SecureFile LOBs.

  3. SecureFile options enabled for a LOB column can be overridden on a per-LOB basis within the column.

  4. SecureFile is the default storage paradigm for all LOBs that are stored in locally managed tablespaces if the DB_SECUREFILE parameter is set to ALWAYS.

Answer: B,C

Question No: 55 – (Topic 0)

You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for an attribute within the context:

SQLgt; EXECUTE DBMS_SESSION.SET_CONTEXT(#39;SALES_ORDERS_CTX#39;,#39;ACCOUNT_MGR#39;,#39;OE#39;);

BEGIN DBMS_SESSION.SET_CONTEXT(#39;SALES_ORDERS_CTX#39;,#39;ACCOUNT_MGR#39;,#39;OE#39;); END;

*

ERROR at line 1:

ORA-01031: insufficient privileges

ORA-06512: at quot;SYS.DBMS_SESSIONquot;, line 94

ORA-06512: at line 1

What is the reason for this error?

  1. The context was created with a package name in the USING clause.

  2. The attribute can be set only in the package associated with the context.

  3. The package associated with the context did not exist at the time of creation of the context.

  4. The value for an attribute of a user-defined context can be set only by the ALTER SESSION command.

Answer: B

Question No: 56 – (Topic 0)

To examine the dependencies between all PL/SQL objects and the tables and views they reference, you executed the following query as the user OE:

SQLgt; SELECT owner || #39;.#39; || NAME refs_table

, referenced_owner || #39;.#39; || referenced_name AS table_referenced FROM all_dependencies

WHERE owner = USER

AND TYPE IN (#39;PACKAGE#39;, #39;PACKAGE BODY#39;,#39;PROCEDURE#39;, #39;FUNCTION#39;)

AND referenced_type IN (#39;TABLE#39;, #39;VIEW#39;)

AND referenced_owner NOT IN (#39;SYS#39;, #39;SYSTEM#39;)

ORDER BY owner, NAME, referenced_owner, referenced_name; Which statement is true about the output of the query?

  1. It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..

  2. It displays no rows because this query needs to be executed as the user SYS for required results.

  3. It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.

  4. It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.

Answer: A

Question No: 57 – (Topic 0)

You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed the following command to check the status for the result cache:,

SQLgt; select dbms_result_cache.status() from dual; You receive the following output: DBMS_RESULT_CACHE.STATUS()

———————– DISABLED

Identify the reason for the output.

  1. The RESULT_CACHE_MODE parameter is set to FORCE.

  2. The RESULT_CACHE_MODE parameter is set to MANUAL.

  3. The database instance is not able to allocate memory for the result cache.

  4. The database instance was started with the RESULT_CACHE_MAX_SIZE parameter set to 0.

Answer: D

Question No: 58 – (Topic 0)

You execute the following command in the user session:

SQLgt; ALTER SESSION SET PLSQL_DEBUG=true;

Which statement is true about the effect of the command?

  1. All PL/SQL blocks that are executed subsequently in the session are traced.

  2. It enables all PL/SQL blocks that are compiled subsequently in the session for tracing.

  3. Only anonymous PL/SQL blocks that are executed subsequently in the session are traced.

  4. It enables only named PL/SQL blocks that are executed subsequently in the session for tracing.

Answer: B

Question No: 59 – (Topic 0)

Identify two strategies against SQL injection. (Choose two.)

  1. Using parameterized queries with bind arguments.

  2. Use subprograms that are run with the definer#39;s right.

  3. Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.

  4. Validate user inputs to functions that use dynamic SQLs built with concatenated values.

Answer: A,D

Question No: 60 – (Topic 0)

A procedure is created in the SYS schema to allow users to change the password as follows:

CREATE OR REPLACE

PROCEDURE change_password(p_username VARCHAR2 DEFAULT NULL, p_new_password VARCHAR2 DEFAULT NULL)

IS

v_sql_stmt VARCHAR2(500); BEGIN

v_sql_stmt := #39;ALTER USER #39;||p_username ||#39; IDENTIFIED BY #39;

|| p_new_password; EXECUTE IMMEDIATE v_sql_stmt; END change_password;

The SYS user has granted EXECUTE privilege on the procedure to the OE user. But OE is able to change the password for SYS by using this procedure. How would you protect this?

  1. by using the procedure as part of a PL/SQL package

  2. by using a bind argument with dynamic SQL in the procedure

  3. by using AUTHID DEFINER in the procedure to implement the definer#39;s right

  4. by using AUTHID CURRENT_USER in the procedure to implement the invoker#39;s right

Answer: D

100% Ensurepass Free Download!
Download Free Demo:1z0-146 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-146 Dumps

EnsurePass 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.