[Nov 12, 2023] Lesson Brilliant PDF for the 1Z0-149 Tests Free Updated Today
Get New 2023 Valid Practice Oracle Database PL/SQL Developer Certified Professional 1Z0-149 Q&A - Testing Engine
NEW QUESTION # 22
Which three are true about PL/SQL subprograms? (Choose three.)
- A. A PL/SQL procedure can invoke an external code block written in a different programming language.
- B. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
- C. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
- D. Host variables can be referenced inside any PL/SQL subprogram.
- E. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- F. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
- G. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
Answer: A,C,G
NEW QUESTION # 23
Examine the SH.PRODUCTS table:
A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:
Now, examine this block of code:
Which error message(s) does it display on execution by user SH?
- A. Error in inner block Error in calling block
- B. Error in inner block
- C. Error in inner block Error in outer block Error in calling block
- D. Error in inner block Error in outer block
Answer: B
NEW QUESTION # 24
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. DROP
- B. INSERT
- C. UPDATE
- D. SELECT
- E. CREATE
- F. DELETE
- G. ALTER
Answer: B,C,D
NEW QUESTION # 25
Examine this table in the SH schema:
User SH executes this code:
The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?
- A.
- B.
- C.
- D.
- E.
Answer: A
NEW QUESTION # 26
Examine this table definition in the SH schema.
A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)
- A.
- B.
- C.
- D.
Answer: B,D
NEW QUESTION # 27
Which three are true about functions and procedures? (Choose three.)
- A. Both can be invoked from within SQL statements.
- B. In a function, every execution path must lead to a RETURN statement.
- C. Both can have only constants as actual parameters for IN mode parameters.
- D. The ACCESSIBLE BY clause can be used only for procedures.
- E. In a function every RETURN statement must specify an expression.
- F. In a procedure the RETURN statement cannot specify an expression.
Answer: B,E,F
NEW QUESTION # 28
Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:
What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?
- A. A severe compilation warning is generated.
- B. A performance compilation warning is generated.
- C. An information compilation warning is generated.
- D. It fails compilation.
- E. There are no compilation warnings or errors.
Answer: B
NEW QUESTION # 29
Examine this table in the SH schema:
Now, examine this code:
Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)
- A. In line 2, change IN OUT mode to IN mode.
- B. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
- C. In line 1, add the default parameter DEFAULT 2000.
- D. In line 1, change IN OUT mode to IN mode.
- E. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
- F. In line 2, add the default parameter DEFAULT 2000.
Answer: A,C
NEW QUESTION # 30
Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:
What is true about the result?
- A. It executes and displays output.
- B. It returns an error in line 4.
- C. It returns an error in line 9.
- D. It returns an error in line 2.
Answer: B
NEW QUESTION # 31
Which three are true regarding code based access control (CBAC)? (Choose three.)
- A. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
- B. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
- C. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
- D. CBAC cannot be used to secure definer's rights.
- E. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
- F. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
- G. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
Answer: A,B,G
NEW QUESTION # 32
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
- A. The NOCOPY hint asks the compiler to pass the actual parameters by value.
- B. The PARALLEL_ENABLE clause can be specified for a nested function.
- C. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
- D. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
- E. A deterministic function's results always depend on the state of session variables.
- F. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
- G. A function is deterministic if it always returns the same result for a specific combination of input values.
Answer: D,F,G
NEW QUESTION # 33
Examine these statements:
Which two are true? (Choose two.)
- A. Only one table will have a row inserted and committed.
- B. Both tables will have a row inserted and committed.
- C. Neither table will have a row inserted and committed.
- D. The bank_activity_proc will not compile because of the commit.
- E. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
Answer: A,E
NEW QUESTION # 34
Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
- A. This program unit will compile successfully.
- B. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
- C. This will not compile successfully because the min_bal constant must be initialized.
- D. Initialization of min_bal can be done while using this packaged constant in another program.
- E. Initialization of loan_amount can be done while using this packaged variable in another program.
- F. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
- G. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
Answer: C,F,G
NEW QUESTION # 35
In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:
EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)
- A. Call HR.HELPER.H1 from the HR schema.
- B. Call HR.API.P1 from the SH schema.
- C. Call HR.HELPER.H1 from the SH schema.
- D. Call HR.API.P1 from the HR schema.
- E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
Answer: B,C
NEW QUESTION # 36
Which three are true about the procedure overloading feature? (Choose three.)
- A. Each procedure must use positional notation to specify the corresponding actual parameters.
- B. Each procedure can be a nested subprogram.
- C. Each procedure's formal parameters must differ in name.
- D. Each procedure can be a packaged subprogram.
- E. Each procedure can be a standalone subprogram.
- F. Each procedure must use named notation to specify the corresponding actual parameters.
- G. Each procedure's formal parameters can differ in data type or name.
Answer: A,D,G
NEW QUESTION # 37
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- B. The default value is NATIVE.
- C. If set to NATIVE, programs are stored in platform dependent machine code.
- D. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- E. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
Answer: C,E
NEW QUESTION # 38
......
Oracle 1z1-149 exam is designed to test your knowledge and skills in the area of programming with PL/SQL using Oracle Database 19c. As one of the most popular database management systems, Oracle is widely used in various industries, and proficiency in programming with PL/SQL has become a valuable skill in the IT job market.
1Z0-149 Dumps PDF - 100% Passing Guarantee: https://examsboost.realexamfree.com/1Z0-149-real-exam-dumps.html
