1Z0-148 Online Practice Questions and Answers
Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables.
A. the trace file component
B. the analyzer component
C. the shared library component
D. the data collection component
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? (Choose two.)
A. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.
B. All the identifiers declared in compiled program units before altering the parameter settings appear in the *_IDENTIFIER static data dictionary views.
C. All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data dictionary views.
D. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects data for the compiled object and stores it in the SYSTEM tablespace.
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 in an associative array:
1 DECLARE
2 emp_cv SYS_REFCURSOR;
3 TYPE list IS TABLE OF emp_cv;
4 sals list;
5 BEGIN
6 OPEN emp_cv FOR SELECT salary FROM employees
7 WHERE job_id = 'SA_REP';
8 FETCH emp_cv BULK COLLECT INTO sals;
9 CLOSE emp_cv;
10 END;
What should you correct in the above code to ensure that it executes successfully?
A. Replace EMP_CV in line 3 with employees.salary%TYPE.
B. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.
C. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.
D. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.
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 parameter settings for your database:
MEMORY_TARGET = 500M
RESULT_CACHE_MODE = MANUAL
You execute a query by using the result_cache hint. Which statement is true in this scenario?
A. The query results are not stored because no memory is allocated for the result cache.
B. The query results are stored and 0.5% of the memory target is allocated to the result cache.
C. The query results are stored and 0.25% of the memory target is allocated to the result cache.
D. The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE.
Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 3
Which statement would be true in this scenario?
A. The compiler would automatically inline subprograms.
B. The compiler would inline the code for external subroutines.
C. The compiler would inline the code even if the INLINE pragma is set to NO.
D. The compiler would not inline the code unless the INLINE pragma is set to YES.
Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
A. You can describe remote objects.
B. You can describe anonymous PL/SQL blocks.
C. You can describe a stored procedure, stored function, packaged procedure, or packaged function.
D. You can obtain information about the position, name, and data type of the arguments of a procedure.
Which three commands can be used to set PL/SQL conditional compilation inquiry directive MODE?
A. ALTER SESSION SET PLSQL_CCFLAGS = `mode: FALSE';
B. ALTER SESSION SET PLSQL_CCFLAGS= `mode: NULL';
C. ALTER SESSION SET PLSQL_CCFLAGS= `mode: Level 1';
D. ALTER SESSION SET PLSQL_CCFLAGS= `mode: Level1';
E. ALTER SESSION SET PLSQL_CCFLAGS= `mode: 1'
Examine these program units: Which two blocks will execute successfully?
A. BEGIN My_proc; END;
B. BEGIN pkg2.proc3; END;
C. BEGIN pkg2.proc2; END;
D. BEGIN pkg1.proc1a; END;
E. BEGIN pkg1.proc1b; END;
Which data dictionary view includes information about the parameters of procedures and functions that you can call?
A. ALL_PROCEDURES
B. ALL_PACKAGES
C. ALL_ARGUMENTS
D. ALL_OBJECTS
Examine this code:
Execute this PL/SQL block:
Which is the correct category of SQL injection attack?
A. First Order Attack
B. Second Order Attack
C. Incorrect type handling
D. Lateral Injection