A Fully Updated 2023 1z1-149 Exam Dumps - PDF Questions and Testing Engine
Easy Success Oracle 1z1-149 Exam in First Try
NEW QUESTION # 19
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 performance compilation warning is generated.
- B. A severe compilation warning is generated.
- C. There are no compilation warnings or errors.
- D. An information compilation warning is generated.
- E. It fails compilation.
Answer: A
NEW QUESTION # 20
Which three are true about anonymous blocks and subprograms? (Choose three.)
- A. Anonymous blocks cannot use packaged variables.
- B. Named subprograms cannot be called from other packages.
- C. Named subprograms are stored in the database server.
- D. PROCEDURE subprograms can accept parameters.
- E. A FUNCTION subprogram must return one or more values.
- F. FUNCTION subprograms must be called and passed through one or more parameters.
- G. Anonymous blocks must always start with the Declare keyword.
Answer: C,D,E
NEW QUESTION # 21
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 # 22
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. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
- 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. The default value is NATIVE.
Answer: B,D
NEW QUESTION # 23
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)
- A. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
- B. Any optional parameters can be omitted in the invocation call.
- C. The actual parameters must be specified in the same order as the formal parameters are declared.
- D. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
- E. Only trailing optional parameters can be omitted in the invocation call.
Answer: B,C
NEW QUESTION # 24
Which is the correct method to implement a local subprogram in an anonymous block?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 25
Which is true about counter variables in a FOR loop?
- A. It cannot be NULL.
- B. It can be modified in the body of the loop.
- C. It must explicitly be declared.
- D. It is accessible outside the body of the loop.
Answer: A
NEW QUESTION # 26
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. It will result in an error because table depts has been altered.
- C. It will run successfully producing a result of 5.
- D. DEP_VU must be manually recompiled to successfully run this code.
Answer: A
NEW QUESTION # 27
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: A,D
NEW QUESTION # 28
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 3
- B. line 4
- C. line 5
- D. line 2
- E. line 6
Answer: E
NEW QUESTION # 29
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
- A. Explicit cursor can return more than one record.
- B. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
- C. %Isopen is always false in Explicit Cursor.
- D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
- E. Implicit cursor returns only one record.
- F. %Isopen is always false in Implicit Cursor.
- G. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
Answer: A,B,F
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 USERB doesn't have select privilege on USERA.EMP.
- B. It results in an error because Authid Definer is missing from MYPROC.
- C. It executes successfully.
- D. It results in an error because Authid Current_User is missing from MYPROC.
Answer: C
NEW QUESTION # 31
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING INTO clause and bulk binds may not be used together.
- B. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- C. The RETURNING clause can be used for remote or parallel deletes.
- D. The RETURNING INTO clause returns column values for rows affected by DML statements.
- E. When using the RETURNING INTO clause, the data returned can be only single column or expression.
Answer: B,C
NEW QUESTION # 32
In which type of trigger can :OLD and :NEW identifiers be used?
- A. BEFORE STATEMENT
- B. AFTER SUSPEND
- C. AFTER STATEMENT
- D. ROW
Answer: D
NEW QUESTION # 33
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. UPDATE
- B. CREATE
- C. DROP
- D. DELETE
- E. INSERT
- F. ALTER
- G. SELECT
Answer: A,E,G
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: A
NEW QUESTION # 35
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 9.
- B. It returns an error in line 2.
- C. It executes and displays output.
- D. It returns an error in line 4.
Answer: D
NEW QUESTION # 36
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 37
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 outer block Error in calling block
- B. Error in inner block
- C. Error in inner block Error in calling block
- D. Error in inner block Error in outer block
Answer: B
NEW QUESTION # 38
Examine this anonymous block of code:
Which two statements are true about the results of executing it? (Choose two.)
- A. It will always return a compile time error because it lacks an EXCEPTION section.
- B. It will always return a run time error because v_raise is not initialized.
- C. It will set all salaries to 0 if it executes successfully.
- D. It might return a run time error depending on who invokes it.
- E. It will always automatically initialize v_raise.
- F. It will set all salaries to NULL if it executes successfully.
Answer: E,F
NEW QUESTION # 39
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 40
Examine this code:
What will be the outcome?
- A. It will result in an error as the range of the error code can only be from "-20000 to -20999."
- 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 execute successfully and will display the user-defined error message.
Answer: A
NEW QUESTION # 41
Which block of code displays the error message "Incorrect price value"?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 42
......
Oracle 1z1-149 is a certification exam that tests the proficiency of the candidates in programming with PL/SQL in Oracle Database 19c. 1z1-149 exam is intended for developers who have experience in using PL/SQL to develop database applications. It is also suitable for individuals who are seeking to enhance their knowledge and skills in PL/SQL programming.
1z1-149 Study Material, Preparation Guide and PDF Download: https://www.verifieddumps.com/1z1-149-valid-exam-braindumps.html
