New 2023 Guaranteed Success with Pass4Leader 1Z0-149 Dumps Oracle PDF Questions
Exceptional Practice To Oracle Database 19c: Program with PL/SQL Pass the First Time
NEW QUESTION # 25
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)
- A. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
- B. No update happens even though the procedure executes successfully.
- C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
- D. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
- E. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
Answer: A,C
NEW QUESTION # 26
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
- A. The check is enforced by this clause for direct access and access through dynamic SQL.
- B. It can be used in the declaration of object types.
- C. It must be specified in the heading of a package body.
- D. It can be used for individual procedures and functions declared in a package specification.
- E. It must be specified in the heading of a package specification.
Answer: B,D
Explanation:
https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm
NEW QUESTION # 27
In which type of trigger can :OLD and :NEW identifiers be used?
- A. AFTER STATEMENT
- B. BEFORE STATEMENT
- C. AFTER SUSPEND
- D. ROW
Answer: D
NEW QUESTION # 28
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 29
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. ERROR
- B. SEVERE
- C. ALL
- D. ENABLE
- E. DISABLE
Answer: B,C
NEW QUESTION # 30
Which block of code displays the error message "Incorrect price value"?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 31
Examine this anonymous block of code:
Which two statements are true about the results of executing it? (Choose two.)
- A. It will always automatically initialize v_raise.
- B. It will always return a run time error because v_raise is not initialized.
- C. It will always return a compile time error because it lacks an EXCEPTION section.
- D. It will set all salaries to NULL if it executes successfully.
- E. It will set all salaries to 0 if it executes successfully.
- F. It might return a run time error depending on who invokes it.
Answer: A,D
NEW QUESTION # 32
Which is true about EXIT and CONTINUE statements?
- A. They must use labels.
- B. They must have a WHEN condition.
- C. They can be used in any type of loop.
- D. They have the same effect on the execution of a loop.
Answer: C
NEW QUESTION # 33
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 returns an error in line 4.
- B. It returns an error in line 2.
- C. It returns an error in line 9.
- D. It executes and displays output.
Answer: A
NEW QUESTION # 34
Examine this DECLARE section:
Which two lines are valid? (Choose two.)
- A. line 2
- B. line 5
- C. line 7
- D. line 6
- E. line 4
- F. line 3
Answer: A,B
NEW QUESTION # 35
Which two are true about INDEX-BY tables? (Choose two.)
- A. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
- B. The index can be integer only.
- C. The index can be integer or string.
- D. INDEX-BY table types can be created in PL/SQL blocks only.
- E. INDEX-BY table types can be created with the CREATE TYPE statement.
Answer: C,D
NEW QUESTION # 36
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 37
Examine these statements issued by user SH which execute successfully:
DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:
Which is true about the anonymous block?
- A. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
- B. It will fail at lines 6 and 7.
- C. It will fail only at line 7.
- D. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
Answer: C
NEW QUESTION # 38
Examine these statements:
Which two are true? (Choose two.)
- A. Neither table will have a row inserted and committed.
- B. Only one table will have a row inserted and committed.
- C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
- D. Both tables will have a row inserted and committed.
- E. The bank_activity_proc will not compile because of the commit.
Answer: B,C
NEW QUESTION # 39
Which two are true about implicit data type conversion? (Choose two.)
- A. Comparison between character value and a number value always implicitly converts the character value to the number data type.
- B. Collections can be implicitly converted to records.
- C. Implicit data type conversion can negatively impact performance.
- D. RAW data types are always implicitly converted to a CLOB when used in a query.
- E. ROWIDS are always implicitly converted to a number when used in a query.
Answer: A,C
NEW QUESTION # 40
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 # 41
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: A
NEW QUESTION # 42
Examine these statements and output:
The procedure is created successfully.
User ora2 has password ora2 in pdb1.
Which script will execute successfully?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 43
Examine the structure of the ora1.depts table:
Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:
Which is true?
- A. It will run successfully producing a result of 5.
- B. DEP_VU must be manually recompiled to successfully run this code.
- C. It will run successfully producing a result of 4.
- D. It will result in an error because table depts has been altered.
Answer: C
NEW QUESTION # 44
......
Oracle 1z1-149 exam is designed for individuals who wish to demonstrate their knowledge and skills in programming with PL/SQL in the Oracle Database 19c environment. A passing score on 1Z0-149 exam is required to achieve the Oracle PL/SQL Developer Certified Associate certification. Oracle Database 19c: Program with PL/SQL certification is recognized globally and is highly valued by numerous organizations, making it an excellent addition to any IT professional's resume.
1Z0-149 EXAM DUMPS WITH GUARANTEED SUCCESS: https://testoutce.pass4leader.com/Oracle/1Z0-149-exam.html