1z0-149Free trialFree trial

By oracle
Aug, 2025

Verified

25Q per page

Question 1

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

  • A: PACKAGES
  • B: VARIABLES
  • C: ANONYMOUS BLOCK
  • D: TRIGGER BODY
  • E: DATABASE LINKS
—

Question 2

Which three are valid PL/SQL variable names? (Choose three.)

  • A: printer_name#
  • B: 1to7number
  • C: yesterday's_date
  • D: leap$year
  • E: Number_of_days_between_March_and_April
  • F: #printer_name
  • G: v_fname
—

Question 3

Which two are true about collections and RECORD types? (Choose two.)

  • A: A variable of RECORD type can contain fields of another RECORD type or any collection type.
  • B: Only associative arrays and nested tables can have elements of RECORD type.
  • C: All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
  • D: Collections and RECORD types are always dense.
  • E: All collections and RECORD types can be stored in table columns.
  • F: VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
—

Question 4

Examine this table in the SH schema:

Image 1

User SH executes this code:

Image 2

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:
—

Question 5

Examine this row of data from the EMPLOYEES table:

Image 1

Now, examine this block of code which executes successfully:

Image 2

What is the value of v_commission?

  • A: 5000
  • B: 15000
  • C: 2500
  • D: 10000
—

Question 6

Examine this table in the SH schema:

Image 1

Now, examine this code:

Image 2

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

  • A: In line 1, change IN OUT mode to IN mode.
  • B: In line 2, change IN OUT mode to IN mode.
  • C: In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
  • D: In line 1, add the default parameter DEFAULT 2000.
  • E: In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
  • F: In line 2, add the default parameter DEFAULT 2000.
—

Question 7

User ORA41 executes these statements successfully:

Image 1

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: The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
  • D: The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
  • E: ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
—

Question 8

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: 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.
—

Question 9

Examine these statements:

Image 1

Which is true?

  • A: It will result in a compilation error for protected_proc because calling_proc does not exist.
  • B: It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
  • C: It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
  • D: With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.
—

Question 10

Examine the EMPLOYEES table structure:

Image 1

Now, examine this code:

Image 2

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

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

Question 11

Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Image 1

Now, examine this block of code:

Image 2

Which two lines each result in a compilation error? (Choose two.)

  • A: line 1
  • B: line 6
  • C: line 8
  • D: line 2
  • E: line 3
  • F: line 7
—

Question 12

Which three are true about functions and procedures? (Choose three.)

  • A: The ACCESSIBLE BY clause can be used only for procedures.
  • B: In a function, every execution path must lead to a RETURN statement.
  • C: Both can have only constants as actual parameters for IN mode parameters.
  • D: Both can be invoked from within SQL statements.
  • E: In a procedure the RETURN statement cannot specify an expression.
  • F: In a function every RETURN statement must specify an expression.
—

That’s the end of your free questions

You’ve reached the preview limit for 1z0-149

Consider upgrading to gain full access!

Page 1 of 3 • Questions 1-25 of 59
123
→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!