Give You Free Regular Updates on 1Z0-149 Exam Questions Jan 20, 2024
Achieve the 1Z0-149 Exam Best Results with Help from Oracle Certified Experts
NEW QUESTION # 20
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: E
NEW QUESTION # 21
Which block of code displays the error message "Incorrect price value"?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 22
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 "-1000 to -2000."
- C. It will result in an error as the range of the error code can only be from "-20000 to -20999."
- D. It will result in an error as the range of the error code can only be from "-2000 to -2999."
Answer: C
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
- B. Error in inner block Error in outer block Error in calling block
- C. Error in inner block Error in outer block
- D. Error in inner block Error in calling block
Answer: A
NEW QUESTION # 24
Which three are true about DDL triggers? (Choose three.)
- A. They cannot include the WHEN clause.
- B. They fire only when a DDL statement is executed by the owner of the trigger.
- C. They must be created in a disabled state.
- D. They can be fired when a privilege is granted to a user.
- E. They must be created in an enabled state.
- F. They can be fired when a table is truncated.
- G. They can be fired either before or after a DDL statement executes.
Answer: B,F,G
NEW QUESTION # 25
In which type of trigger can :OLD and :NEW identifiers be used?
- A. BEFORE STATEMENT
- B. AFTER STATEMENT
- C. ROW
- D. AFTER SUSPEND
Answer: C
NEW QUESTION # 26
Which three are true about functions and procedures? (Choose three.)
- A. In a function, every execution path must lead to a RETURN statement.
- B. Both can be invoked from within SQL statements.
- C. Both can have only constants as actual parameters for IN mode parameters.
- D. In a function every RETURN statement must specify an expression.
- E. In a procedure the RETURN statement cannot specify an expression.
- F. The ACCESSIBLE BY clause can be used only for procedures.
Answer: A,D,E
NEW QUESTION # 27
Which statement is true about user-defined records?
- A. Field types must match column types.
- B. The number of fields must match the number of columns in a table.
- C. They can be returned from a function.
- D. Field names must match selected column names.
Answer: B
NEW QUESTION # 28
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 an anonymous block
- B. an associative array indexed by PLS_INTEGER
- C. a record declared in a package specification
- D. a record declared in a procedure
- E. a predefined PL/SQL-only data type like BOOLEAN
- F. an associative array indexed by VARCHAR2
Answer: B,C,F
NEW QUESTION # 29
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. This clause can be used only for procedures and functions.
- C. A function definition can be modified without dropping and re-creating it.
- D. Function based indexes remain usable when replacing the function on which the index depends.
- E. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
Answer: A,C
NEW QUESTION # 30
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. UPDATE
- B. SELECT
- C. DELETE
- D. ALTER
- E. DROP
- F. INSERT
- G. CREATE
Answer: A,B,F
NEW QUESTION # 31
Which three statements are true about passing parameters to subprograms? (Choose three.)
- A. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
- B. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
- C. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
- D. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
- E. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
- F. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
- G. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
Answer: A,D,F
NEW QUESTION # 32
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 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
- C. In line 2, change IN OUT mode to IN mode.
- D. In line 1, change IN OUT mode to IN mode.
- E. In line 2, add the default parameter DEFAULT 2000.
- F. In line 1, add the default parameter DEFAULT 2000.
Answer: C,F
NEW QUESTION # 33
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 3
- B. line 2
- C. line 4
- D. line 5
- E. line 6
Answer: E
NEW QUESTION # 34
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)
- A. PACKAGES
- B. VARIABLES
- C. TRIGGER BODY
- D. DATABASE LINKS
- E. ANONYMOUS BLOCK
Answer: A,D
NEW QUESTION # 35
Which is true about EXIT and CONTINUE statements?
- A. They must use labels.
- B. They can be used in any type of loop.
- C. They have the same effect on the execution of a loop.
- D. They must have a WHEN condition.
Answer: B
NEW QUESTION # 36
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 4.
- B. DEP_VU must be manually recompiled to successfully run this code.
- C. It will result in an error because table depts has been altered.
- D. It will run successfully producing a result of 5.
Answer: A
NEW QUESTION # 37
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 2.
- C. It returns an error in line 4.
- D. It returns an error in line 9.
Answer: C
NEW QUESTION # 38
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. There are no compilation warnings or errors.
- D. An information compilation warning is generated.
- E. It fails compilation.
Answer: B
NEW QUESTION # 39
......
Oracle 1z1-149 exam is an essential certification for professionals who work with Oracle Database 19c and want to advance their careers in database programming. 1Z0-149 exam is suitable for developers, database administrators, and IT professionals who want to demonstrate their expertise in PL/SQL programming in Oracle Database 19c. Passing 1Z0-149 exam demonstrates a high level of skill and knowledge in PL/SQL programming and can help professionals stand out in a competitive job market.
Detailed New 1Z0-149 Exam Questions for Concept Clearance: https://www.itpass4sure.com/1Z0-149-practice-exam.html
Provide 1Z0-149 Practice Test Engine for Preparation: https://drive.google.com/open?id=1d0RBBNFCqRgVyMLlwKYS0es_Y72F0i4s
