Oracle Oracle Certifications 1Z0-148 Questions & Answers

• Question 51:

  Examine the section of code taken from a PL/SQL program:

  

  PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3. Which two statements are true?

  A. Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.

  B. Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.

  C. Calls to TESTPROC are not inlined in the line commented as Call 1.

  D. Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.

  E. Calls to TESTPROC might be inlined in the line commented as Call 2.

  Correct Answer: AE

  Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/tuning.htm

• Question 52:

  Examine the following SQL statement:

  ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;

  What is the result of executing this statements?

  A. The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.

  B. The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.

  C. The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.

  D. This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,

  Correct Answer: C

• Question 53:

  Examine this code: Which two corrections must be applied for this anonymous block to execute successfully?

  

  A. Change RETURN p_tab.LAST to RETURN p_tab.COUNT.

  B. Declare the collection type inside the function.

  C. Declare the collection type at the schema level instead of the package.

  D. Define the function as stand-alone instead of in a package body.

  E. Change the INDEX BY clause from VARCHAR2 to PLS_INTEGER.

  F. Modify the function return type to return a scalar, VARCHAR2.

  Correct Answer: EF

• Question 54:

  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.

  A. 2, 1, 3 and 4

  B. 1, 2, 4 and 3

  C. 2, 1, 4 and 3

  D. 1, 2, 3 and 4

  E. 2, 4, 1 and 3

  Correct Answer: E

• Question 55:

  Examine this code: What is the correct statement to get the value of attribute ACCOUNT_MGR after the procedure has been executed?

  

  A. SELECT USERENV (`ACCOUNT_MGR') FROM dual;

  B. SELECT SYS_CONTEXT (`USERENV', `ACCOUNT_MGR') FROM dual;

  C. SELECT SYS_CONTEXT (`ORDER_CTX', `ACCOUNT_MGR') FROM dual;

  D. SELECT SYS_CONTEXT (`ACCOUNT_MGR', `ORDER_CTX') FROM dual;

  E. SELECT USERENV (`ORDER_CTX') FROM dual;

  Correct Answer: B

• Question 56:

  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?

  A. The procedure needs to be granted the DYNAMIC_TABLE_ROLE role.

  B. The EXECUTE IMMEDIATE clause is not supported with roles.

  C. Privileges granted through roles are never in effect when running definer's rights procedures.

  D. The user SPIDER needs to be granted the CREATE TABLE privilege and the procedure needs to be granted the DYNAMIC_TABLE_ROLE.

  Correct Answer: C

• Question 57:

  Which statement is true about the DBMS_PARALLEL_EXECUTE package?

  A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.

  B. To execute chunks in parallel, users must have CREATE JOB system privilege.

  C. No specific system privileges are required to create or run parallel execution tasks.

  D. Only DBAs can create or run parallel execution tasks.

  E. Users with CREATE TASK privilege can create or run parallel execution tasks.

  Correct Answer: B

  Referencehttps://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm#ARPLS67331 (security model)

• Question 58:

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

  A. DBMS_LOB can be used to compress SecureFiles columns.

  B. When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.

  C. If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.

  D. An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).

  E. DBMS_LOB cannot be used for SecureFiles if the initialization parameter db_securefile is set to NEVER.

  Correct Answer: BC

• Question 59:

  Which two blocks of code execute successfully?

  A. DECLARESUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;my_val new_one;BEGINmy_val :=0;END;

  B. DECLARESUBTYPE new_string IS VARCHAR2 (5) NOT NULL;my_str_new_string;BEGINmy_str := `abc';END;

  C. DECLARESUBTYPE new_one IS NUMBER (2, 1);my_val new_one;BEGINmy_val :=12.5;END;

  D. DECLARESUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;my_val new_one;BEGINmy_val :=2;END;

  E. DECLARESUBTYPE new_one IS NUMBER (1, 0);my_val new_one;BEGINmy_val := -1;END;

  Correct Answer: AD

• Question 60:

  Which two statements are correct in Oracle Database 12c?

  A. For native compilation, PLSQL_OPTIMIZE_LEWVEL should be set to 2.

  B. Native compilation is the default compilation method

  C. Native compilation should be used during development.

  D. Natively compiles code is stored in the SYSTEM tablespace.

  E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile it.

  Correct Answer: DE

  Reference: https://www.google.com/url? sa=tandrct=jandq=andesrc=sandsource=webandcd=2andcad=rjaanduact=8andved=0ahUKEwiW92j66rYAhUBORQKHaKOAnsQFggtMAEandurl=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork% 2Fdatabase%2Ffeatures%2Fplsql%2Fncomp-faq-087606.htmlandusg=AOvVaw3H2JhdwNaDzp-Jly5-wtTk