Computer Certification

  1. Home
  2. Computing & Technology
  3. Computer Certification
OCP Practice Test
20 Free OCP Practice Questions for the 1Z0-001 Exam

Answer 17

Correct answers: a, c, e

Explanation:

PL/SQL table methods are built-in subprograms (procedures or functions) that operate on tables and are called using dot notation (.).

  • EXISTS(n): Returns TRUE if the nth element in a PL/SQL table exists.
  • TRIM : Removes one element from the end of a PL/SQL table.
  • COUNT : Returns the number of elements that a PL/SQL table currently contains.

Choices B and F are incorrect because SUBSTR and UPPER are single-row character functions.

Choice D is incorrect because FLOOR is a single-row number function.

Next page > Question 18

Explore Computer Certification

About.com Special Features

Computer Certification

  1. Home
  2. Computing & Technology
  3. Computer Certification

©2009 About.com, a part of The New York Times Company.

All rights reserved.