Oracle 1Z0-149 Oracle Database 19c: Program with PL/SQL Exam Exam Practice Test Questions

• Question 1

  Which is true about counter variables in a FOR loop?

  • It must explicitly be declared.
  • It can be modified in the body of the loop.
  • It cannot be NULL.
  • It is accessible outside the body of the loop.

  Show Answer Answer: D, ,E, ,G Next

• Question 2

  • Answer: A ||

  Show Answer Answer: A, ,F Next

• Question 3

  Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

  • DISABLE
  • ENABLE
  • ERROR
  • ALL
  • SEVERE

  Show Answer Answer: D, ,E Next

• Question 4

  Which three are true about user-defined functions? (Choose three.)

  • They can be used in ORDER BY and GROUP BY clauses.
  • They can be executed as standalone commands.
  • They must be defined with at least one parameter.
  • They need not return any values.
  • They can appear in the select list of a SELECT statement.
  • Functions can call only other functions.
  • They can be used in CONNECT BY and START WITH clauses.

  Show Answer Answer: C, ,D, ,F Next

• Question 5

  Which is true about EXIT and CONTINUE statements?

  • They can be used in any type of loop.
  • They must have a WHEN condition.
  • They have the same effect on the execution of a loop.
  • They must use labels.

  Show Answer Answer: C, ,D, ,G Next