Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Data changes in snap shot can be triggered - Oracle Replication
Home
>>
Category
>>
Oracle (MCQ) questions and answers
>>
Oracle Replication
Q. Data changes in a snap shot can be triggered ________.
- Published on 13 Aug 15
a.
Manually
b.
Automatically
c.
Both a and b
d.
Scheduled
ANSWER: Both a and b
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
- A snapshot contains on the remote site the data of the master table.
- All data changes are reflected in the snapshot after a refresh of the snapshot (either triggered manually or automatically).
- Example
CREATE SNAPSHOT emp
PCTFREE 15
STORAGE
(INITIAL 200K
NEXT 200K
PCTINCREASE 0)
TABLESPACE tab
USING INDEX
PCTFREE 0
STORAGE
(INITIAL 200K
NEXT 200K
PCTINCREASE 0)
TABLESPACE idx
REFRESH FORCE
START WITH SYSDATE NEXT SYSDATE+(1/1440) /* 60 SECONDS */
AS SELECT * FROM emp@QUO3;
➨
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
▲