1Z0-146 Exam Questions

Which two statements are true about the working of fine-grained access? (Choose two.)

View the Exhibit. How do you reduce the chances of SQL injection for the procedure?

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

Examine the structure of the LOB_STORE table. Name Null? Type ----------- ------ ------------ LOB_ID NUMBER VIDEO_CLIP BLOB You create a 'DATA_FILES' directory object that contains...

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

There is a Java class file in your system and you publish it using the following command: CREATE OR REPLACE PROCEDURE ccformat (x IN OUT VARCHAR2) AS LANGUAGE JAVA NAME 'FormatCred...

View the Exhibit and examine the code in the PL/SQL block. The PL/SQL block generates an error on execution. What is the reason?

Which two statements are true about the extproc process? (Choose two.)

Which two statements are true about the SQL Query Result Cache? (Choose two.)

You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schem a. The user sessions are able to access only the desired rows. The database admi...

Identify two methods for immunizing PL/SQL code against SQL injection attacks. (Choose two.)

You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached result bypassed? (Choose all that apply.)

View the Exhibit and examine the output. Which statement is an inference from the output?

You created a procedure as follows: CREATE OR REPLACE PROCEDURE query_prod(twhr VARCHAR2) IS stmt VARCHAR2(100); pname VARCHAR2(20); BEGIN stmt:='SELECT product_name FROM products...

View Exhibit1 and examine the structure of the EMPLOYEES table. View Exhibit2 and examine the code in the PL/SQL block. The PL/SQL block fails to execute. What could be the reason?

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 issue this command to create a table called LOB_STORE: CREATE TABLE lob_store (lob_id NUMBER(3), photo BLOB DEFAULT EMPTY_BLOB(), cv CLOB DEFAULT NULL, ext_file BFILE DEFAULT N...

Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?

In which situation should you use an outer join query?

You need to store currency data and you know that the data will always have two digits to the right of the decimal point. However, the number of digits to the left of the decimal p...

You have decided to permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?

Which table name is valid?

You issue the following command to create the PRINT_MEDIA table. CREATE TABLE print_media (product_id NUMBER(3), ad_sourcetext CLOB, ad_photo BLOB); Evaluate the following INSERT s...

Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)

View Exhibit1 and examine the structure of the EMPLOYEES table. View Exhibit2 and examine the code in the PL/SQL block. The PL/SQL block fails to execute. What could be the reason?

You executed the following command to alter the session parameter: SQL> ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:ALL'; Which two statements are true in this scenario? (Cho...

Examine the following structure: SQL> DESCRIBE user_identifiers Name Null? Type -------------------- ---------- ---------- NAME VARCHAR2(30) SIGNATURE VARCHAR2(32) TYPE VARCHAR2(18...

Examine the following settings for a session: PLSQL_CODE_TYPE = NATIVE View the Exhibit and examine the PL/SQL code. You compile the program with the following attributes: SQL> ALT...

Examine the structure of the PRINT_MEDIA table: Name Null? Type --------------- -------- --------- ADVT_ID NUMBER ADVT_SOURCE CLOB Examine the following PL/SQL block: DECLARE loblo...

View the Exhibit and examine the PL/SQL code. The code takes a long time to execute. What would you recommend to improve performance?

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

View Exhibit1 and examine the structure of the EMPLOYEES and DEPARTMENTS tables existing in your schem a. View Exhibit2 and examine the PL/SQL block that you execute to display the...

Examine the following error: SQL> DECLARE v_runid NUMBER; BEGIN v_runid := DBMS_HPROF.ANALYZE (LOCATION => 'PROFILE_DATA', FILENAME => 'pd_cc_pkg.txt'); DBMS_OUTPUT.PUT_LINE('Run I...

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

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

You created the SALES_ORDERS_CTX context to use the OE.SALES_ORDERS_PKG package. View Exhibit1 and examine the package that is used with the context. View Exhibit2 to examine the p...

Examine the following command to create the table EMPLOYEES_TEMP and the PL/SQL block. CREATE TABLE employees_temp (empid NUMBER(6) NOT NULL, deptid NUMBER(6) CONSTRAINT c_emp_dept...

Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.)

The result cache is enabled for the database instance. Examine the following code for a PL/SQL function: CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR RES...

You have an external C procedure stored in a dynamic-link library (DLL). The C procedure takes an integer as argument and returns an integer. You want to invoke the C procedure thr...

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

The following command is executed to start tracing in a user session: SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS); Which statement is true about th...

You executed this command to gather information about the memory allocation for storing query results: SQL> execute dbms_result_cache.memory_report View the Exhibit and examine the...

View the Exhibit and examine the PL/SQL code. Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply.)

The user OE is working on an application that needs to call an external C program multiple times in a single session. However, the extproc.exe file on the server gets accidentally...

Which two statements are true about BFILES? (Choose two.)

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

Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB? (Choose two.)

Which two queries' results cannot be cached? (Choose two.)

View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables. Examine the PL/SQL block that you execute to find the average salary for employees in the 'Sale...