1Z0-146 Exam Questions

Which two statements are true about the context of an application? (Choose two.)

View the Exhibit and examine the PL/SQL code. Which statement is true about the execution of the PL/SQL code?

Examine the following settings for a session: PLSQL_CODE_TYPE = NATIVE PLSQL_OPTIMIZE_LEVEL = 3 Which statement would be true in this scenario?

The database instance was started up with the following initialization parameter values: MEMORY_TARGET = 500M RESULT_CACHE_MODE = FORCE RESULT_CACHE_MAX_SIZE = 0 After the database...

Examine the structure of the PRODUCTS table. Name Null? Type --------------- ------------ --------------- PRODUCT_ID NOT NULL NUMBER(6) PRODUCT_NAME VARCHAR2(50) CATEGORY_ID NUMBER...

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

You executed the following command: SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'; You create a new package called PACK1. View Exhibit1 to examine the PL/SQL code for...

You enabled PL/SQL tracing in a user session using the following command: SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS); View Exhibit1 to examine the output....

Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)

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

Which two statements are true about associative arrays and nested tables? (Choose two.)

Examine the following line of code that is part of a PL/SQL application: stmt:='SELECT session_id FROM sessions WHERE ' || p_where_stmt; Identify a solution for preventing SQL inje...

Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)

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

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 c...

Which ALTER command would you use to reinstate a disabled primary key constraint?

You need to perform a major update on the EMPLOYEE table. You have decided to disable the PRIMARY KEY constraint on the empid column and the CHECK constraint on the job column. Wha...

Which statement is valid within the executable section of a PL/SQL block?

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

Examine the PL/SQL code for the GET_TABLE_MD function given below: CREATE OR REPLACE FUNCTION get_table_md RETURN CLOB IS h NUMBER; th NUMBER; doc CLOB; BEGIN h := DBMS_METADATA.OP...

View the Exhibit to examine a Java source file. You have the corresponding Java class file and you execute the command as follows: SQL> CREATE OR REPLACE PROCEDURE ccformat (x IN O...

View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table i...

Examine the section of code taken from a PL/SQL program: PROCEDURE p1 (x PLS_INTEGER) IS ... ... PRAGMA INLINE (p1, 'NO'); x:= p1(1) + p1(2) + 17; -- Call 1 ... x:= p1(3) + p1(4) +...

Which statements are true about temporary LOBs? (Choose all that apply.)

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 em...

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

Which two statements are true about the initialization of internal LOBs? (Choose two.)

Examine the structure of the EMPLOYEES table that exists in your schema. Name Null? Type ---------------- ----------- -------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCH...

Identify the two types of PL/SQL programs for which you consider setting the compilation method to native mode. (Choose two.)

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

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

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

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: SQL> SELECT owner || '.' || NAME re...

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:, SQL> select dbms_result_cac...

You execute the following command in the user session: SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command?

In which two situations is the body of a result-cached function executed? (Choose two.)

Which two types of metadata can be retrieved by using the various procedures in the BMS_METADATA PL/SQL package? (Choose two.)

The database instance was recently started up. Examine the following parameter settings for the database instance: NAME TYPE VALUE ---------------------- --------- ----------- .......

In a user session, tracing is enabled as follows: SQL> EXECUTE. DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES); PL/SQL procedure successfully completed. You executed th...

Which two statements are true about SecureFile LOB options? (Choose two.)

View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block: DECLARE TYPE EmpList IS VARRAY(2) OF employees.employee_id%TYPE NOT NULL; v_e...

View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure. Which three statements are appropriate for protecting the cod...

Which statement describes the purpose of the plshprof command?

Examine the structure of the DEPARTMENTS table. Name Null? Type -------------------- ------------ ---------- DEPARTMENT_ID NOT NULL NUMBER(4) DEPARTMENT_NAME NOT NULL VARCHAR2(30)...

Which two statements correctly describe the features of SecureFiles? (Choose two.)

View the Exhibit to examine the PL/SQL code for the GET_METADATA function. Which statement is true about the metadata gathered by the function?

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 c...

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

Examine the commands: CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20) / CREATE TYPE typ_course_nst AS TABLE OF typ_course_tab / CREATE TABLE faculty (faculty_id NUMBER(5),...

Examine the structure of the EMPLOYEES table in the SCOTT schema. Name Null? Type --------------- ---------- --------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20)...