Exam Prep Questions

1:Your users are trying to create a domain index (dom_col_key) on a column in a table that has been defined as a VARRAY column. The table already has two other indexes on it. They are getting an error saying that you cannot create an index on an expression with data type. What is the possible reason for the error?

  • A. The table already has too many indexes.

  • B. Domain indexes can't be built on columns that are VARRAY type.

  • C. The users don't have the proper authority to create the index.

  • D. They are using an invalid name for the index.

A1: Answer B is correct; domain indexes cannot be built on VARRAY columns. Answer A is incorrect; two indexes on a table is not an excessive number. Answer C is incorrect; improper authority would ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial