[Feb-2024] The Best Oracle Database PL/SQL Developer Certified Professional 1z1-149 Professional Exam Questions
Try 100% Updated 1z1-149 Exam Questions [2024]
NEW QUESTION # 24
Which three are true about functions and procedures? (Choose three.)
- A. In a function every RETURN statement must specify an expression.
- B. The ACCESSIBLE BY clause can be used only for procedures.
- C. Both can be invoked from within SQL statements.
- D. In a function, every execution path must lead to a RETURN statement.
- E. Both can have only constants as actual parameters for IN mode parameters.
- F. In a procedure the RETURN statement cannot specify an expression.
Answer: A,D,F
NEW QUESTION # 25
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. There are no compilation warnings or errors.
- C. An information compilation warning is generated.
- D. A severe compilation warning is generated.
- E. It fails compilation.
Answer: A
NEW QUESTION # 26
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 9.
- D. It returns an error in line 2.
Answer: B
NEW QUESTION # 27
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 28
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
- A. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
- B. %Isopen is always false in Implicit Cursor.
- C. Explicit cursor can return more than one record.
- D. %Isopen is always false in Explicit Cursor.
- E. Implicit cursor returns only one record.
- F. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
- G. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
Answer: B,C,F
NEW QUESTION # 29
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
- A. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
- B. A function is deterministic if it always returns the same result for a specific combination of input values.
- C. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
- D. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
- E. A deterministic function's results always depend on the state of session variables.
- F. The NOCOPY hint asks the compiler to pass the actual parameters by value.
- G. The PARALLEL_ENABLE clause can be specified for a nested function.
Answer: A,B,C
NEW QUESTION # 30
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)
- A. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
- B. Only trailing 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. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
- E. Any optional parameters can be omitted in the invocation call.
Answer: C,E
NEW QUESTION # 31
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 result in an error because table depts has been altered.
- B. It will run successfully producing a result of 5.
- C. DEP_VU must be manually recompiled to successfully run this code.
- D. It will run successfully producing a result of 4.
Answer: D
NEW QUESTION # 32
Which three statements are true about passing parameters to subprograms? (Choose three.)
- A. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
- B. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
- C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
- D. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
- E. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
- F. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
- G. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
Answer: A,C,F
NEW QUESTION # 33
Examine these statements:
Which is true?
- A. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
- B. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.
- C. It will result in a compilation error for protected_proc because calling_proc does not exist.
- D. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
Answer: C
NEW QUESTION # 34
Which statement is true about user-defined records?
- A. The number of fields must match the number of columns in a table.
- B. They can be returned from a function.
- C. Field types must match column types.
- D. Field names must match selected column names.
Answer: A
NEW QUESTION # 35
In which type of trigger can :OLD and :NEW identifiers be used?
- A. BEFORE STATEMENT
- B. AFTER STATEMENT
- C. AFTER SUSPEND
- D. ROW
Answer: D
NEW QUESTION # 36
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 salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
- B. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
- C. No update happens even though the procedure executes successfully.
- D. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
- E. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
Answer: D,E
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
- 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
Answer: D
NEW QUESTION # 38
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)
- A. PL/SQL code can be compiled and executed based on different versions of the operating system.
- B. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
- C. The PL/SQL compiler can conditionally include selected parts of a program.
- D. PL/SQL code can be compiled and executed based on different versions of Oracle.
- E. Conditional compilation is disabled by default.
Answer: C,D
NEW QUESTION # 39
The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)
- A.
- B.
- C.
- D.
- E.
Answer: C,D
NEW QUESTION # 40
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 USERB doesn't have select privilege on USERA.EMP.
- D. It results in an error because Authid Definer is missing from MYPROC.
Answer: B
NEW QUESTION # 41
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. FETCH
- B. OPEN-FOR
- C. DECLARE
- D. INTO
- E. OPEN
- F. WHEN
- G. CLOSE
Answer: A,B,G
NEW QUESTION # 42
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 HR schema.
- B. Call HR.HELPER.H1 from the SH 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: B,C
NEW QUESTION # 43
......
1z1-149 Exam Questions Get Updated [2024] with Correct Answers: https://pass4sure.passtorrent.com/1z1-149-latest-torrent.html