Which two types of metadata can be retrieved by using the various procedures in theDBMS_METADATA PL/SQL package? (Choose two.)
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 […]
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? (Choose two.)
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) := […]
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?
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? (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?