Prepare Top Oracle 1Z0-149 Exam Study Guide Practice Questions Edition
Go to 1Z0-149 Questions - Try 1Z0-149 dumps pdf
The Oracle 1z1-149 (Oracle Database 19c: Program with PL/SQL) Certification Exam is a highly sought-after certification exam for those who work with Oracle Database 19c and are interested in becoming experts in programming with PL/SQL. This exam is designed to test the knowledge and skills of professionals who work with this database technology and are interested in advancing their careers in this field.
NEW QUESTION # 40
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING INTO clause returns column values for rows affected by DML statements.
- B. When using the RETURNING INTO clause, the data returned can be only single column or expression.
- C. The RETURNING clause can be used for remote or parallel deletes.
- D. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- E. The RETURNING INTO clause and bulk binds may not be used together.
Answer: C,D
NEW QUESTION # 41
Examine this row of data from the EMPLOYEES table:
Now, examine this block of code which executes successfully:
What is the value of v_commission?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 42
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
- A. It must be specified in the heading of a package body.
- B. It can be used in the declaration of object types.
- C. It must be specified in the heading of a package specification.
- D. It can be used for individual procedures and functions declared in a package specification.
- E. The check is enforced by this clause for direct access and access through dynamic SQL.
Answer: B,D
Explanation:
https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm
NEW QUESTION # 43
Which three are true about functions and procedures? (Choose three.)
- A. Both can be invoked from within SQL statements.
- B. In a procedure the RETURN statement cannot specify an expression.
- C. In a function, every execution path must lead to a RETURN statement.
- D. Both can have only constants as actual parameters for IN mode parameters.
- E. In a function every RETURN statement must specify an expression.
- F. The ACCESSIBLE BY clause can be used only for procedures.
Answer: B,C,E
NEW QUESTION # 44
Which three are true about the procedure overloading feature? (Choose three.)
- A. Each procedure's formal parameters must differ in name.
- B. Each procedure can be a nested subprogram.
- C. Each procedure can be a standalone subprogram.
- D. Each procedure can be a packaged subprogram.
- E. Each procedure must use named notation to specify the corresponding actual parameters.
- F. Each procedure must use positional notation to specify the corresponding actual parameters.
- G. Each procedure's formal parameters can differ in data type or name.
Answer: D,F,G
NEW QUESTION # 45
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 SH schema.
- B. Call HR.API.P1 from the HR schema.
- C. Call HR.API.P1 from the SH schema.
- D. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
- E. Call HR.HELPER.H1 from the HR schema.
Answer: A,C
NEW QUESTION # 46
Examine this anonymous block of code:
Which two statements are true about the results of executing it? (Choose two.)
- A. It might return a run time error depending on who invokes it.
- B. It will always return a run time error because v_raise is not initialized.
- C. It will set all salaries to NULL if it executes successfully.
- D. It will always return a compile time error because it lacks an EXCEPTION section.
- E. It will always automatically initialize v_raise.
- F. It will set all salaries to 0 if it executes successfully.
Answer: C,E
NEW QUESTION # 47
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 48
Which block of code displays the error message "Incorrect price value"?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 49
Which is true about EXIT and CONTINUE statements?
- A. They must have a WHEN condition.
- B. They must use labels.
- 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 # 50
Which two are true about collections and RECORD types? (Choose two.)
- A. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
- B. Collections and RECORD types are always dense.
- C. All collections and RECORD types can be stored in table columns.
- D. Only associative arrays and nested tables can have elements of RECORD type.
- E. A variable of RECORD type can contain fields of another RECORD type or any collection type.
- F. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
Answer: A,D
NEW QUESTION # 51
Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
- A. Initialization of min_bal can be done while using this packaged constant in another program.
- B. This will not compile successfully because the min_bal constant must be initialized.
- C. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
- D. This program unit will compile successfully.
- E. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
- F. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
- G. Initialization of loan_amount can be done while using this packaged variable in another program.
Answer: B,E,F
NEW QUESTION # 52
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. There are no compilation warnings or errors.
- B. A severe compilation warning is generated.
- C. A performance compilation warning is generated.
- D. It fails compilation.
- E. An information compilation warning is generated.
Answer: C
NEW QUESTION # 53
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. DISABLE
- B. ENABLE
- C. SEVERE
- D. ERROR
- E. ALL
Answer: C,E
NEW QUESTION # 54
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 55
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 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
- B. In line 1, add the default parameter DEFAULT 2000.
- C. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
- D. In line 2, change IN OUT mode to IN mode.
- E. In line 1, change IN OUT mode to IN mode.
- F. In line 2, add the default parameter DEFAULT 2000.
Answer: B,D
NEW QUESTION # 56
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 2
- B. line 5
- C. line 4
- D. line 6
- E. line 3
Answer: D
NEW QUESTION # 57
Which two are true about packages? (Choose two.)
- A. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
- B. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
- C. Package specifications can be compiled without their bodies.
- D. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
- E. A package definition must have a specification and body.
Answer: C,D
NEW QUESTION # 58
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 # 59
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 2.
- D. It returns an error in line 9.
Answer: B
NEW QUESTION # 60
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
- A. Object privileges to execute a replaced function are retained by those users who had the privileges.
- B. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
- C. A function definition can be modified without dropping and re-creating it.
- D. This clause can be used only for procedures and functions.
- E. Function based indexes remain usable when replacing the function on which the index depends.
Answer: A,C
NEW QUESTION # 61
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:
USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?
- A. It results in an error because Authid Definer is missing from MYPROC.
- B. It results in an error because Authid Current_User is missing from MYPROC.
- C. It executes successfully.
- D. It results in an error because USERB doesn't have select privilege on USERA.EMP.
Answer: C
NEW QUESTION # 62
......
To prepare for the Oracle 1z1-149 certification exam, candidates should have hands-on experience in developing PL/SQL programs in Oracle Database 19c. Oracle provides a range of training courses, practice exams, and study materials to help candidates prepare for the exam. Candidates may also benefit from joining online communities and forums to connect with other professionals and share knowledge and best practices. Passing the Oracle 1z1-149 certification exam demonstrates a candidate's proficiency in PL/SQL programming and can enhance their career prospects in the field of database development and administration.
Free Oracle Database PL/SQL Developer Certified Professional 1Z0-149 Exam Question: https://www.verifieddumps.com/1Z0-149-valid-exam-braindumps.html
Dumps Practice Exam Questions Study Guide for the 1Z0-149 Exam: https://drive.google.com/open?id=1jYqtt_OYvYWU4aPdokZZ9_nYZPWg0DdA
