Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Sequence object types cannot be replicated - Oracle Replication
Home
>>
Category
>>
Oracle (MCQ) questions and answers
>>
Oracle Replication
Q. Which of the following object types cannot be replicated?
- Published on 12 Aug 15
a.
Data
b.
Trigger
c.
View
d.
Sequence
ANSWER: Sequence
Related Content
Oracle DBA (
67
)
Oracle Replication (
19
)
Oracle Architecture (
20
)
Oracle Transaction (
40
)
Administering and Managing an Oracle Database (
25
)
Managing Oracle Database Processes (
8
)
Oracle Control Files (
27
)
Oracle Redo Log (
23
)
Oracle Tablespaces (
24
)
Oracle Datafiles and Tempfiles (
13
)
Oracle Managed Files (
11
)
Oracle Schema (
26
)
Oracle Tables (
13
)
Oracle Indexes and Partitioned Tables (
24
)
Oracle Clusters (
24
)
Oracle Views, Sequences, and Synonyms (
15
)
Oracle Distributed Database concepts (
28
)
Discussion
Nirja Shah
-Posted on 18 Sep 15
- The following objects can be replicated:
1. Data (obviously)
2. Triggers, views, indexes, synonyms, etc. (with advanced replication)
- The following objects cannot be replicated
1. Sequences (Sequences needs to be created on each site to generate mutually exclusive sets of sequence numbers).
2. LONG and LONG RAW data types (Use LOBs instead)
➨
Post your comment / Share knowledge
Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
MCQs
English
Tutorials
Download
▲