Exam information

Exam 1z0-146: Oracle Database 11g: Advanced PL/SQL (update January 29th, 2014)

Other exams

Which two types of metadata can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package?

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

Which statement is true in this scenario?

The database instance was recently started up. Examine the following parameter settings for thedatabase instance:NAME TYPE VALUE———————————— ———– —————————-………result_cache_max_result integer 5result_cache_max_size big integer […]

What is the reason for this?

In a user session, tracing is enabled as follows:SQL> EXECUTEDBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES);PL/SQL procedure successfully completed.You executed the procedure as follows:SQL> EXECUTE PROC10PL/SQL procedure successfully completed.When you examine the […]

Which two statements are true about SecureFile LOB options?

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

Which statement is true about the outcome on executing the above PL/SQL block?

View the Exhibit and examine the structure of the EMPLOYEES table.Examine the following PL/SQL block:DECLARETYPE EmpListIS VARRAY(2) OF employees.employee_id%TYPE NOT NULL;v_employees EmpList := EmpList();BEGINDBMS_OUTPUT.PUT_LINE(v_employees.COUNT);v_employees.EXTEND;v_employees(1) := […]

Which three statements are appropriate for protecting the code in the procedure from SQL injection?

View the Exhibit and examine the procedure to create a trigger name based on the table namesupplied to the procedure.Which three statements are appropriate for protecting the code in the procedure from SQLinjection? (Choose three.)

Which statement describes the purpose of the plshprof command?

Which statement describes the purpose of the plshprof command?

Name Null?

Examine the structure of the DEPARTMENTS table.Name Null? Type—————————– ———— ———-DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)LOCATION_ID NUMBER(4)View the Exhibit and examine the code that you plan to use for creating a package to […]

Which two statements correctly describe the features of SecureFiles?

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

Which statement is true about the metadata gathered by the function?

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?

Page 1 of 1212345...10...Last »