Try 1Z0-149 Free Now! Real Exam Question Answers Updated [Mar 12, 2024]
Get Ready to Pass the 1Z0-149 exam with Oracle Latest Practice Exam
Oracle 1z1-149 certification exam consists of multiple-choice questions that measure the candidate's knowledge of PL/SQL programming, database design, and SQL. 1Z0-149 exam also includes performance-based questions that assess the candidate's ability to create and deploy PL/SQL programs. The Oracle 1z1-149 certification exam is a proctored exam that is administered by Pearson VUE. Candidates who pass the exam will receive the Oracle 1z1-149 certification, which is a valuable credential that can help them advance in their careers.
NEW QUESTION # 28
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
- B. Error in inner block Error in calling block
- C. Error in inner block Error in outer block Error in calling block
- D. Error in inner block Error in outer block
Answer: A
NEW QUESTION # 29
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 3
- B. line 7
- C. line 6
- D. line 2
- E. line 1
- F. line 8
Answer: C,E
NEW QUESTION # 30
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 executes successfully.
- C. It results in an error because Authid Definer is missing from MYPROC.
- D. It results in an error because USERB doesn't have select privilege on USERA.EMP.
Answer: B
NEW QUESTION # 31
Which three are true about PL/SQL subprograms? (Choose three.)
- A. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- B. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
- C. A PL/SQL procedure can invoke an external code block written in a different programming language.
- D. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
- E. 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.
- F. Host variables can be referenced inside any PL/SQL subprogram.
- G. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
Answer: C,D,G
NEW QUESTION # 32
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. ENABLE
- B. ERROR
- C. DISABLE
- D. SEVERE
- E. ALL
Answer: D,E
NEW QUESTION # 33
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 3
- B. line 6
- C. line 2
- D. line 4
- E. line 5
Answer: B
NEW QUESTION # 34
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: D
NEW QUESTION # 35
Which two are true about packages? (Choose two.)
- A. Package specifications can be compiled without their bodies.
- B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
- C. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
- D. A package definition must have a specification and body.
- E. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
Answer: A,E
NEW QUESTION # 36
Which two are true about exception handling? (Choose two.)
- A. Internally defined exceptions can be handled only by the OTHERS exception handler.
- B. All declared exceptions are raised implicitly by the runtime system.
- C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
- D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- E. Predefined exceptions are globally declared in the standard package.
Answer: C,E
NEW QUESTION # 37
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: A
NEW QUESTION # 38
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. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
- B. Call HR.API.P1 from the HR schema.
- C. Call HR.HELPER.H1 from the SH schema.
- D. Call HR.HELPER.H1 from the HR schema.
- E. Call HR.API.P1 from the SH schema.
Answer: C,E
NEW QUESTION # 39
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 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
- B. In line 1, add the default parameter DEFAULT 2000.
- C. In line 2, change IN OUT mode to IN mode.
- D. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
- E. In line 1, change IN OUT mode to IN mode.
- F. In line 2, add the default parameter DEFAULT 2000.
Answer: B,C
NEW QUESTION # 40
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. Only associative arrays and nested tables can have elements of RECORD type.
- C. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
- D. A variable of RECORD type can contain fields of another RECORD type or any collection type.
- E. All collections and RECORD types can be stored in table columns.
- F. Collections and RECORD types are always dense.
Answer: A,B
NEW QUESTION # 41
Examine this anonymous block of code:
Which two statements are true about the results of executing it? (Choose two.)
- A. It will set all salaries to NULL if it executes successfully.
- B. It will always automatically initialize v_raise.
- C. It will set all salaries to 0 if it executes successfully.
- D. It will always return a run time error because v_raise is not initialized.
- E. It will always return a compile time error because it lacks an EXCEPTION section.
- F. It might return a run time error depending on who invokes it.
Answer: A,B
NEW QUESTION # 42
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. ROWIDS are always implicitly converted to a number when used in a query.
- C. RAW data types are always implicitly converted to a CLOB when used in a query.
- D. Collections can be implicitly converted to records.
- E. Implicit data type conversion can negatively impact performance.
Answer: A,E
NEW QUESTION # 43
Which is the correct method to implement a local subprogram in an anonymous block?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 44
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 must be regranted to those users who had the privilege.
- B. Function based indexes remain usable when replacing the function on which the index depends.
- C. This clause can be used only for procedures and functions.
- D. Object privileges to execute a replaced function are retained by those users who had the privileges.
- E. A function definition can be modified without dropping and re-creating it.
Answer: D,E
NEW QUESTION # 45
Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)
- A. a record declared in a package specification
- B. a predefined PL/SQL-only data type like BOOLEAN
- C. a record declared in an anonymous block
- D. an associative array indexed by VARCHAR2
- E. an associative array indexed by PLS_INTEGER
- F. a record declared in a procedure
Answer: A,D,E
NEW QUESTION # 46
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
- B. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
- C. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
- D. Only the PRICE column can be updated 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: C,E
NEW QUESTION # 47
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. DECLARE
- B. WHEN
- C. FETCH
- D. OPEN-FOR
- E. OPEN
- F. CLOSE
- G. INTO
Answer: C,D,F
NEW QUESTION # 48
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 49
Examine this DECLARE section:
Which two lines are valid? (Choose two.)
- A. line 3
- B. line 2
- C. line 6
- D. line 7
- E. line 5
- F. line 4
Answer: B,E
NEW QUESTION # 50
Examine the EMPLOYEES table structure:
Now, examine this code:
Which statement is true about the result of executing this block?
- A. It will return an error at line 3.
- 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 execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
Answer: C
NEW QUESTION # 51
In which type of trigger can :OLD and :NEW identifiers be used?
- A. BEFORE STATEMENT
- B. ROW
- C. AFTER SUSPEND
- D. AFTER STATEMENT
Answer: B
NEW QUESTION # 52
......
Oracle 1z1-149 exam tests the candidate's knowledge and skills in various areas of PL/SQL programming, including program design and implementation, error handling, and performance tuning. Successful candidates will demonstrate their ability to write efficient and effective PL/SQL code, design solutions that meet business requirements, and troubleshoot common PL/SQL errors. Certification in Oracle Database 19c: Program with PL/SQL is a valuable asset for professionals who want to advance their careers in database development and administration.
Pass Your Next 1Z0-149 Certification Exam Easily & Hassle Free: https://www.actual4labs.com/Oracle/1Z0-149-actual-exam-dumps.html
Get Prepared for Your 1Z0-149 Exam With Actual Oracle Study Guide!: https://drive.google.com/open?id=1sphdaRKbGgmDUHEPRHWdS-f0uUzi8xZM