[Jan-2024] Oracle Database PL/SQL Developer Certified Professional 1z1-149 Exam Practice Test Questions Dumps Bundle! [Q19-Q35]

[Jan-2024] Oracle Database PL/SQL Developer Certified Professional 1z1-149 Exam Practice Test Questions Dumps Bundle!

2024 Updated 1z1-149 PDF for the 1z1-149 Tests Free Updated Today!

NEW QUESTION # 19
Which two are true about implicit data type conversion? (Choose two.)

A. Collections can be implicitly converted to records.
B. RAW data types are always implicitly converted to a CLOB when used in a query.
C. Comparison between character value and a number value always implicitly converts the character value to the number data type.
D. Implicit data type conversion can negatively impact performance.
E. ROWIDS are always implicitly converted to a number when used in a query.

Answer: C,D

NEW QUESTION # 20
Which two are true about INDEX-BY tables? (Choose two.)

A. INDEX-BY table types can be created in PL/SQL blocks only.
B. INDEX-BY table types can be created with the CREATE TYPE statement.
C. The index can be integer or string.
D. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
E. The index can be integer only.

Answer: A,C

NEW QUESTION # 21
Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.
Which script will execute successfully?

Answer: A

NEW QUESTION # 22
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 # 23
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 # 24
Examine these statements from a block of code:

Which two are true? (Choose two.)

A. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
B. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
C. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
D. Only the PRICE column can be updated in the PRODUCTS table.
E. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

Answer: C,E

NEW QUESTION # 25
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

A. A function definition can be modified without dropping and re-creating it.
B. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
C. This clause can be used only for procedures and functions.
D. Function based indexes remain usable when replacing the function on which the index depends.
E. Object privileges to execute a replaced function are retained by those users who had the privileges.

Answer: A,E

NEW QUESTION # 26
Which two are true about exception handling? (Choose two.)

A. All declared exceptions are raised implicitly by the runtime system.
B. Internally defined exceptions can be handled only by the OTHERS exception handler.
C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
E. Predefined exceptions are globally declared in the standard package.

Answer: C,E

NEW QUESTION # 27
Which two are true about lexical units? (Choose two.)

A. A character literal with zero characters has the BOOLEAN value NULL.
B. Spaces can be embedded in delimiters.
C. Identifiers include labels.
D. All user-defined identifiers must start with an alphabet.
E. Character literals are case-sensitive.

Answer: D,E

NEW QUESTION # 28
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.)

Answer: A,D

NEW QUESTION # 29
Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

A. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
B. It will return an error at line 2.
C. It will return an error at line 3.
D. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
E. It will return an error at line 8.

Answer: D

NEW QUESTION # 30
Which three statements can process a dynamic multi-row query? (Choose three.)

A. DECLARE
B. CLOSE
C. FETCH
D. OPEN-FOR
E. INTO
F. WHEN
G. OPEN

Answer: B,C,D

NEW QUESTION # 31
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.)

Answer: A,C

NEW QUESTION # 32
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 HR 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 SH schema.

Answer: C,E

NEW QUESTION # 33
Which three are true about the procedure overloading feature? (Choose three.)

A. Each procedure must use named notation to specify the corresponding actual parameters.
B. Each procedure's formal parameters must differ in name.
C. Each procedure can be a nested subprogram.
D. Each procedure can be a packaged subprogram.
E. Each procedure must use positional notation to specify the corresponding actual parameters.
F. Each procedure can be a standalone subprogram.
G. Each procedure's formal parameters can differ in data type or name.

Answer: D,E,G

NEW QUESTION # 34
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?