Free 1Z0-148 Exam Dumps Preview

Select the correct statement regarding BEQUEATH CURRENT_USER.

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?

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 output for the execution of the DBMS_RESULT_CACHE.MEMORY_REPORT procedure.

Which two statements are true about the output in the Exhibit? (Choose two.)

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 through a PL/SQL program.

View the Exhibit.

Which statement is true about the C_OUTPUT PL/SQL program?

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

View the Exhibit and examine the output.

Which statement is an inference from the output?

Which two statements are true with respect to fine-grained access control?

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 employees in department ID 60.

Which statement is true about the outcome?

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?

Examine these two columns:

Which set of paired items is valid with respect to the DBMS_PARALLEL_EXECUTE package?

Examine the following parameter values for a session:

PLSQL_CODE_TYPE = NATIVE

PLSQL_OPTIMIZE_LEVEL = 2

Which two statements are true in this scenario? (Choose two.)

Which two statements are true about PL/SQL APIs for SecureFiles? (Choose two.)

Which statement is true in regard to minimizing attack surface during application design?

Which two types of query results cannot be stored in the query result cache? (Choose two.)

The user MY_USER has been assigned the roles CONNECT, RESOURCE, and DBA.

Which statement generates the DDL for these privileges?

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

In which two situations will a result-cached function execute even though no change was made on a dependent table or view? (Choose two.)

Examine the structure of the DEPT table which exists in both BRANCH1 and BRANCH2 schemas:

Examine this code:

Which three modifications must be done to endure the anonymous block displays the output form the BRANCH2.
DEF DEPT table?

Examine this function body:

BEGIN
SELECT hire_date INTO date_hired FROM employees WHERE employee_id=emp_id;
RETURN TO_CHAR(date_hired);
END;

Which two headers will allow this function to compile successfully and take advantage of both invoker's rights and function result caching?

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?

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

You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schema. The user sessions are able to access only the desired rows. The database administrator (DBA) uses the following command:

SQL> EXECUTE
DBMS_RLS.ENABLE_POLICY('OE','ORDERS','OE_ORDERS_ACCESS_POLICY',FALSE );

Which statement is true about user sessions that are connected currently?

The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2
and DEPARTMENT_ID of data type NUMBER.

There are six employees in DEPARTMENT_ID, 20.

Examine this code:

What will be the outcome on execution?

Match the following external C procedure components with their descriptions:

1. External procedure a. a process that starts the extproc process

2. Shared library b. a session-specific process that executes the external procedure

3. Alias library c. schema object that represents the operating system (OS) shared library

4. The extproc process d. operating system file that stores the external procedure

5. Listener process e. a unit of code written in C

Examine the code:

Which two blocks can be used to complete the executable section such that LIST2 is dense? (Choose two.)

Examine the structure of the EMP table:

Name
Null? Type
------ ----- -------
EMPNO NOT NULL NUMBER (4)
ENAME
VARCHAR2 (10) SAL NUMBER (7, 2)

Examine this code:

Which code should be inserted to display the collection contents?

Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables.

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 ID: ' || v_runid);

END;

DECLARE

*

ERROR at line 1:

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_HPROF", line 299

ORA-06512: at line 4

What would you do to execute the above block successfully?

Your company decided to update its employees' contact information as a one-time event.

With thousands of employees' records to be updated, the project manager hoped to achieve substantial performance gains using the DBMS_PARALLEL_EXECUTE package and identified these four actions to be executed.

1. dbms_parallel_execute.create_task

2. GRANT system privilege CREATE JOB to the user executing this task

3. dbms_parallel_execute.run_task

4. dbms_parallel_execute.create_chunks_by_rowid

Select the correct order of actions to implement the parallel execution of PL/SQL blocks.

Examine this code executed as SYS:

Examine this code executed as SPIDER and the error message received upon execution:

What is the reason for this error?

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 refs_table

, referenced_owner || '.' || referenced_name AS table_referenced

FROM all_dependencies

WHERE owner = USER

AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION')

AND referenced_type IN ('TABLE', 'VIEW')

AND referenced_owner NOT IN ('SYS', 'SYSTEM')

ORDER BY owner, NAME, referenced_owner, referenced_name;

Which statement is true about the output of the query?

Examine this code:

Execute this PL/SQL block:

Which is the correct category of SQL injection attack?

Examine these statements:

1. A function with invoker's rights can be result cached by using both AUTHID CURRENT_USER and RESULT_CACHE in its declaration.
2. A function with invoker's rights cannot be result cached because it may allow a user to retrieve data cached by another user.
3. Results in the result cache for an invoker's rights function will be cached by the value of CURRENT_SCHEMA in the invoking environment.
4. By default, declaring a function with RESULT_CACHE makes it an invoker's rights result cached function.
5. A function with invoker's rights can be result cached because the function result cache is created per user for invoker's rights functions.

Identify the set of correct statements with respect to invoker's rights and function result caching.

Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)

Identify three guidelines for the DBMS_ASSERT package. (Choose three.)

Examine the DBMS_LOB.LOADCLOBFROMFILE procedure:

Which statement is true about DBMS_LOB.LOADCLOBFROMFILE?