Question

Which of the following object types below cannot be replicated?

(a) Data

(b) Trigger

(c) View

(d) Sequence

I had been asked this question at a job interview.

This interesting question is from Storing and Guarding the Data in chapter Oracle Database 11g Architecture Options of Oracle

Answer 1

Correct option is (d) Sequence

To elaborate: Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.