Prepare For Realistic 1z1-149 Dumps PDF - 100% Passing Guarantee
Check the Available 1z1-149 Exam Dumps with 67 Q's
Oracle 1z1-149 exam is a valuable certification for individuals looking to enhance their skills in PL/SQL programming. It covers a range of topics and requires a combination of study and practical experience to prepare for. Passing 1z1-149 exam can help advance your career and increase your earning potential in the field of database programming.
NEW QUESTION # 39
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. The NOCOPY hint asks the compiler to pass the actual parameters by value.
- C. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
- D. A function is deterministic if it always returns the same result for a specific combination of input values.
- 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. The PARALLEL_ENABLE clause can be specified for a nested function.
Answer: A,D,F
NEW QUESTION # 40
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
- A. It can be used in the declaration of object types.
- B. The check is enforced by this clause for direct access and access through dynamic SQL.
- C. It can be used for individual procedures and functions declared in a package specification.
- D. It must be specified in the heading of a package specification.
- E. It must be specified in the heading of a package body.
Answer: A,C
Explanation:
https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm
NEW QUESTION # 41
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. An information compilation warning is generated.
- D. It fails compilation.
- E. There are no compilation warnings or errors.
Answer: B
NEW QUESTION # 42
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 2
- B. line 6
- C. line 3
- D. line 5
- E. line 4
Answer: B
NEW QUESTION # 43
Examine these statements issued by user SH which execute successfully:
DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:
Which is true about the anonymous block?
- A. It will fail only at line 7.
- B. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
- C. It will fail at lines 6 and 7.
- D. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
Answer: A
NEW QUESTION # 44
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 results in an error because Authid Current_User is missing from MYPROC.
- D. It executes successfully.
Answer: D
NEW QUESTION # 45
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 46
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: D
NEW QUESTION # 47
Examine this DECLARE section:
Which two lines are valid? (Choose two.)
- A. line 6
- B. line 2
- C. line 7
- D. line 5
- E. line 3
- F. line 4
Answer: B,D
NEW QUESTION # 48
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. ALL
- B. SEVERE
- C. ENABLE
- D. DISABLE
- E. ERROR
Answer: A,B
NEW QUESTION # 49
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. No update happens even though the procedure executes successfully.
- C. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
- 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 # 50
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 returns an error in line 4.
- D. It executes and displays output.
Answer: C
NEW QUESTION # 51
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 procedure
- B. a predefined PL/SQL-only data type like BOOLEAN
- C. an associative array indexed by PLS_INTEGER
- D. an associative array indexed by VARCHAR2
- E. a record declared in an anonymous block
- F. a record declared in a package specification
Answer: C,D,F
NEW QUESTION # 52
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 "-1000 to -2000."
- C. It will execute successfully and will display the user-defined error message.
- D. It will result in an error as the range of the error code can only be from "-2000 to -2999."
Answer: A
NEW QUESTION # 53
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. Predefined exceptions are globally declared in the standard package.
- D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- E. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
Answer: C,E
NEW QUESTION # 54
Which is true about counter variables in a FOR loop?
- A. It can be modified in the body of the loop.
- B. It cannot be NULL.
- C. It is accessible outside the body of the loop.
- D. It must explicitly be declared.
Answer: B
NEW QUESTION # 55
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. SELECT
- B. CREATE
- C. ALTER
- D. DELETE
- E. UPDATE
- F. INSERT
- G. DROP
Answer: A,E,F
NEW QUESTION # 56
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
- B. If set to NATIVE, programs are stored in platform dependent machine code.
- C. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- D. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- E. The default value is NATIVE.
Answer: A,B
NEW QUESTION # 57
......
Download 1z1-149 Exam Dumps Questions to get 100% Success: https://braindumpsschool.vce4plus.com/Oracle/1z1-149-valid-vce-dumps.html