[Dec-2023 Newly Released] 1Z0-149 Dumps for Oracle Database PL/SQL Developer Certified Professional Certified
Updated Verified 1Z0-149 dumps Q&As - 100% Pass
Oracle 1Z0-149 Certification Exam Covers Topics:
1Z0-149 exam dumps cover the following topics of the Oracle 1Z0-149 Certification Exam:
- Managing PL/SQL Cod: 5%
- Using PL/SQL Subprograms: 5%
- Handling Exceptions: 5%
- Creating Functions: 5%
- Using Dynamic SQL: 5%
- Using the PL/SQL Compiler: 5%
- Declaring PL/SQL Variables: 5%
- Managing Dependencies: 5%
- Creating Procedures and Using Parameters: 5%
- Creating Packages: 5%
- Using Explicit Cursor: 5%
- Working with Packages: 5%
- Writing Control Structures: 5%
The Oracle 1Z0-149 exam consists of 80 multiple-choice questions, and candidates have two hours to complete it. The questions are designed to test the candidate's knowledge of PL/SQL fundamentals, program structure, control structures, error handling, and database interaction. Candidates are expected to demonstrate their ability to write efficient PL/SQL code, debug and troubleshoot programs, and optimize performance.
NEW QUESTION # 25
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 1, add the default parameter DEFAULT 2000.
- B. In line 2, change IN OUT mode to IN mode.
- C. In line 2, add the default parameter DEFAULT 2000.
- D. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
- E. In line 1, change IN OUT mode to IN mode.
- F. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
Answer: A,B
NEW QUESTION # 26
For which three SYSTEM EVENTS can triggers be created? (Choose three.)
- A. BEFORE GRANT
- B. AFTER AUDIT
- C. DDL
- D. SHUTDOWN
- E. SERVERERROR
- F. BEFORE ANALYZE
- G. STARTUP
Answer: D,E,G
NEW QUESTION # 27
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 # 28
Examine this code:
What will be the outcome?
- A. It will execute successfully and will display the user-defined error message.
- B. It will result in an error as the range of the error code can only be from "-2000 to -2999."
- C. It will result in an error as the range of the error code can only be from "-1000 to -2000."
- D. It will result in an error as the range of the error code can only be from "-20000 to -20999."
Answer: D
NEW QUESTION # 29
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.API.P1 from the SH schema.
- B. Call HR.HELPER.H1 from the HR schema.
- C. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
- D. Call HR.HELPER.H1 from the SH schema.
- E. Call HR.API.P1 from the HR schema.
Answer: A,D
NEW QUESTION # 30
Which is true about the PLSCOPE_SETTINGS parameter?
- A. It can be used to control execution of specific portions of the PL/SQL code conditionally.
- B. It can be used to control a user's privileges on PL/SQL objects at run time.
- C. It is deprecated in Oracle 12c.
- D. It can be used to obtain information about all identifiers when compiling a procedure.
Answer: D
NEW QUESTION # 31
Sequence S and table PRODUCTS exist in your schema.
Examine the table description:
Now, examine this block of code:
Which two lines each result in a compilation error? (Choose two.)
- A. line 2
- B. line 7
- C. line 1
- D. line 6
- E. line 3
- F. line 8
Answer: C,D
NEW QUESTION # 32
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
- A. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
- B. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
- C. The PARALLEL_ENABLE clause can be specified for a nested function.
- D. The NOCOPY hint asks the compiler to pass the actual parameters by value.
- E. A deterministic function's results always depend on the state of session variables.
- F. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
- G. A function is deterministic if it always returns the same result for a specific combination of input values.
Answer: B,F,G
NEW QUESTION # 33
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 34
Which statement is true about user-defined records?
- A. Field names must match selected column names.
- B. The number of fields must match the number of columns in a table.
- C. They can be returned from a function.
- D. Field types must match column types.
Answer: B
NEW QUESTION # 35
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: C
NEW QUESTION # 36
Which three are true about the procedure overloading feature? (Choose three.)
- A. Each procedure can be a nested subprogram.
- B. Each procedure's formal parameters must differ in name.
- C. Each procedure must use named notation to specify the corresponding actual parameters.
- D. Each procedure can be a packaged subprogram.
- E. Each procedure must use positional notation to specify the corresponding actual parameters.
- F. Each procedure can be a standalone subprogram.
- G. Each procedure's formal parameters can differ in data type or name.
Answer: D,E,G
NEW QUESTION # 37
Examine the EMPLOYEES table structure:
Now, examine this code:
Which statement is true about the result of executing this block?
- A. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
- B. It will return an error at line 2.
- C. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
- D. It will return an error at line 8.
- E. It will return an error at line 3.
Answer: C
NEW QUESTION # 38
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. Only the PRICE column can be updated in the PRODUCTS table.
- B. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
- C. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
- D. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
- E. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
Answer: B,E
NEW QUESTION # 39
Which two are true about exception handling? (Choose two.)
- A. All declared exceptions are raised implicitly by the runtime system.
- B. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- C. Internally defined exceptions can be handled only by the OTHERS exception handler.
- D. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
- E. Predefined exceptions are globally declared in the standard package.
Answer: D,E
NEW QUESTION # 40
Which three are true about DDL triggers? (Choose three.)
- A. They can be fired when a privilege is granted to a user.
- B. They must be created in an enabled state.
- C. They fire only when a DDL statement is executed by the owner of the trigger.
- D. They must be created in a disabled state.
- E. They can be fired when a table is truncated.
- F. They cannot include the WHEN clause.
- G. They can be fired either before or after a DDL statement executes.
Answer: C,E,G
NEW QUESTION # 41
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 # 42
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 # 43
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 Current_User is missing from MYPROC.
- B. It results in an error because USERB doesn't have select privilege on USERA.EMP.
- C. It executes successfully.
- D. It results in an error because Authid Definer is missing from MYPROC.
Answer: C
NEW QUESTION # 44
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 # 45
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 46
Which is true about counter variables in a FOR loop?
- A. It is accessible outside the body of the loop.
- B. It can be modified in the body of the loop.
- C. It must explicitly be declared.
- D. It cannot be NULL.
Answer: D
NEW QUESTION # 47
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 # 48
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- B. The default value is NATIVE.
- C. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- D. If set to NATIVE, programs are stored in platform dependent machine code.
- E. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
Answer: D,E
NEW QUESTION # 49
......
Latest 1Z0-149 Exam Dumps Oracle Exam from Training: https://protechtraining.actualtestsit.com/Oracle/1Z0-149-exam-prep-dumps.html