[2024] Pass Oracle 1z1-149 Premium Files Test Engine pdf - Free Dumps Collection
New 2024 Realistic 1z1-149 Dumps Test Engine Exam Questions in here
NEW QUESTION # 35
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 return a run time error because v_raise is not initialized.
- C. It will always return a compile time error because it lacks an EXCEPTION section.
- D. It might return a run time error depending on who invokes it.
- E. It will set all salaries to 0 if it executes successfully.
- F. It will always automatically initialize v_raise.
Answer: A,F
NEW QUESTION # 36
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 7
- B. line 2
- C. line 8
- D. line 3
- E. line 6
- F. line 1
Answer: E,F
NEW QUESTION # 37
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 "-20000 to -20999."
- C. It will result in an error as the range of the error code can only be from "-2000 to -2999."
- D. It will result in an error as the range of the error code can only be from "-1000 to -2000."
Answer: B
NEW QUESTION # 38
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. an associative array indexed by VARCHAR2
- C. an associative array indexed by PLS_INTEGER
- D. a record declared in an anonymous block
- E. a record declared in a package specification
- F. a predefined PL/SQL-only data type like BOOLEAN
Answer: B,C,E
NEW QUESTION # 39
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?
- A.
- B.
- C.
- D.
Answer: D
NEW QUESTION # 40
Which three are true about functions and procedures? (Choose three.)
- A. In a procedure the RETURN statement cannot specify an expression.
- B. In a function every RETURN statement must specify an expression.
- C. The ACCESSIBLE BY clause can be used only for procedures.
- D. Both can be invoked from within SQL statements.
- E. Both can have only constants as actual parameters for IN mode parameters.
- F. In a function, every execution path must lead to a RETURN statement.
Answer: A,B,F
NEW QUESTION # 41
Which statement is true about user-defined records?
- A. They can be returned from a function.
- B. The number of fields must match the number of columns in a table.
- C. Field types must match column types.
- D. Field names must match selected column names.
Answer: B
NEW QUESTION # 42
Which is true about the PLSCOPE_SETTINGS parameter?
- A. It can be used to control execution of specific portions of the PL/SQL code conditionally.
- B. It can be used to control a user's privileges on PL/SQL objects at run time.
- C. It can be used to obtain information about all identifiers when compiling a procedure.
- D. It is deprecated in Oracle 12c.
Answer: C
NEW QUESTION # 43
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
- A. DELETE
- B. UPDATE
- C. DROP
- D. INSERT
- E. SELECT
- F. ALTER
- G. CREATE
Answer: B,D,E
NEW QUESTION # 44
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 45
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: A,D
NEW QUESTION # 46
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
- A. This clause can be used only for procedures and functions.
- B. Function based indexes remain usable when replacing the function on which the index depends.
- C. Object privileges to execute a replaced function are retained by those users who had the privileges.
- D. A function definition can be modified without dropping and re-creating it.
- E. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
Answer: C,D
NEW QUESTION # 47
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)
- A. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
- B. The PL/SQL compiler can conditionally include selected parts of a program.
- C. PL/SQL code can be compiled and executed based on different versions of Oracle.
- D. PL/SQL code can be compiled and executed based on different versions of the operating system.
- E. Conditional compilation is disabled by default.
Answer: B,C
NEW QUESTION # 48
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. FETCH
- B. OPEN-FOR
- C. DECLARE
- D. WHEN
- E. INTO
- F. OPEN
- G. CLOSE
Answer: A,B,G
NEW QUESTION # 49
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 2
- B. line 4
- C. line 5
- D. line 3
- E. line 6
Answer: E
NEW QUESTION # 50
Which is true about counter variables in a FOR loop?
- A. It must explicitly be declared.
- B. It cannot be NULL.
- C. It is accessible outside the body of the loop.
- D. It can be modified in the body of the loop.
Answer: B
NEW QUESTION # 51
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- B. The RETURNING INTO clause returns column values for rows affected by DML statements.
- C. The RETURNING INTO clause and bulk binds may not be used together.
- D. When using the RETURNING INTO clause, the data returned can be only single column or expression.
- E. The RETURNING clause can be used for remote or parallel deletes.
Answer: A,E
NEW QUESTION # 52
Which block of code displays the error message "Incorrect price value"?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 53
......
Updated Official licence for 1z1-149 Certified by 1z1-149 Dumps PDF: https://www.briandumpsprep.com/1z1-149-prep-exam-braindumps.html
Newly Released 1z1-149 Dumps for Oracle Database PL/SQL Developer Certified Professional Certified: https://drive.google.com/open?id=1Y1wpN3rVXyyp58qOBaj959VM0L2hkV6R
